<?php
namespace app\admin\controller;
use app\admin\BaseController;
use app\admin\model\ReportCode;
use think\App;
use think\Exception;use think\facade\Config;
use think\facade\Db;
use think\facade\Cache;
class OrderInv extends BaseController{
public function __construct(App $app) {
parent::__construct($app);
}
/**
* 新建销售单开票申请
*/
public function create(){
$companyType = isset($this->post['companyType'])&&$this->post['companyType']!=='' ? trim($this->post['companyType']):"";
if ($companyType==''){
return error_show(1004,"参数 companyType 不能为空");
}
$buy_id = isset($this->post['buy_id'])&&$this->post['buy_id']!=='' ? intval($this->post['buy_id']):"";
if($buy_id==''){
return error_show(1004,"参数 buy_id 不能为空");
}
$buyinfo =Db::name("customer_invoice")->where(['id'=>$buy_id,"is_del"=>0])->find();
if($buyinfo==false){
return error_show(1004,"购买方发票信息未找到");
}
if($this->level==1){
$companyNo = isset($this->post['companyNo'])&&$this->post['companyNo']!=='' ? trim($this->post['companyNo']):"";
}
else{
$companyNo = isset($this->post['relaComNo'])&&$this->post['relaComNo']!=='' ? trim($this->post['relaComNo'])
:"";
}
if($companyNo==''){
return error_show(1004,"业务公司不能为空");
}
$company = Db::name("company_info")->where(["companyNo"=>$companyNo])->find();
if($company==false){
return error_show(1004,"销售方信息未找到");
}
// $khNo = isset($this->post['khNo'])&&$this->post['khNo']!=='' ? trim($this->post['khNo']):"";
// if($khNo==''){
// return error_show(1004,"参数 khNo 不能为空");
// }
// $customer = Db::name("customer_info")->where(["companyNo"=>$khNo])->find();
// if($customer==false){
// return error_show(1004,"客户信息未找到");
// }
$invtype = isset($this->post['invtype'])&&$this->post['invtype']!=='' ? intval($this->post['invtype']):"";
if($invtype==''){
return error_show(1004,"参数 invtype 不能为空");
}
$email = isset($this->post['email'])&&$this->post['email']!=='' ? trim($this->post['email']):"";
$remark = isset($this->post['remark'])&&$this->post['remark']!=='' ? trim($this->post['remark']):"";
$exam_remark = isset($this->post['exam_remark'])&&$this->post['exam_remark']!=='' ? trim($this->post['exam_remark']):"";
$orderArr = isset($this->post['orderArr'])&&!empty($this->post['orderArr']) ? $this->post['orderArr']:[];
if(empty($orderArr)){
return error_show(1004,"参数 orderArr 不能为空");
}
$temp =[];
$good=[];
$invNo=makeNo("INV");
$invfee=array_sum(array_column($orderArr,'inv_fee'));
Db::startTrans();
try{
foreach ($orderArr as $value){
if(!isset($value['sequenceNo']) ||$value['sequenceNo']==''){
Db::rollback();
return error_show(1004,"参数 sequenceNo 不能为空");
}
$qrd = Db::name("qrd_info")->where(["sequenceNo"=>$value['sequenceNo']])->find();
if($qrd['status']==2){
Db::rollback();
return error_show(1004,"确认单{$value['sequenceNo']}不参与对账");
}
if(!isset($value['inv_fee']) || $value['inv_fee']===''){
Db::rollback();
return error_show(1004,"参数 inv_fee 不能为空");
}
if($qrd['winv_fee']<$value['inv_fee']){
Db::rollback();
return error_show(1004,"确认单{$value['sequenceNo']}待开票金额不足");
}
$good_info = Db::name("good")->where(["spuCode"=>$qrd["goodNo"],"status"=>1])->findOrEmpty();
// if(empty($good_info)){
// Db::rollback();
// return error_show(1004,"确认单{$value['sequenceNo']}商品未确认开票类目");
// }
$num = DB::name("assoc")->alias("a")->leftJoin("invoice_good b","a.viceCode=b.invNo")
->where(["a.status"=>[1,2],"a.is_del"=>0,"a.type"=>1,"a.orderCode"=>$value['sequenceNo']])->sum("b.goodNum");
if($qrd['goodNum']-$num<$value['num']){
Db::rollback();
return error_show(1004,"确认单{$value['sequenceNo']}待开票数量不足");
}
$ascc=[
"assocNo"=>makeNo("AS"),
"apply_id"=>$this->uid,
"apply_name"=>$this->uname,
"type"=>1,
"orderCode"=>$value['sequenceNo'],
"customerNo"=>$qrd['customerNo'],
"viceCode"=>$invNo,
"order_total"=>$qrd['totalPrice'],
"vice_total"=>$invfee,
"cancel_fee"=>$value['inv_fee'],
"status"=>1,
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s")
];
$invoice_good=[
"invNo"=>$invNo,
"orderCode"=>$value['sequenceNo'],
"goodNo"=>$qrd['goodNo'],
"goodName"=>$good_info['inv_good_name']??$qrd['goodName'] ,
"catName"=>$good_info['inv_cat_name']??$qrd['thirdCat'],
"catNo"=>$good_info['inv_cat_code']??"",
"goodPrice"=>round($value['inv_fee']/$value['num'],8),
"unitName"=>$qrd['goodUnit'],
"goodNum"=>$value['num'],
"specInfo"=>$value['sequenceNo'],
"totalPrice"=>$value['inv_fee'],
"tax"=>$good_info['inv_tax']??$qrd['tax'],
"is_discount"=>$good_info['is_discount']??0,
"addTax"=>$good_info['addTax']??$qrd['tax'],
"inv_tag"=>$good_info['inv_tag']??"",
"taxPrice"=>round($value['inv_fee']*($good_info['addTax']??$qrd['tax']),2),
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s")
];
$update = [
"inv_fee"=>$qrd['inv_fee']+$value['inv_fee'],
"winv_fee"=>$qrd['winv_fee']-$value['inv_fee'],
"inv_status"=>2,
"status"=>1,
"updatetime"=>date("Y-m-d H:i:s")
];
$up = Db::name("qrd_info")->where($qrd)->update($update);
if($up==false){
Db::rollback();
return error_show(1005,"确认单{$value['sequenceNo']} 更新失败");
}
$temp[]=$ascc;
$good[]=$invoice_good;
$report=ReportCode::where(["qrdNo"=>$value['sequenceNo']])->find();
if($report)$report->setField("invNo",$invNo);
}
$associn = Db::name("assoc")->insertAll($temp);
if($associn==0){
Db::rollback();
return error_show(1005,"确认单申请开票失败");
}
$goodin = Db::name("invoice_good")->insertAll($good);
if($goodin==0){
Db::rollback();
return error_show(1005,"确认单申请开票失败");
}
$inv=[
"invNo"=>$invNo,
"inv_value"=>$invfee,
"inv_out"=> $companyNo,
"inv_company"=> $company['company_name'],
"apply_id"=>$this->uid,
"apply_name"=>$this->uname,
"inv_type"=>$invtype,//发票类型 专用 普通 电子专用 电子普通
"open_type"=>0, //开票类型 金税开票 金税线下 纯线下
"is_ticket"=>$company['out_ticket'], //是否支持金税开票
"company_type"=> $buyinfo['company_type'], //类型01 企业，02 机关事业单位，03 个人， 04 其他
"remark"=>$remark, //申请备注
"exam_remark"=>$exam_remark, //审核备注
"ainv_fee"=>0,//已核销金额
"winv_fee"=>$invfee,//未核销金额
"status"=>0,// 待财务开票/待金税开票 待财务审核 待填写物流 开票完成 开票失败/开票驳回 财务驳回
"is_del"=>0,
"email"=>$email,
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s")
];
$invin = Db::name("invoice_pool")->insert($inv);
if($invin){
$invinfo=[
"buyer_title"=>$buyinfo['invoice_title'],
"buyer_code"=>$buyinfo['invoice_code'],
"buyer_addr"=>$buyinfo['invoice_addr'],
"buyer_mobile"=>$buyinfo['invoice_mobile'],
"buyer_bank"=>$buyinfo['invoice_bank'],
"buyer_bankNo"=>$buyinfo['invoice_bankNo'],
"seller_title"=>$company['company_name'],
"seller_code"=>$company['company_license'],
"seller_addr"=>$company['company_address'],
"seller_mobile"=>$company['mobile'],
"seller_bank"=>$company['bank_name'],
"seller_bankNo"=>$company['bankNo'],
"invNo"=>$invNo,
"voider"=>$company['voider'],
"payee"=>$company['payee'],
"drawer"=>$company['drawer'],
"reviewer"=>$company['reviewer'],
"ownerPlace"=>$company['ownerPlace'],
"addtime"=>date("Y-m-d H:i:s")
];
$poolinfo =Db::name("invoice_pool_info")->insert($invinfo);
if($poolinfo){
Db::commit();
return app_show(0,"确认单发票申请成功",["invNo"=>$invNo]);
}
}
Db::rollback();
return error_show(1004,"确认单发票申请失败");
}catch (\Exception $e){
Db::rollback();
return error_show(1004,$e->getMessage());
}
}
// 0 待财务开票/待金税开票 1财务审核通过 2 金税开票中/验票中 3 开票成功 4 财务驳回 5 开票失败 6 发票退票/废弃
public function status(){
$invNo = isset($this->post['invNo'])&&$this->post['invNo']!=''?trim($this->post['invNo']):"";
if($invNo==""){
return error_show(1004,"参数 invNo 不能为空");
}
$invinfo = Db::name("invoice_pool")->where(["invNo"=>$invNo,"is_del"=>0])->find();
if($invinfo==false){
return error_show(1004,"发票申请数据未找到");
}
$status= isset($this->post['status'])&&$this->post['status']!==''?intval($this->post['status']):"";
if($status===''){
return error_show(1004,"参数 status 不能为空");
}
//open_type 1 金税开票 2 金税线下开票 3 线下开票
$open_type = isset($this->post['open_type'])&&$this->post['open_type']!==''?intval($this->post['open_type']):"";
$remark = isset($this->post['remark'])&&$this->post['remark']!=''?trim($this->post['remark']):"";
$invCode =isset($this->post['invCode'])&&$this->post['invCode']!=''?trim($this->post['invCode']):"";
$invNum =isset($this->post['invNum'])&&$this->post['invNum']!=''?trim($this->post['invNum']):"";
$open_date =isset($this->post['open_date'])&&$this->post['open_date']!=''?trim($this->post['open_date']):"";
$subtotal_fee =isset($this->post['subtotal_fee'])&&$this->post['subtotal_fee']!=''?floatval($this->post['subtotal_fee']):"";
$checkCode =isset($this->post['checkCode'])&&$this->post['checkCode']!=''?trim($this->post['checkCode']):"";
$update=[
"status"=> $status,
"exam_remark"=>$remark,
"updatetime" => date("Y-m-d H:i:s")
];
if($status==1){
if($open_type==='')return error_show(1004,"参数 open_type 不能为空");
$update['open_type']=$open_type;
if($open_type!=1){
if($invCode==='') return error_show(1004,"参数 invCode 不能为空");
if($invNum==='') return error_show(1004,"参数 invNum 不能为空");
if($open_date==='') return error_show(1004,"参数 open_date 不能为空");
if($invinfo['inv_type']==2 || $invinfo['inv_type']==3){
if($checkCode==='') return error_show(1004,"参数 checkCode 不能为空");
}
if($subtotal_fee==='') return error_show(1004,"参数 subtotal_fee 不能为空");
}
$status=2;
}
$update['status']=$status;
Db::startTrans();
try{
$invup =Db::name("invoice_pool")->where($invinfo)->update($update);
if($invup){
if($status==2&& $open_type!=1){
$invpool=[
"invNo"=>$invinfo['invNo'],
"inv_type"=>invoiceType($invinfo['inv_type']),
"inv_code"=>$invCode,
"inv_number"=>$invNum,
"check_code"=>$checkCode,
"inv_total"=>0,
"inv_subtotal"=>$subtotal_fee,
"open_date"=>$open_date,
'pdfstream'=>'',
"item"=>'',
"status"=>0,
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s")
];
$in = Db::name("invoice_ticket")->insert($invpool);
if($in==false){
Db::rollback();
return error_show(1004,"发票信息添加失败");
}
}
if($status==2 && $open_type==1){
$invpoolinfo =Db::name("invoice_pool_info")->where(["invNo"=>$invNo])->findOrEmpty();
if(empty($invpoolinfo)){
Db::rollback();
return error_show(1004,"开票信息未找到");
}
$goodinfo =Db::name("invoice_good")
->where(["invNo"=>$invNo,"is_del"=>0])
->field("0 as FPHXZ,
catNo as SPBM,
id as ZXBM,
is_discount as YHZCBS,
if(inv_tag=0,'',inv_tag) as LSLBS,
addTax as ZZSTSGL,
goodName as XMMC,
specInfo as GGXH,
unitName as DW,
goodNum as SPSL,
goodPrice as DJ,
totalPrice as JE,
1 HSBZ,
tax as SL,
taxPrice as SE")
->select()->toJson();
if(empty($goodinfo)){
Db::rollback();
return error_show(1004,"开票商品信息未找到");
}
$data=[
"invNo"=>$invNo,
"KPLX"=>"0",
"XHFSBH"=>$invpoolinfo['seller_code'],
"XHFMC"=>$invpoolinfo['seller_title'],
"XHFDZ"=>$invpoolinfo['seller_addr'],
"XHFDH"=>$invpoolinfo['seller_mobile'],
"XHFYH"=>$invpoolinfo['seller_bank'],
"XHFZH"=>$invpoolinfo['seller_bankNo'],
"GMFBM"=>"",
"GMFSBH"=>$invpoolinfo['buyer_code'],
"GMFMC"=>$invpoolinfo['buyer_title'],
"GMFDZ"=>$invpoolinfo['buyer_addr'],
"GMFDH"=>$invpoolinfo['buyer_mobile'],
"GMFYH"=>$invpoolinfo['buyer_bank'],
"GMFZH"=>$invpoolinfo['buyer_bankNo'],
"GMFLX"=>$invinfo['company_type'],
"GMFSJH"=>"",
"GMFDZYX"=>$invinfo['email'],
"KPR"=>$invpoolinfo['drawer'],
"SKR"=>$invpoolinfo['payee'],
"FHR"=>$invpoolinfo['reviewer'],
"QDBZ"=>"0",
"JSHJ"=>$invinfo['inv_value'],
"HJJE"=>"0",
"HJSE"=>"0",
"BZ"=>$invinfo['remark'],
"DDMXXX"=>$goodinfo,
"FPLXDM"=>invoiceType($invinfo['inv_type']),
"DDQQPCH"=>"",
"DDQQLSH"=>randomkeys(26).date("YmdHis"),
"status"=>"0",
"result"=>"",
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s")
];
$invoice=Db::name("invoice_interface")->insert($data);
if($invoice==false){
Db::rollback();
return error_show(1003,"开票信息生成失败");
}
Cache::push("invoiceList",$data["DDQQLSH"]);
}
if( $update['status']==3){
$qrdArr=Db::name("assoc")->where(["viceCode"=>$invNo,"is_del"=>0])->column("id,orderCode,cancel_fee");
if(!empty($qrdArr)){
foreach ($qrdArr as $value){
$qrdinfo =Db::name("qrd_info")->where(["sequenceNo"=>$value['orderCode']])->find();
if($qrdinfo==false){
Db::rollback();
return error_show(1003,"确认单信息未找到");
}
if($qrdinfo['inv_fee']<$value['cancel_fee']){
Db::rollback();
return error_show(1003,"确认单信息开票金额不足");
}
$update =[
"ainv_fee"=>$qrdinfo['ainv_fee']+$value['cancel_fee'],
"inv_fee"=>$qrdinfo['inv_fee']-$value['cancel_fee'],
"invtime"=>date("Y-m-d H:i:s"),
"inv_status"=>$qrdinfo['winv_fee']==0 &&($qrdinfo['inv_fee']-$value['cancel_fee'])==0 ? 3 : 2,
"updatetime"=>date("Y-m-d H:i:s"),
];
$qrdup = Db::name("qrd_info")->where($qrdinfo)->update($update);
if($qrdup==false){
Db::rollback();
return error_show(1003,"确认单信息更新失败");
}
$assoc=["status"=>2,"assoc_time"=>date("Y-m-d H:i:s"),"updatetime"=>date("Y-m-d H:i:s")];
$assocup =Db::name("assoc")->where($value)->update($assoc);
if($assocup==false){
Db::rollback();
return error_show(1003,"确认单关联信息更新失败");
}
}
}
}
if($status==4 ||$status==5 ){
$qrdArr=Db::name("assoc")->where(["viceCode"=>$invNo,"is_del"=>0])->column("id,orderCode,cancel_fee");
if(!empty($qrdArr)){
foreach ($qrdArr as $value){
$qrdinfo =Db::name("qrd_info")->where(["sequenceNo"=>$value['orderCode']])->find();
if($qrdinfo==false){
Db::rollback();
return error_show(1003,"确认单信息未找到");
}
if($qrdinfo['inv_fee']<$value['cancel_fee']){
Db::rollback();
return error_show(1003,"确认单信息开票金额不足");
}
$update =[
"winv_fee"=>$qrdinfo['winv_fee']+$value['cancel_fee'],
"inv_fee"=>$qrdinfo['inv_fee']-$value['cancel_fee'],
"inv_status"=>$qrdinfo['ainv_fee']==0 &&($qrdinfo['inv_fee']-$value['cancel_fee'])==0 ? 1 : 2,
"status"=>$qrdinfo['ainv_fee']==0 &&($qrdinfo['inv_fee']-$value['cancel_fee'])==0 ?0 : 1,
"updatetime"=>date("Y-m-d H:i:s"),
];
$qrdup = Db::name("qrd_info")->where($qrdinfo)->update($update);
if($qrdup==false){
Db::rollback();
return error_show(1003,"确认单信息更新失败");
}
$assoc=["status"=>3,"updatetime"=>date("Y-m-d H:i:s")];
$assocup =Db::name("assoc")->where($value)->update($assoc);
if($assocup==false){
Db::rollback();
return error_show(1003,"确认单关联信息更新失败");
}
$report=ReportCode::where(["qrdNo"=>$value['sequenceNo']])->find();
if($report)$report->rmField("invNo",$invinfo['invNo']);
}
}
}
Db::commit();
return app_show(0,"审核成功");
}
Db::rollback();
return error_show(1004,"审核失败");
}catch (\Exception $e){
Db::rollback();
return error_show(1004,$e->getMessage());
}
}
/**
* 发票设置物流
*/
public function SetPost(){
// @param invNo postCompany postCode postFee;
$invNo =isset($this->post['invNo'])&&$this->post['invNo']!="" ? trim($this->post['invNo']):"";
if($invNo==''){
return error_show(1004,"参数invNo不能为空");
}
$invinfo =Db::name("invoice_pool")->where(["invNo"=>$invNo,"is_del"=>0])->find();
if($invinfo==false){
return error_show(1004,"发票申请信息未找到");
}
if($invinfo['status']!=3) return error_show(1004,"发票审核未完成");
$post_company =isset($this->post['post_company'])&&$this->post['post_company']!="" ? trim($this->post['post_company']):"";
if($post_company==''){
return error_show(1004,"参数 post_company 不能为空");
}
$post_code =isset($this->post['post_code'])&&$this->post['post_code']!="" ? trim($this->post['post_code']):"";
if($post_code==''){
return error_show(1004,"参数 post_code 不能为空");
}
$post_fee =isset($this->post['post_fee'])&&$this->post['post_fee']!="" ? floatval($this->post['post_fee']):"0";
Db::startTrans();
try{
$data=[
"post_company"=>$post_company,
"post_code"=>$post_code,
"post_fee"=>$post_fee,
"updatetime"=>date("Y-m-d H:i:s")
];
$up =Db::name("invoice_pool")->where($invinfo)->update($data);
if($up){
$qrdArr=Db::name("assoc")->where(["viceCode"=>$invNo,"is_del"=>0])->column("id,orderCode,cancel_fee");
if(!empty($qrdArr)){
foreach ($qrdArr as $value){
$qrdinfo =Db::name("qrd_info")->where(["sequenceNo"=>$value['orderCode']])->find();
if($qrdinfo==false){
Db::rollback();
return error_show(1003,"确认单信息未找到");
}
if($qrdinfo['inv_fee']<$value['cancel_fee']){
Db::rollback();
return error_show(1003,"确认单信息开票金额不足");
}
$update =[
"ainv_fee"=>$qrdinfo['ainv_fee']+$value['cancel_fee'],
"inv_fee"=>$qrdinfo['inv_fee']-$value['cancel_fee'],
"invtime"=>date("Y-m-d H:i:s"),
"inv_status"=>$qrdinfo['winv_fee']==0 &&($qrdinfo['inv_fee']-$value['cancel_fee'])==0 ? 3 : 2,
"updatetime"=>date("Y-m-d H:i:s"),
];
$qrdup = Db::name("qrd_info")->where($qrdinfo)->update($update);
if($qrdup==false){
Db::rollback();
return error_show(1003,"确认单信息更新失败");
}
$assoc=["status"=>2,"assoc_time"=>date("Y-m-d H:i:s"),"updatetime"=>date("Y-m-d H:i:s")];
$assocup =Db::name("assoc")->where($value)->update($assoc);
if($assocup==false){
Db::rollback();
return error_show(1003,"确认单关联信息更新失败");
}
}
}
Db::commit();
return app_show(0,"更新成功");
}
Db::rollback();
return error_show(1003,"发票申请信息更新失败");
}catch (\Exception $e){
Db::rollback();
return error_show(1004,$e->getMessage());
}
}
/**
* 发票废弃使用
*/
public function Discard(){
$invNo = isset($this->post['invNo'])&&$this->post['invNo']!=''?trim($this->post['invNo']):"";
if($invNo=='') return error_show(1004,"参数invNo不能为空");
$invinfo =Db::name("invoice_pool")->where(["invNo"=>$invNo,"is_del"=>0])->find();
if($invinfo==false) return error_show(1004,"未找到对应发票申请数据");
if(!in_array($invinfo['status'],[1,2,3,4,5]))return error_show(1004,"发票状态无法废弃");
$company =Db::name("company_info")->where(["companyNo"=>$invinfo['inv_out']])->find();
if($company==false)return error_show(1004,"开票业务公司未找到");
$invoiceinfo =Db::name("invoice_ticket")->where(["invNo"=>$invNo])->find();
if($invoiceinfo==false)return error_show(1004,"发票详细信息未找到");
Db::startTrans();
try{
$invoice=Config::get("invoice");
$tax =new \TaxInvoice($invoice['appKey'],$invoice['appSecret'],$invoice['entCode']);
$result=$tax->DeprecateInvoices($company['company_license'],invoiceType($invoiceinfo['inv_type']),$invoiceinfo['inv_code'],$invoiceinfo['inv_number'],1);
if(isset($result['ZTDM']) && $result['ZTDM']=='050000'){
$up =Db::name("invoice_pool")->where($invinfo)->update(["status"=>6,"updatetime"=>date("Y-m-d H:i:s")]);
if($up){
$qrdArr=Db::name("assoc")->where(["viceCode"=>$invNo,"is_del"=>0,"status"=>[1,2]])->column("id,orderCode,cancel_fee");
if(!empty($qrdArr)){
foreach ($qrdArr as $value){
$qrdinfo =Db::name("qrd_info")->where(["sequenceNo"=>$value['orderCode']])->find();
if($qrdinfo==false){
Db::rollback();
return error_show(1003,"确认单信息未找到");
}
if ($invinfo['status']==3){
if($qrdinfo['ainv_fee']<$value['cancel_fee']){
Db::rollback();
return error_show(1003,"确认单信息开票金额不足");
}
$update =[
"ainv_fee"=>$qrdinfo['ainv_fee']-$value['cancel_fee'],
"winv_fee"=>$qrdinfo['winv_fee']+$value['cancel_fee'],
"inv_status"=>$qrdinfo['ainv_fee']==0 &&$qrdinfo['inv_fee'] ==0 ? 1: 2,
"updatetime"=>date("Y-m-d H:i:s"),
];
}else{
if($qrdinfo['inv_fee']<$value['cancel_fee']){
Db::rollback();
return error_show(1003,"确认单信息开票金额不足");
}
$update =[
"winv_fee"=>$qrdinfo['winv_fee']+$value['cancel_fee'],
"inv_fee"=>$qrdinfo['inv_fee']-$value['cancel_fee'],
"inv_status"=>$qrdinfo['ainv_fee']==0 &&($qrdinfo['inv_fee']-$value['cancel_fee']) ==0 ?1 : 2,
"updatetime"=>date("Y-m-d H:i:s"),
];
}
$qrdup = Db::name("qrd_info")->where($qrdinfo)->update($update);
if($qrdup==false){
Db::rollback();
return error_show(1003,"确认单信息更新失败");
}
$assoc=["status"=>3,"assoc_time"=>date("Y-m-d H:i:s"),"updatetime"=>date("Y-m-d H:i:s")];
$assocup =Db::name("assoc")->where($value)->update($assoc);
if($assocup==false){
Db::rollback();
return error_show(1003,"确认单关联信息更新失败");
}
}
}
Db::commit();
return app_show(0,"发票废弃成功");
}
}
Db::rollback();
return error_show(1004,"发票废弃失败");
}catch (\Exception $e){
Db::rollback();
return error_show(1004,$e->getMessage());
}
}
/**@param invNo return_reason remark 退票申请
* @return \think\response\Json|void
*/
public function ReturnAdd(){
$invNo = isset($this->post['invNo']) && $this->post['invNo']!=''? trim($this->post['invNo']) :'';
if($invNo==""){
return error_show(1004,"参数 invNo 不能为空");
}
$return_reason = isset($this->post['return_reason']) && $this->post['return_reason']!=''? trim($this->post['return_reason']) :'';
$remark = isset($this->post['remark']) && $this->post['remark']!=''? trim($this->post['remark']) :'';
if($return_reason==""){
return error_show(1004,"参数 return_reason 不能为空");
}
if($remark==""){
return error_show(1004,"参数 remark 不能为空");
}
$invinfo = Db::name("invoice_pool")->where(["invNo"=>$invNo,"is_del"=>0])->find();
if($invinfo==false){
return error_show(1004,"发票申请数据未找到");
}
if($invinfo['status']!=3){
return error_show(1004,"发票申请未完成");
}
$qrd =Db::name("assoc")->where(["viceCode"=>$invNo,"status"=>2,"is_del"=>0])->column("orderCode");
if(empty($qrd)){
return error_show(1004,"未找到开票的销售单信息");
}
$returnCode = makeNo("RIN");
$data=[
"returnCode"=>$returnCode,
"invNo"=>$invNo,
"reason"=>$return_reason,
"remark"=>$remark,
"status"=>0,
"apply_id"=>$this->uid,
"apply_name"=>$this->uname,
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s")
];
Db::startTrans();
try{
$inter = Db::name("invoice_return")->insert($data);
if($inter){
foreach ($qrd as $value){
$report=ReportCode::where(["qrdNo"=>$value])->find();
if($report)$report->setField("returnInv",$returnCode);
}
Db::commit();
return app_show(0,"退票申请新建成功",["returnCode"=>$returnCode]);
}else{
Db::rollback();
return error_show(1005,"退票申请新建失败");
}
}catch (\Exception $e){
Db::rollback();
return error_show(1006,$e->getMessage());
}
}
// 0 待审核 1 待退票 2 退票成功 3 驳回4 退票失败 5 退票进行中
public function ReturnStatus(){
$returnCode = isset($this->post['returnCode'])&&$this->post['returnCode']!="" ? trim($this->post['returnCode']):"";
if($returnCode==""){
return error_show(1005,"参数 returnCode 不能为空");
}
$status = isset($this->post['status'])&&$this->post['status']!="" ? intval($this->post['status']):"";
if ($status==""){
return error_show(1005,"参数 status 不能为空");
}
$remark =isset($this->post['remark'])&&$this->post['remark']!="" ? trim($this->post['remark']):"";
if($remark==""){
return error_show(1005,"参数 remark 不能为空");
}
$return_reason =isset($this->post['return_reason'])&&$this->post['return_reason']!="" ? trim($this->post['return_reason']):"";
$return= Db::name("invoice_return")->where(["returnCode"=>$returnCode])->find();
if($return==false){
return error_show(1005,"退票申请信息未找到");
}
$invinfo = Db::name("invoice_pool")->where(["invNo"=>$return['invNo'],"is_del"=>0])->find();
if($invinfo==false){
return error_show(1004,"发票申请数据未找到");
}
if($invinfo['status']!=3){
return error_show(1004,"发票申请未完成");
}
$qrd =Db::name("assoc")->where(["viceCode"=>$return['invNo'],"status"=>2,"is_del"=>0])->column("orderCode");
if(empty($qrd)){
return error_show(1004,"未找到开票的销售单信息");
}
$ticket = Db::name("invoice_ticket")->where(["invNo"=>$return['invNo'],"type"=>0,"status"=>1,"is_del"=>0])
->findOrEmpty();
if(empty($ticket)){
return error_show(1004,"未找到开票的票面信息");
}
$return_type = isset($this->post['return_type'])&&$this->post['return_type']!="" ? intval($this->post['return_type']):0;
if($status==1){
if ($return_type==""){
return error_show(1005,"参数 return_type 不能为空");
}
if($return_type==1){
$red =0;
if($ticket["inv_type"]=='004' || $ticket["inv_type"]=='028'){
$red =1;
}
}else{
$invCode =isset($this->post['invCode'])&&$this->post['invCode']!=''?trim($this->post['invCode']):"";
$invNum =isset($this->post['invNum'])&&$this->post['invNum']!=''?trim($this->post['invNum']):"";
$open_date =isset($this->post['open_date'])&&$this->post['open_date']!=''?trim($this->post['open_date']):"";
$checkCode =isset($this->post['checkCode'])&&$this->post['checkCode']!=''?trim($this->post['checkCode']):"";
$subtotal_fee =isset($this->post['subtotal_fee'])&&$this->post['subtotal_fee']!=''?floatval($this->post['subtotal_fee']):"";
if($invCode==='') return error_show(1004,"参数 invCode 不能为空");
if($invNum==='') return error_show(1004,"参数 invNum 不能为空");
if($open_date==='') return error_show(1004,"参数 open_date 不能为空");
if($invinfo['inv_type']==2 || $invinfo['inv_type']==3){
if($checkCode==='') return error_show(1004,"参数 checkCode 不能为空");
}
if($subtotal_fee==='') return error_show(1004,"参数 subtotal_fee 不能为空");
}
}
Db::startTrans();
try{
$update=["status"=>$status, "return_reason"=>$return_reason,"return_type"=>$return_type,"remark"=>$remark,"updatetime"=>date("Y-m-d H:i:s")];
$up =Db::name("invoice_return")->where($return)->update($update);
if($up){
if($status==1){
if($return_type==1){
if($red==0){
$this->addRedOpen($ticket,$return_reason,$invinfo['company_type'], $returnCode);
}
if($red==1){
if(date("Y-m",strtotime($ticket["open_date"]))==date("Y-m")){
$this->addDiscard($ticket,$returnCode);
}else{
$this->addApplyRed($ticket,$returnCode);
}
}
}else{
$invpool=[
"invNo"=>$invinfo['invNo'],
"type"=>1,
"inv_type"=>$ticket['inv_type'],
"inv_code"=>$invCode,
"inv_number"=>$invNum,
"check_code"=>$checkCode,
"inv_total"=>0,
"inv_subtotal"=>$subtotal_fee,
"open_date"=>$open_date,
"item"=>'',
'pdfstream'=>'',
"status"=>0,
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s")
];
$in = Db::name("invoice_ticket")->insert($invpool);
if($in==false){
Db::rollback();
return error_show(1004,"发票信息添加失败");
}
}
}
if($status==2){
$qrdArr=Db::name("assoc")->where(["viceCode"=>$return['invNo'],"is_del"=>0,"status"=>[1,2]])->column("id,orderCode,cancel_fee");
if(!empty($qrdArr)){
foreach ($qrdArr as $value){
$qrdinfo =Db::name("qrd_info")->where(["sequenceNo"=>$value['orderCode']])->find();
if($qrdinfo==false){
Db::rollback();
return error_show(1003,"确认单信息未找到");
}
if($qrdinfo['inv_fee']<$value['cancel_fee']){
Db::rollback();
return error_show(1003,"确认单信息开票金额不足");
}
$update =[
"winv_fee"=>$qrdinfo['winv_fee']+$value['cancel_fee'],
"inv_fee"=>$qrdinfo['inv_fee']-$value['cancel_fee'],
"inv_status"=>$qrdinfo['ainv_fee']==0 &&$qrdinfo['inv_fee']==0 ? 1 : 2,
"status"=>$qrdinfo['ainv_fee']==0 &&$qrdinfo['inv_fee']==0 && $qrdinfo['pay_status'] ?0 : 1,
"updatetime"=>date("Y-m-d H:i:s"),
];
$qrdup = Db::name("qrd_info")->where($qrdinfo)->update($update);
if($qrdup==false){
Db::rollback();
return error_show(1003,"确认单信息更新失败");
}
$assoc=["status"=>3,"updatetime"=>date("Y-m-d H:i:s")];
$assocup =Db::name("assoc")->where($value)->update($assoc);
if($assocup==false){
Db::rollback();
return error_show(1003,"确认单关联信息更新失败");
}
}
}
// $up=Db::name("invoice_pool")->where($invinfo)->update(["status"=>6,"updatetime"=>date("Y-m-d
// H:i:s")]);
// if($up==false){
// Db::rollback();
// return error_show(1003,"发票信息更新失败");
// }
}
if($status==3 || $status==4){
foreach ($qrd as $value){
$report=ReportCode::where(["qrdNo"=>$value])->find();
if($report)$report->rmField("returnInv",$returnCode);
}
}
Db::commit();
return app_show(0,"退票申请信息更新成功");
}
Db::rollback();
return error_show(1005,"退票申请信息更新失败");
}catch (\Exception $e){
Db::rollback();
return error_show(1005,$e->getMessage());
}
}
//红冲票
public function returnRed(){
$returnCode = isset($this->post['returnCode'])&&$this->post['returnCode']!="" ? trim($this->post['returnCode']):"";
if($returnCode==""){
return error_show(1005,"参数 returnCode 不能为空");
}
$return= Db::name("invoice_return")->where(["returnCode"=>$returnCode])->find();
if($return==false){
return error_show(1005,"退票申请信息未找到");
}
$redinv =isset($this->post['redinv'])&&$this->post['redinv']!="" ? trim($this->post['redinv']):"";
if($redinv==""){
return error_show(1005,"参数 redinv 不能为空");
}
$red =Db::name("invoice_red")->where(["invRed"=>$redinv,"is_del"=>0])->findOrEmpty();
if(empty($red)) return error_show(1005,"红冲发票信息未找到");
if($red['status']!=4) return error_show(1005,"红冲发票开票未完成");
$invinfo = Db::name("invoice_pool")->where(["invNo"=>$return['invNo'],"is_del"=>0])->find();
if($invinfo==false){
return error_show(1005,"发票申请信息未找到");
}
Db::startTrans();
try{
$update=["status"=>2,"red_inv"=>$redinv,"updatetime"=>date("Y-m-d H:i:s")];
$up =Db::name("invoice_return")->where($return)->update($update);
if($up){
$invup = ["status"=>6,"updatetime"=>date("Y-m-d H:i:s")];
$inv=Db::name("invoice_pool")->where($invinfo)->update($invup);
if($inv){
$qrdArr=Db::name("assoc")->where(["viceCode"=>$return['invNo'],"is_del"=>0])->column("id,orderCode,cancel_fee");
if(!empty($qrdArr)){
foreach ($qrdArr as $value){
$qrdinfo =Db::name("qrd_info")->where(["sequenceNo"=>$value['orderCode']])->find();
if($qrdinfo==false){
Db::rollback();
return error_show(1003,"确认单信息未找到");
}
if($qrdinfo['inv_fee']<$value['cancel_fee']){
Db::rollback();
return error_show(1003,"确认单信息开票金额不足");
}
$update =[
"winv_fee"=>$qrdinfo['winv_fee']+$value['cancel_fee'],
"inv_fee"=>$qrdinfo['inv_fee']-$value['cancel_fee'],
"inv_status"=>$qrdinfo['ainv_fee']==0 &&$qrdinfo['inv_fee']==0 ? 1 : 2,
"status"=>$qrdinfo['ainv_fee']==0 &&$qrdinfo['inv_fee']==0 && $qrdinfo['pay_status'] ?0 : 1,
"updatetime"=>date("Y-m-d H:i:s"),
];
$qrdup = Db::name("qrd_info")->where($qrdinfo)->update($update);
if($qrdup==false){
Db::rollback();
return error_show(1003,"确认单信息更新失败");
}
$assoc=["status"=>3,"updatetime"=>date("Y-m-d H:i:s")];
$assocup =Db::name("assoc")->where($value)->update($assoc);
if($assocup==false){
Db::rollback();
return error_show(1003,"确认单关联信息更新失败");
}
}
}
Db::commit();
return app_show(0,"退票申请信息更新成功");
}
}
Db::rollback();
return error_show(1005,"退票申请信息更新失败");
}catch (\Exception $e){
Db::rollback();
return error_show(1005,$e->getMessage());
}
}
//退票详情
public function returnInfo(){
$returnCode = isset($this->post['returnCode'])&&$this->post['returnCode']!="" ? trim($this->post['returnCode']):"";
if($returnCode==""){
return error_show(1005,"参数 returnCode 不能为空");
}
$return= Db::name("invoice_return")->where(["returnCode"=>$returnCode])->find();
if($return==false){
return error_show(1005,"退票申请信息未找到");
}
$invinfo = Db::name("invoice_pool")->where(["invNo"=>$return['invNo'],"is_del"=>0])->find();
$return['inv_out']= $invinfo['inv_out']??"";
$return['inv_value']= $invinfo['inv_value']??"";
$return['inv_apply_id']= $invinfo['apply_id']??"";
$return['inv_apply_name']= $invinfo['apply_name']??"";
$return['inv_type']= $invinfo['inv_type']??"";
$return['open_type']= $invinfo['open_type']??"";
$return['is_ticket']= $invinfo['is_ticket']??"";
$return['email']= $invinfo['email']??"";
$return['post_code']= $invinfo['post_code']??"";
$return['post_company']= $invinfo['post_company']??"";
$poolinfo = Db::name("invoice_pool_info")->where(["invNo"=>$return['invNo']])->find();
$return['buyer_title'] = $poolinfo['buyer_title']??'';
$return['buyer_title'] = $poolinfo['buyer_title']??'';
$return['buyer_code'] = $poolinfo['buyer_code']??'';
$return['buyer_addr'] = $poolinfo['buyer_addr']??'';
$return['buyer_mobile'] = $poolinfo['buyer_mobile']??'';
$return['buyer_bank'] = $poolinfo['buyer_bank']??'';
$return['buyer_bankNo'] = $poolinfo['buyer_bankNo']??'';
$return['seller_title'] = $poolinfo['seller_title']??'';
$return['seller_addr'] = $poolinfo['seller_addr']??'';
$return['seller_code'] = $poolinfo['seller_code']??'';
$return['seller_mobile'] = $poolinfo['seller_mobile']??'';
$return['seller_bank'] = $poolinfo['seller_bank']??'';
$return['seller_bankNo'] = $poolinfo['seller_bankNo']??'';
$return['voider'] = $poolinfo['voider']??'';
$return['payee'] = $poolinfo['payee']??'';
$return['drawer'] = $poolinfo['drawer']??'';
$return['reviewer'] = $poolinfo['reviewer']??'';
$return['ownerPlace'] = $poolinfo['ownerPlace']??'';
$orderList =Db::name("invoice_good")->where(["invNo"=>$return['invNo'],"is_del"=>0])->select()->toArray();
$return['goodList']=$orderList;
$info =Db::name("invoice_ticket")->where(["invNo"=>$return['invNo'],"type"=>0]) ->field("inv_number,inv_code")->find();
$return['inv_number']=$info['inv_number']??"";
$return['inv_code']=$info['inv_code']??"";
return app_show(0,"获取成功",$return);
}
/**
*发票池列表
*/
public function list(){
$page=isset($this->post['page'])&&$this->post['page']!="" ? intval($this->post['page']) :1;
$size=isset($this->post['size'])&&$this->post['size']!="" ? intval($this->post['size']) :15;
$condition=[["a.is_del","=",0]];
$start = isset($this->post['start'])&&$this->post['start']!="" ? trim($this->post['start']) :"";
$end = isset($this->post['end'])&&$this->post['end']!="" ? trim($this->post['end']) :"";
if($start!=""){
$condition[]=["a.addtime",">=",$start." 00:00:00"];
}
if($end!=""){
$condition[]=["a.addtime","<=",$end." 23:59:59"];
}
$status= isset($this->post['status'])&&$this->post['status']!=="" ? intval($this->post['status']):"";
if($status!==""){
$condition[]=["a.status","=",$status];
}
$inv_type = isset($this->post['inv_type'])&&$this->post['inv_type']!=="" ? intval($this->post['inv_type']):"";
if($inv_type!==""){
$condition[]=["a.inv_type","=",$inv_type];
}
$inv_out= isset($this->post['inv_out'])&&$this->post['inv_out']!=="" ? trim($this->post['inv_out']):"";
if($inv_out!==""){
$condition[]=["a.inv_out","=",$inv_out];
}
// $inv_in = isset($this->post['inv_in'])&&$this->post['inv_in']!=="" ? trim($this->post['inv_in']):"";
// if($inv_in!==""){
// $condition[]=["a.inv_in","=",$inv_in];
// }
$invNo = isset($this->post['invNo'])&&$this->post['invNo']!=="" ? trim($this->post['invNo']):"";
if($invNo!==""){
$condition[]=["a.invNo","like","%$invNo%"];
}
$relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :"";
if($relaComNo!=""){
$condition[]=["a.inv_out","=",$relaComNo];
}
$inv_number = isset($this->post['inv_number'])&&$this->post['inv_number']!=="" ? trim($this->post['inv_number']):"";
if($inv_number!==""){
$condition[]=["c.inv_number","like","%$inv_number%"];
}
$inv_code = isset($this->post['inv_code'])&&$this->post['inv_code']!=="" ? trim($this->post['inv_code']):"";
if($inv_code!==""){
$condition[]=["c.inv_code","like","%$inv_code%"];
}
$inv_company = isset($this->post['inv_company'])&&$this->post['inv_company']!=="" ? trim($this->post['inv_company']):"";
if($inv_company!==""){
$condition[]=["a.inv_company","like","%$inv_company%"];
}
$buyer_name = isset($this->post['buyer_name'])&&$this->post['buyer_name']!=="" ? trim($this->post['buyer_name']):"";
if($buyer_name!==""){
$condition[]=["b.buyer_title","like","%$buyer_name%"];
}
$apply_id = isset($this->post['apply_id'])&&$this->post['apply_id']!=="" ? intval($this->post['apply_id']):"";
if($apply_id!==""){
$condition[]=["a.apply_id","=",$apply_id];
}
$apply_name = isset($this->post['apply_name'])&&$this->post['apply_name']!==""?trim($this->post['apply_name']) :"";
if($apply_name!==""){
$condition[]=["a.apply_name","like","%$apply_name%"];
}
$count=Db::name("invoice_pool")->alias("a")
->leftJoin("invoice_pool_info b","a.invNo=b.invNo")
->leftJoin("invoice_ticket c","a.invNo=c.invNo and c.type=0")
->where($condition)->count();
$total =ceil($count/$size);
$page= $page>$total ? intval($total):$page;
$list=Db::name("invoice_pool")->alias("a")
->leftJoin("invoice_pool_info b","a.invNo=b.invNo")
->leftJoin("invoice_ticket c","a.invNo=c.invNo and c.type=0")
->where($condition)->field("b.*,a.*,c.inv_code,c.inv_number,c.open_date,c.type")
->page($page,$size)->order("a.addtime desc")->select()->toArray();
return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
}
//获取发票详情
public function info(){
$invNo = isset($this->post['invNo'])&& $this->post['invNo']!='' ? trim($this->post['invNo']):"";
if($invNo==''){
return error_show(1004,"参数 invNo 不能为空");
}
$poolinfo =Db::name("invoice_pool")->where([["invNo","=",$invNo],["is_del","=",0]])->findOrEmpty();
if(empty($poolinfo)){
return error_show(1004,"为找到开票信息");
}
$pool = Db::name("invoice_pool_info")->where(["invNo"=>$invNo])->find();
$poolinfo['buyer_title'] = $pool['buyer_title']??'';
$poolinfo['buyer_code'] = $pool['buyer_code']??'';
$poolinfo['buyer_addr'] = $pool['buyer_addr']??'';
$poolinfo['buyer_mobile'] = $pool['buyer_mobile']??'';
$poolinfo['buyer_bank'] = $pool['buyer_bank']??'';
$poolinfo['buyer_bankNo'] = $pool['buyer_bankNo']??'';
$poolinfo['seller_title'] = $pool['seller_title']??'';
$poolinfo['seller_addr'] = $pool['seller_addr']??'';
$poolinfo['seller_code'] = $pool['seller_code']??'';
$poolinfo['seller_mobile'] = $pool['seller_mobile']??'';
$poolinfo['seller_bank'] = $pool['seller_bank']??'';
$poolinfo['seller_bankNo'] = $pool['seller_bankNo']??'';
$poolinfo['voider'] = $pool['voider']??'';
$poolinfo['payee'] = $pool['payee']??'';
$poolinfo['drawer'] = $pool['drawer']??'';
$poolinfo['reviewer'] = $pool['reviewer']??'';
$poolinfo['ownerPlace'] = $pool['ownerPlace']??'';
$orderList =Db::name("invoice_good")->where(["invNo"=>$invNo,"is_del"=>0])->select()->toArray();
$poolinfo['goodList']=$orderList;
$poolinfo['invinfo']=Db::name("invoice_ticket")->withoutField("pdfstream")->where(["invNo"=>$invNo,"type"=>0,"is_del"=>0])
->findOrEmpty();
$orderinfo = Db::name("assoc")->alias("a")->leftJoin("qrd_info c","a.orderCode=c.sequenceNo")
->where(["a.viceCode"=>$invNo,"a.is_del"=>0,"a.status"=>[1,2]])
->order("a.addtime desc")
->field("a.orderCode,c.goodName,c.catInfo,c.goodUnit,c.tax,c.goodNum,c.goodPrice,c.totalPrice,a.cancel_fee")
->select()->toArray();
$poolinfo['orderinfo']=$orderinfo;
return app_show(0,"获取成功",$poolinfo);
}
//退票列表
public function returnList(){
$page=isset($this->post['page'])&&$this->post['page']!="" ? intval($this->post['page']) :1;
$size=isset($this->post['size'])&&$this->post['size']!="" ? intval($this->post['size']) :15;
$condition=[["b.is_del","=",0]];
$start = isset($this->post['start'])&&$this->post['start']!="" ? trim($this->post['start']) :"";
$end = isset($this->post['end'])&&$this->post['end']!="" ? trim($this->post['end']) :"";
$companyNo = isset($this->post['companyNo'])&&$this->post['companyNo']!="" ? trim($this->post['companyNo']) :"";
if($companyNo!=""){
$condition[]=["b.inv_out","=",$companyNo];
}
$relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :"";
if($relaComNo!=""){
$condition[]=["b.inv_out","=",$relaComNo];
}
if($start!=""){
$condition[]=["a.addtime",">=",$start." 00:00:00"];
}
if($end!=""){
$condition[]=["a.addtime","<=",$end." 23:59:59"];
}
$inv_type = isset($this->post['inv_type'])&&$this->post['inv_type']!=="" ? intval($this->post['inv_type']):"";
if($inv_type!==""){
$condition[]=["b.inv_type","=",$inv_type];
}
$apply_id = isset($this->post['apply_id'])&&$this->post['apply_id']!=="" ? intval($this->post['apply_id']):"";
if($apply_id!==""){
$condition[]=["a.apply_id","=",$apply_id];
}
$apply_name = isset($this->post['apply_name'])&&$this->post['apply_name']!==""?trim($this->post['apply_name']) :"";
if($apply_name!==""){
$condition[]=["a.apply_name","like","%$apply_name%"];
}
$status= isset($this->post['status'])&&$this->post['status']!=="" ? intval($this->post['status']):"";
if($status!==""){
$condition[]=["a.status","=",$status];
}
$invNo = isset($this->post['invNo'])&&$this->post['invNo']!=="" ? trim($this->post['invNo']):"";
if($invNo!==""){
$condition[]=["a.invNo","like","%$invNo%"];
}
$returnCode = isset($this->post['returnCode'])&&$this->post['returnCode']!=="" ? trim($this->post['returnCode']):"";
if($returnCode!==""){
$condition[]=["a.returnCode","like","%$returnCode%"];
}
$count=Db::name("invoice_return")->alias("a")
->leftJoin("invoice_pool b","a.invNo=b.invNo")
->leftJoin("invoice_pool_info c","a.invNo=c.invNo")
->where($condition)->count();
$total =ceil($count/$size);
$page= $page>$total ? intval($total):$page;
$list=Db::name("invoice_return")->alias("a")
->leftJoin("invoice_pool b","a.invNo=b.invNo")
->leftJoin("invoice_pool_info c","a.invNo=c.invNo")
->where($condition)->page($page,$size)->field("a.*,c.buyer_title,c.buyer_code,c.buyer_addr,c.buyer_mobile,c.buyer_bank,
c.buyer_bankNo,c.seller_title,c.seller_code,c.seller_addr,c.seller_mobile,c.seller_bank,c.seller_bankNo,c.voider,c.payee,
c.drawer,c.reviewer,c.ownerPlace,b.inv_value,b.inv_out,b.inv_type,b.open_type,is_ticket,b.email,
b.winv_fee,b.ainv_fee,b.post_fee,b.post_company,b.post_code")->order("id desc")->select()->toArray();
foreach ($list as &$value){
$company =Db::name("company_info")->where(["companyNo"=>$value['inv_out']])->find();
$value['companyName'] = $company['company_name']??"";
}
return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
}
//红冲申请
public function applyRed(){
$invNo = isset($this->post['invNo'])&&$this->post['invNo']!=''?trim($this->post['invNo']):"";
if($invNo=='')return error_show(1004,"参数 invNo 不能为空");
$invfo =Db::name("invoice_pool")->where(["invNo"=>$invNo,"is_del"=>0])->find();
if($invfo==false) return error_show(1004,"发票数据未找到");
if(!in_array($invfo['status'],[1,2,3,4,5]))return error_show(1004,"发票数据状态无法申请");
$ticket =Db::name("invoice_ticket")->where(["invNo"=>$invNo])->findOrEmpty();
if(empty($ticket)) return error_show(1004,"未找到开票信息");
$company =Db::name("company_info")->where(["companyNo"=>'GS2207150956046617'])->findOrEmpty();
if(empty($company)) return error_show(1004,"业务企业信息未找到");
$invoice=Config::get("invoice");
$Tax =new \TaxInvoice($invoice['appKey'],$invoice['appSecret'],$invoice['entCode']);
$redticketList=[];
$redticketArry=[
"SQBSCQQPCH"=>randomkeys(26).date("YmdHis"),
"NSRSBH"=>$company['company_license'],
"FPLXDM"=>invoiceType($invfo['inv_type']),
];
$goodinfo =Db::name("invoice_good")
->where(["invNo"=>$invNo,"is_del"=>0])
->field("0 as FPHXZ,
catNo as SPBM,
id as ZXBM,
is_discount as YHZCBS,
if(inv_tag=0,'',inv_tag) as LSLBS,
addTax as ZZSTSGL,
goodName as XMMC,
'' as DW,
'' as SPSL,
'' as DJ,
(-totalPrice) as JE,
0 HSBZ,
tax as SL,
-taxPrice as SE")->select()->toArray();
if(empty($goodinfo)){
Db::rollback();
return error_show(1004,"开票商品信息未找到");
}
if(count($goodinfo)>8){
$len =array_unique(array_column($goodinfo,'SL'));
$qdmx=["FPHXZ"=>6,
"SPBM"=>'',
"XMMC"=>"详见对应正数发票及清单",
"YHZCBS"=>0,
"LSLBS"=>'',
"ZZSTSGL"=>'',
"DW"=>'',
"SPSL"=>'',
"DJ"=>'',
"JE"=>sprintf("%01.2f", (array_sum(array_column($goodinfo,'JE')))),
"HSBZ"=>'0',
"SL"=>count($len)>1?'':$len[0],
"SE"=>sprintf("%01.2f",array_sum(array_column($goodinfo,'SE'))),
];
}else
{
$qdmx=$goodinfo;
}
$info=[
"SQBSCQQLSH"=>randomkeys(26).date("YmdHis"),
"YYSBZ"=> "0000000000", //营业税标志
"XXBLX"=> "0",//信息表类型 0 正常；1 逾期(仅销方开具)
"YFPDM"=>$ticket['inv_code'], //红字专票购方已抵扣可不填
"YFPHM"=> $ticket['inv_number'],//红字专票购方已抵扣可不填
"YFPKPRQ"=>$ticket['open_date'], //红字专票购方已抵扣可不填
"TKSJ"=>date("YmdHis"), //填开时间
"XHFSBH"=>$ticket['seller_id'],
"XHFMC"=>$ticket['seller_title'],
"GMFSBH"=>$ticket['buyer_id'],
"GMFMC"=> $ticket['buyer_title'],
"HJJE"=> "-".$ticket['inv_subtotal'],//合计金额(不含 税)
"HJSE"=>"-".$ticket['tax_fee'],//合计税额
"SQSM"=>"1100000000", //申请说明
"XXBTSBS"=>"0",//0: 正常;1:成品油发票，涉及销售数量 变更（销货退回、开票有误等原因）;2: 成品油发票，仅涉及销售金额变更（销 售折让）;3:机动车发票，仅涉及销售数
//量变更（销货退回、开票有误等原因）;4: 机动车发票，仅涉及销售金额变更（销 售折让）
];
$invRed=makeNo("IRE");
$data=[
'invNo'=>$invNo,
"invRed"=>$invRed,
"inv_out"=>$invfo['inv_out']??"",
"apply_id"=>$this->uid,
"apply_name"=>$this->uname,
"status"=>0,
"remark"=>'',
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s"),
"SQBSCQQLSH"=>$info['SQBSCQQLSH'],
"YYSBZ"=> "0000000000", //营业税标志
"XXBLX"=> "0",//信息表类型 0 正常；1 逾期(仅销方开具)
"YFPDM"=>$ticket['inv_code'], //红字专票购方已抵扣可不填
"YFPHM"=> $ticket['inv_number'],//红字专票购方已抵扣可不填
"YFPKPRQ"=>$ticket['open_date'], //红字专票购方已抵扣可不填
"TKSJ"=>date("YmdHis"), //填开时间
"XHFSBH"=>$ticket['seller_id'],
"XHFMC"=>$ticket['seller_title'],
"GMFSBH"=>$ticket['buyer_id'],
"GMFMC"=> $ticket['buyer_title'],
"HJJE"=> "-".$ticket['inv_subtotal'],//合计金额(不含 税)
"HJSE"=>"-".$ticket['tax_fee'],//合计税额
"SQSM"=>"1100000000", //申请说明
"XXBTSBS"=>"0",
"DDMXXX"=>json_encode($qdmx,JSON_UNESCAPED_UNICODE),
"SQBSCQQPCH"=>$redticketArry['SQBSCQQPCH'],
"FPLXDM"=>invoiceType($invfo['inv_type']),
];
$redticketList[]=["HZSQDTXX"=>$info,"DDMXXX"=>$qdmx];
$result=$Tax->AllocateRedInvoiceApplication($redticketArry,$redticketList);
$data['status']=5;
$data['remark']='红冲申请提交失败';
if(isset($result['ZTDM']) && $result['ZTDM']=='060000'){
$resultChild=$result['HZSQDSCJG'][0];
if($resultChild['ZTDM']=='060000'){
$data['status']=2;
$data['XXBBH']=$resultChild['XXBBH'];
$data['remark']='红冲申请审核通过';
}
if($resultChild['ZTDM']=='060001'){
$data['status']=1;
$data['XXBBH']=$resultChild['XXBBH'];
$data['remark']='红冲申请审核中';
}
}
if($data['status']==5){
return error_show(1004,"红冲发票申请新建失败");
}
$up =Db::name("invoice_red")->insert($data);
return $up ? app_show(0,"红冲发票申请新建成功",["invRed"=>$invRed]):error_show(1004,"红冲发票申请新建失败");
}
//批量申请红冲发票
public function batchApplyRed(){
$invArr = isset($this->post['invArr'])&&!empty($this->post['invArr'])?$this->post['invArr']:[];
if(empty($invArr))return error_show(1004,"参数 invArr 不能为空");
$invfo =Db::name("invoice_pool")->where(["invNo"=>$invArr,"is_del"=>0])->select()->toArray();
if(empty($invfo)) return error_show(1004,"发票数据未找到");
$insertAll=[];
$companyCode = array_unique(array_column($invfo,"inv_out"));
$inv_type = array_unique(array_column($invfo,"inv_type"));
if(count($companyCode)>1){
return error_show(1004,"业务企业公司不统一");
}
if(count($inv_type)>1){
return error_show(1004,"发票类型不统一");
}
$company =Db::name("company_info")->where(["companyNo"=>$companyCode])->findOrEmpty();
if(empty($company)) {
return error_show(1004,"业务企业信息未找到");
}
$ticketArr=Db::name("invoice_ticket")->where(["invNo"=>$invArr,"is_del"=>0])->column("*","invNo");
if(empty($ticketArr)){
return error_show(1004,"未找到开票信息");
}
$invoice=Config::get("invoice");
$Tax =new \TaxInvoice($invoice['appKey'],$invoice['appSecret'],$invoice['entCode']);
Db::startTrans();
try{
$redticketArry=[
"SQBSCQQPCH"=>randomkeys(26).date("YmdHis"),
"NSRSBH"=>$company['company_license'],
"FPLXDM"=>invoiceType($inv_type[0]),
];
$redticketList=[];
foreach ($invfo as $value){
if(!in_array($value['status'],[1,2,3,4,5])){
Db::rollback();
return error_show(1004,"发票数据状态无法申请");
}
$ticket =$ticketArr[$value['invNo']] ??[];
if(empty($ticket)){
Db::rollback();
return error_show(1004,"未找到开票信息");
}
$goodinfo =Db::name("invoice_good")
->where(["invNo"=>$value['invNo'],"is_del"=>0])
->field(" 6 as FPHXZ,
catNo as SPBM,
id as ZXBM,
is_discount as YHZCBS,
if(inv_tag=0,'',inv_tag) as LSLBS,
addTax as ZZSTSGL,
goodName as XMMC,
'' as DW,
'' as SPSL,
'' as DJ,
(-totalPrice) as JE,
0 HSBZ,
tax as SL,
-taxPrice as SE")
->select()->toArray();
if(empty($goodinfo)){
Db::rollback();
return error_show(1004,"开票商品信息未找到");
}
$len =array_unique(array_column($goodinfo,'SL'));
$qdmx=["FPHXZ"=>6,
"SPBM"=>'',
"XMMC"=>"详见对应正数发票及清单",
"YHZCBS"=>0,
"LSLBS"=>'',
"ZZSTSGL"=>'',
"DW"=>'',
"SPSL"=>'',
"DJ"=>'',
"JE"=>sprintf("%01.2f", (array_sum(array_column($goodinfo,'JE')))),
"HSBZ"=>'0',
"SL"=>count($len)>1?'':$len[0],
"SE"=>sprintf("%01.2f",array_sum(array_column($goodinfo,'SE'))),
];
$info=[
"SQBSCQQLSH"=>randomkeys(26).date("YmdHis"),
"YYSBZ"=> "0000000000", //营业税标志
"XXBLX"=> "0",//信息表类型 0 正常；1 逾期(仅销方开具)
"YFPDM"=>$ticket['inv_code'], //红字专票购方已抵扣可不填
"YFPHM"=> $ticket['inv_number'],//红字专票购方已抵扣可不填
"YFPKPRQ"=>$ticket['open_date'], //红字专票购方已抵扣可不填
"TKSJ"=>date("YmdHis"), //填开时间
"XHFSBH"=>$ticket['seller_id'],
"XHFMC"=>$ticket['seller_title'],
"GMFSBH"=>$ticket['buyer_id'],
"GMFMC"=> $ticket['buyer_title'],
"HJJE"=> "-".$ticket['inv_subtotal'],//合计金额(不含 税)
"HJSE"=>"-".$ticket['tax_fee'],//合计税额
"SQSM"=>"1100000000", //申请说明
"XXBTSBS"=>"0",//0: 正常;1:成品油发票，涉及销售数量 变更（销货退回、开票有误等原因）;2: 成品油发票，仅涉及销售金额变更（销 售折让）;3:机动车发票，仅涉及销售数
//量变更（销货退回、开票有误等原因）;4: 机动车发票，仅涉及销售金额变更（销 售折让）
];
$redticketList[]=["HZSQDTXX"=>$info,"DDMXXX"=>$qdmx];
$data=[
'invNo'=>$value['invNo'],
"invRed"=>makeNo("IRE"),
"inv_out"=>$value['inv_out']??"",
"apply_id"=>$this->uid,
"apply_name"=>$this->uname,
"status"=>5,
"remark"=>'红冲申请提交失败',
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s"),
"SQBSCQQLSH"=>$info['SQBSCQQLSH'],
"YYSBZ"=> "0000000000", //营业税标志
"XXBLX"=> "0",//信息表类型 0 正常；1 逾期(仅销方开具)
"YFPDM"=>$ticket['inv_code'], //红字专票购方已抵扣可不填
"YFPHM"=> $ticket['inv_number'],//红字专票购方已抵扣可不填
"YFPKPRQ"=>$ticket['open_date'], //红字专票购方已抵扣可不填
"TKSJ"=>date("YmdHis"), //填开时间
"XHFSBH"=>$ticket['seller_id'],
"XHFMC"=>$ticket['seller_title'],
"GMFSBH"=>$ticket['buyer_id'],
"GMFMC"=> $ticket['buyer_title'],
"HJJE"=> "-".$ticket['inv_subtotal'],//合计金额(不含 税)
"HJSE"=>"-".$ticket['tax_fee'],//合计税额
"SQSM"=>"1100000000", //申请说明
"XXBTSBS"=>"0",
"DDMXXX"=>json_encode($qdmx,JSON_UNESCAPED_UNICODE),
"SQBSCQQPCH"=>$redticketArry['SQBSCQQPCH'],
"FPLXDM"=>invoiceType($value['inv_type']),
];
$insertAll[$info['SQBSCQQLSH']]=$data;
}
$result=$Tax->AllocateRedInvoiceApplication($redticketArry,$redticketList);
if(isset($result['ZTDM']) && $result['ZTDM']=='060000'){
if(isset($result['HZSQDSCJG']) && count($result['HZSQDSCJG'])>0){
foreach ($result['HZSQDSCJG'] as $value){
if($value['ZTDM']=='060000'){
$insertAll[$value['SQBSCQQLSH']]['status']=2;
$insertAll[$value['SQBSCQQLSH']]['remark']="红冲申请审核通过";
$insertAll[$value['SQBSCQQLSH']]['XXBBH']=$value['XXBBH'];
continue;
// $data['status']=2;
// $data['remark']='红冲申请审核通过';
}
if($value['ZTDM']=='060001'){
$insertAll[$value['SQBSCQQLSH']]['status']=1;
$insertAll[$value['SQBSCQQLSH']]['remark']="红冲申请审核中";
$insertAll[$value['SQBSCQQLSH']]['XXBBH']=$value['XXBBH'];
continue;
}
unset($insertAll[$value['SQBSCQQLSH']]);
}
}
}else{
Db::rollback();
return error_show(1004,"红冲发票申请失败");
}
$uns= Db::name("invoice_red")->insertAll($insertAll);
if($uns){
Db::commit();
return app_show(0,"红冲发票申请新建成功,成功数量{$uns}个");
}
Db::rollback();
return error_show(1004,"红冲发票申请新建失败");
}catch (\Exception $e){
Db::rollback();
return error_show(1004,$e->getMessage());
}
}
//红票申请开票
public function redOpen(){
$invRed= isset($this->post['invRed'])&&$this->post['invRed']!=''? $this->post['invRed']:"";
if($invRed==''){
return error_show(1004,"参数 invRed 不能为空");
}
$redinfo =Db::name("invoice_red")->where(["invRed"=>$invRed,"is_del"=>0])->findOrEmpty();
if(empty($redinfo)){
return error_show(1004,"红冲发票申请不存在");
}
$redreason = isset($this->post['redreason'])&&$this->post['redreason']!=''? $this->post['redreason']:"";
if($redreason==''){
return error_show(1004,"参数 redreason 不能为空");
}
if($redinfo['status']!=2){
return error_show(1004,"数据状态不可提交申请");
}
$invinfo = Db::name("invoice_pool")->where(["invNo"=>$redinfo['invNo'],"is_del"=>0])->findOrEmpty();
if(empty($invinfo)) return error_show(1004,"红冲发票原票信息未找到");
$invpoolinfo = Db::name("invoice_ticket")->where(["invNo"=>$redinfo['invNo'],"status"=>1,"is_del"=>0])->findOrEmpty();
if(empty($invpoolinfo)) return error_show(1004,"红冲发票开票信息未找到");
Db::startTrans();
try{
$data=[
"invNo"=>$invRed,
"KPLX"=>"1",
"XHFSBH"=>$invpoolinfo['seller_id'],
"XHFMC"=>$invpoolinfo['seller_title'],
"XHFDZ"=>$invpoolinfo['seller_addr'],
"XHFDH"=>$invpoolinfo['seller_mobile'],
"XHFYH"=>$invpoolinfo['seller_bank'],
"XHFZH"=>$invpoolinfo['seller_bankNo'],
"GMFBM"=>"",
"GMFSBH"=>$invpoolinfo['buyer_id'],
"GMFMC"=>$invpoolinfo['buyer_title'],
"GMFDZ"=>$invpoolinfo['buyer_addr'],
"GMFDH"=>$invpoolinfo['buyer_mobile'],
"GMFYH"=>$invpoolinfo['buyer_bank'],
"GMFZH"=>$invpoolinfo['buyer_bankNo'],
"GMFLX"=>$invinfo['company_type'],
"GMFSJH"=>"",
"GMFDZYX"=>$invinfo['email'],
"KPR"=>$invpoolinfo['issuer'],
"SKR"=>$invpoolinfo['reciver'],
"FHR"=>$invpoolinfo['reviewer'],
"QDBZ"=>"0",
"YFPDM"=>$redinfo['YFPDM'],
"YFPHM"=>$redinfo['YFPHM'],
"YFPLX"=>$invpoolinfo['inv_type'] == '004' || $invpoolinfo['inv_type'] =='028'||$redreason=='' ?'':$invpoolinfo['inv_type'],
"YFPKPRQ"=>$invpoolinfo['inv_type'] == '004' || $invpoolinfo['inv_type'] == '028'||$redreason=='' ? '':date("Y-m-d",strtotime($redinfo['YFPKPRQ'])),
"CHYY"=>$invpoolinfo['inv_type'] == '004' || $invpoolinfo['inv_type'] == '028' ? '':$redreason,
"TSCHBZ"=>"0",
"JSHJ"=>"-".$invpoolinfo['inv_total'],
"HJJE"=>"-".$invpoolinfo['inv_subtotal'],
"HJSE"=>"-".$invpoolinfo['tax_fee'],
"BZ"=> $invpoolinfo['inv_type'] == '004' || $invpoolinfo['inv_type'] =='028'?"开具红字增值税专用发票信息表编号{$redinfo['XXBBH']}":"对应正数发票代码:{$redinfo['YFPDM']} 号码:{$redinfo['YFPHM']}",
"DDMXXX"=>$redinfo['DDMXXX'],
"FPLXDM"=>$redinfo['FPLXDM'],
"DDQQPCH"=>"",
"DDQQLSH"=>randomkeys(26).date("YmdHis"),
"status"=>"0",
"result"=>"",
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s")
];
$invoice=Db::name("invoice_interface")->insert($data);
if($invoice==false){
Db::rollback();
return error_show(1003,"红冲开票信息生成失败");
}
$upred=Db::name("invoice_red")->where(["invRed"=>$invRed])->update(["status"=>3,"red_reason"=>$redreason,"updatetime"=>date("Y-m-d H:i:s")]);
if($upred==false){
Db::rollback();
return error_show(1003,"红冲发票信息更新失败");
}
Db::commit();
return app_show(0,"红冲发票信息开票提交成功");
}catch (\Exception $e){
Db::rollback();
return error_show(1003,$e->getMessage());
}
}
//红冲票申请列表
public function redList(){
$page=isset($this->post['page'])&&$this->post['page']!="" ? intval($this->post['page']) :1;
$size=isset($this->post['size'])&&$this->post['size']!="" ? intval($this->post['size']) :15;
$condition=[["is_del","=",0]];
$invRed=isset($this->post["invRed"])&&$this->post["invRed"]!=''?trim($this->post["invRed"]):"";
if($invRed!=''){
$condition[]=["invRed","like","%$invRed%"];
}
$apply_id=isset($this->post["apply_id"])&&$this->post["apply_id"]!=''?intval($this->post["apply_id"]):"";
if($apply_id!=''){
$condition[]=["apply_id","=",$apply_id];
}
$invNo=isset($this->post["invNo"])&&$this->post["invNo"]!=''?trim($this->post["invNo"]):"";
if($invNo!=''){
$condition[]=["invNo","like","%$invNo%"];
}
$companyNo=isset($this->post["companyNo"])&&$this->post["companyNo"]!=''?trim($this->post["companyNo"]):"";
if($companyNo!=''){
$condition[]=["inv_out","=",$companyNo];
}
$relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :"";
if($relaComNo!=""){
$condition[]=["inv_out","=",$relaComNo];
}
$apply_name=isset($this->post["apply_name"])&&$this->post["apply_name"]!=''?trim($this->post["apply_name"]):"";
if($apply_name!=''){
$condition[]=["apply_name","like","%$apply_name%"];
}
$start = isset($this->post["start"])&&$this->post["start"]!=''?trim($this->post["start"]):"";
$end = isset($this->post["end"])&&$this->post["end"]!=''?trim($this->post["end"]):"";
if($start!=''){
$condition[]=["addtime",">=",$start];
}
if($end!=''){
$condition[]=["addtime","<=",$end];
}
$total_low=isset($this->post["total_low"])&&$this->post["total_low"]!=''?floatval($this->post["total_low"]):"";
$total_up=isset($this->post["total_up"])&&$this->post["total_up"]!=''?floatval($this->post["total_up"]):"";
if($total_low!=''){
$condition[]=["ABS(HJJE)",">=",$total_low];
}
if($total_up!=''){
$condition[]=["ABS(HJJE)","<=",$total_up];
}
$count= Db::name("invoice_red")->where($condition)->count();
$total =ceil($count/$size);
$page=$total>=$page?$page :intval($total);
$list =Db::name("invoice_red")->where($condition)->json(["DDMXXX"])->page($page,$size)->order("addtime desc")->select()
->toArray();
return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
}
/**
* @return \think\response\Json|void
*/
public function ticketInfo(){
$num =isset($this->post['number'])&&$this->post['number']!=''?trim($this->post['number']):"";
if($num==''){
return error_show(1004,'参数 number 不能为空');
}
$condition=[];
$condition[]=["inv_number","=",$num];
$invNo = isset($this->post['invNo'])&&$this->post['invNo']!=''?trim($this->post['invNo']):"";
if($invNo!=='')$condition[]=["invNo","=",$invNo];
$info =Db::name("invoice_ticket")->json(['item'])->withoutField("pdfstream")->where($condition)->findOrEmpty();
if(!empty($info)&& isset($info['item'])){
array_walk($info['item'],function (&$value){
$value['SL'] = ($value['SL']*100)."%";
});
}
return empty($info)?error_show(1005,"未找到数据"):app_show(0,"获取成功",$info);
}
/**
* @param array $ticket
* @return \think\response\Json|void
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\DbException
* @throws \think\db\exception\ModelNotFoundException
*/
private function addApplyRed($ticket=[],$returnCode){
$invoice=Config::get("invoice");
$Tax =new \TaxInvoice($invoice['appKey'],$invoice['appSecret'],$invoice['entCode']);
$redticketList=[];
$redticketArry=[
"SQBSCQQPCH"=>randomkeys(26).date("YmdHis"),
"NSRSBH"=>$ticket['seller_id'],
"FPLXDM"=>$ticket['inv_type'],
];
$goodinfo =Db::name("invoice_good")
->where(["invNo"=>$ticket['invNo'],"is_del"=>0])
->field("0 as FPHXZ,
catNo as SPBM,
id as ZXBM,
is_discount as YHZCBS,
if(inv_tag=0,'',inv_tag) as LSLBS,
addTax as ZZSTSGL,
goodName as XMMC,
'' as DW,
'' as SPSL,
'' as DJ,
(-totalPrice) as JE,
0 HSBZ,
tax as SL,
-taxPrice as SE")->select()->toArray();
if(empty($goodinfo)){
throw new \Exception("开票商品信息未找到", 10006);
}
if(count($goodinfo)>8){
$len =array_unique(array_column($goodinfo,'SL'));
$qdmx=["FPHXZ"=>6,
"SPBM"=>'',
"XMMC"=>"详见对应正数发票及清单",
"YHZCBS"=>0,
"LSLBS"=>'',
"ZZSTSGL"=>'',
"DW"=>'',
"SPSL"=>'',
"DJ"=>'',
"JE"=>sprintf("%01.2f", (array_sum(array_column($goodinfo,'JE')))),
"HSBZ"=>'0',
"SL"=>count($len)>1?'':$len[0],
"SE"=>sprintf("%01.2f",array_sum(array_column($goodinfo,'SE'))),
];
}else
{
$qdmx=$goodinfo;
}
$info=[
"SQBSCQQLSH"=>randomkeys(26).date("YmdHis"),
"YYSBZ"=> "0000000000", //营业税标志
"XXBLX"=> "0",//信息表类型 0 正常；1 逾期(仅销方开具)
"YFPDM"=>$ticket['inv_code'], //红字专票购方已抵扣可不填
"YFPHM"=> $ticket['inv_number'],//红字专票购方已抵扣可不填
"YFPKPRQ"=>$ticket['open_date'], //红字专票购方已抵扣可不填
"TKSJ"=>date("YmdHis"), //填开时间
"XHFSBH"=>$ticket['seller_id'],
"XHFMC"=>$ticket['seller_title'],
"GMFSBH"=>$ticket['buyer_id'],
"GMFMC"=> $ticket['buyer_title'],
"HJJE"=> "-".$ticket['inv_subtotal'],//合计金额(不含 税)
"HJSE"=>"-".$ticket['tax_fee'],//合计税额
"SQSM"=>"1100000000", //申请说明
"XXBTSBS"=>"0",//0: 正常;1:成品油发票，涉及销售数量 变更（销货退回、开票有误等原因）;2: 成品油发票，仅涉及销售金额变更（销 售折让）;3:机动车发票，仅涉及销售数
//量变更（销货退回、开票有误等原因）;4: 机动车发票，仅涉及销售金额变更（销 售折让）
];
$invRed=makeNo("IRE");
$data=[
'invNo'=>$ticket['invNo'],
"invRed"=>$invRed,
"returnCode"=>$returnCode,
"apply_id"=>$this->uid,
"apply_name"=>$this->uname,
"status"=>0,
"remark"=>'',
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s"),
"SQBSCQQLSH"=>$info['SQBSCQQLSH'],
"YYSBZ"=> "0000000000", //营业税标志
"XXBLX"=> "0",//信息表类型 0 正常；1 逾期(仅销方开具)
"YFPDM"=>$ticket['inv_code'], //红字专票购方已抵扣可不填
"YFPHM"=> $ticket['inv_number'],//红字专票购方已抵扣可不填
"YFPKPRQ"=>$ticket['open_date'], //红字专票购方已抵扣可不填
"TKSJ"=>date("YmdHis"), //填开时间
"XHFSBH"=>$ticket['seller_id'],
"XHFMC"=>$ticket['seller_title'],
"GMFSBH"=>$ticket['buyer_id'],
"GMFMC"=> $ticket['buyer_title'],
"HJJE"=> "-".$ticket['inv_subtotal'],//合计金额(不含 税)
"HJSE"=>"-".$ticket['tax_fee'],//合计税额
"SQSM"=>"1100000000", //申请说明
"XXBTSBS"=>"0",
"DDMXXX"=>json_encode($qdmx,JSON_UNESCAPED_UNICODE),
"SQBSCQQPCH"=>$redticketArry['SQBSCQQPCH'],
"FPLXDM"=>$ticket['inv_type'],
];
$redticketList[]=["HZSQDTXX"=>$info,"DDMXXX"=>$qdmx];
$result=$Tax->AllocateRedInvoiceApplication($redticketArry,$redticketList);
$data['status']=5;
$data['remark']='红冲申请提交失败';
if(isset($result['ZTDM']) && $result['ZTDM']=='060000'){
$resultChild=$result['HZSQDSCJG'][0];
if($resultChild['ZTDM']=='060000'){
$data['status']=2;
$data['XXBBH']=$resultChild['XXBBH'];
$data['remark']='红冲申请审核通过';
}
if($resultChild['ZTDM']=='060001'){
$data['status']=1;
$data['XXBBH']=$resultChild['XXBBH'];
$data['remark']='红冲申请审核中';
}
}
if($data['status']==5){
throw new \Exception($resultChild['ZTXX'], 10006);
}
$up =Db::name("invoice_red")->insert($data);
if($up) return app_show(0,"红冲发票申请新建成功",["invRed"=>$invRed]);
else throw new \Exception($resultChild['ZTXX'], 1006);
}
/**
* @param array $ticket
* @return \think\response\Json|void
* @throws \think\Exception
*/
private function addRedOpen($ticket=[],$return_reason,$company_type,$returnCode){
$goodinfo =Db::name("invoice_good")
->where(["invNo"=>$ticket['invNo'],"is_del"=>0])
->field("0 as FPHXZ,
catNo as SPBM,
id as ZXBM,
is_discount as YHZCBS,
if(inv_tag=0,'',inv_tag) as LSLBS,
addTax as ZZSTSGL,
goodName as XMMC,
'' as DW,
'' as SPSL,
'' as DJ,
(-totalPrice) as JE,
0 HSBZ,
tax as SL,
-taxPrice as SE")->select()->toArray();
if(empty($goodinfo)){
throw new \Exception("开票商品信息未找到", 10006);
}
if(count($goodinfo)>8){
$len =array_unique(array_column($goodinfo,'SL'));
$qdmx=["FPHXZ"=>6,
"SPBM"=>'',
"XMMC"=>"详见对应正数发票及清单",
"YHZCBS"=>0,
"LSLBS"=>'',
"ZZSTSGL"=>'',
"DW"=>'',
"SPSL"=>'',
"DJ"=>'',
"JE"=>sprintf("%01.2f", (array_sum(array_column($goodinfo,'JE')))),
"HSBZ"=>'0',
"SL"=>count($len)>1?'':$len[0],
"SE"=>sprintf("%01.2f",array_sum(array_column($goodinfo,'SE'))),
];
}else
{
$qdmx=$goodinfo;
}
$invRed=makeNo("IRE");
$reddata=[
'invNo'=>$ticket['invNo'],
"invRed"=>$invRed,
"returnCode"=>$returnCode,
"apply_id"=>$this->uid,
"apply_name"=>$this->uname,
"status"=>3,
"remark"=>'',
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s"),
"SQBSCQQLSH"=>'',
"YYSBZ"=> "0000000000", //营业税标志
"XXBLX"=> "0",//信息表类型 0 正常；1 逾期(仅销方开具)
"YFPDM"=>$ticket['inv_code'], //红字专票购方已抵扣可不填
"YFPHM"=> $ticket['inv_number'],//红字专票购方已抵扣可不填
"YFPKPRQ"=>$ticket['open_date'], //红字专票购方已抵扣可不填
"TKSJ"=>date("YmdHis"), //填开时间
"XHFSBH"=>$ticket['seller_id'],
"XHFMC"=>$ticket['seller_title'],
"GMFSBH"=>$ticket['buyer_id'],
"GMFMC"=> $ticket['buyer_title'],
"HJJE"=> "-".$ticket['inv_subtotal'],//合计金额(不含 税)
"HJSE"=>"-".$ticket['tax_fee'],//合计税额
"SQSM"=>"1100000000", //申请说明
"XXBTSBS"=>"0",
"DDMXXX"=>json_encode($goodinfo,JSON_UNESCAPED_UNICODE),
"SQBSCQQPCH"=>'',
"FPLXDM"=>$ticket['inv_type'],
];
$data=[ "invNo"=>$invRed,
"KPLX"=>"1",
"XHFSBH"=>$ticket['seller_id'],
"XHFMC"=>$ticket['seller_title'],
"XHFDZ"=>$ticket['seller_addr'],
"XHFDH"=>$ticket['seller_mobile'],
"XHFYH"=>$ticket['seller_bank'],
"XHFZH"=>$ticket['seller_bankNo'],
"GMFBM"=>"",
"GMFSBH"=>$ticket['buyer_id'],
"GMFMC"=>$ticket['buyer_title'],
"GMFDZ"=>$ticket['buyer_addr'],
"GMFDH"=>$ticket['buyer_mobile'],
"GMFYH"=>$ticket['buyer_bank'],
"GMFZH"=>$ticket['buyer_bankNo'],
"GMFLX"=>$company_type,
"GMFSJH"=>"",
"GMFDZYX"=>'',
"KPR"=>$ticket['issuer'],
"SKR"=>$ticket['reciver'],
"FHR"=>$ticket['reviewer'],
"QDBZ"=>"0",
"YFPDM"=>$ticket['inv_code'],
"YFPHM"=>$ticket['inv_number'],
"YFPLX"=>$ticket['inv_type'],
"YFPKPRQ"=>date("Y-m-d",strtotime($ticket['open_date'])),
"CHYY"=>$return_reason,
"TSCHBZ"=>"0",
"JSHJ"=>"-".$ticket['inv_total'],
"HJJE"=>"-".$ticket['inv_subtotal'],
"HJSE"=>"-".$ticket['tax_fee'],
"BZ"=> "对应正数发票代码:{$ticket['inv_code']} 号码:{$ticket['inv_number']}",
"DDMXXX"=>json_encode($qdmx,JSON_UNESCAPED_UNICODE),
"FPLXDM"=>$ticket['inv_type'],
"DDQQPCH"=>"",
"DDQQLSH"=>randomkeys(26).date("YmdHis"),
"status"=>"0",
"result"=>"",
"addtime"=>date("Y-m-d H:i:s"),
"updatetime"=>date("Y-m-d H:i:s")
];
$invoice=Db::name("invoice_interface")->insert($data);
if($invoice==false){
throw new Exception("红冲提交失败",1006);
}
$upred=Db::name("invoice_red")->save($reddata);
if($upred==false){
throw new Exception("红冲提交失败",1006);
}
return app_show(0,"红冲已提交");
}
private function addDiscard($ticket=[],$returnCode){
$invoice=Config::get("invoice");
$tax =new \TaxInvoice($invoice['appKey'],$invoice['appSecret'],$invoice['entCode']);
$result=$tax->DeprecateInvoices($ticket['seller_id'],$ticket['inv_type'],$ticket['inv_code'],$ticket['inv_number'],1);
if(isset($result['ZTDM']) && $result['ZTDM']=='050000'){
Db::name("invoice_return")->where(['returnCode'=>$returnCode])->update(["status"=>2,"updatetime"=>date("Y-m-d H:i:s")]);
$up =Db::name("invoice_pool")->where(['invNo'=>$ticket['invNo']])->update(["status"=>6,"updatetime"=>date("Y-m-d H:i:s")]);
if($up){
return app_show(0,"发票废弃成功");
}
}else{
throw new \Exception($result['ZTXX'], 1006);
}
}
//退票列表
public function returnRedList(){
$page=isset($this->post['page'])&&$this->post['page']!="" ? intval($this->post['page']) :1;
$size=isset($this->post['size'])&&$this->post['size']!="" ? intval($this->post['size']) :15;
$condition=[];
$start = isset($this->post['start'])&&$this->post['start']!="" ? trim($this->post['start']) :"";
$end = isset($this->post['end'])&&$this->post['end']!="" ? trim($this->post['end']) :"";
if($start!=""){
$condition[]=["a.addtime",">=",$start." 00:00:00"];
}
if($end!=""){
$condition[]=["a.addtime","<=",$end." 23:59:59"];
}
$inv_type = isset($this->post['inv_type'])&&$this->post['inv_type']!=="" ? intval($this->post['inv_type']):"";
if($inv_type!==""){
$condition[]=["b.inv_type","=",$inv_type];
}
$companyNo = isset($this->post['companyNo'])&&$this->post['companyNo']!=="" ? trim($this->post['companyNo']):"";
if($companyNo!==""){
$condition[]=["c.inv_out","=",$companyNo];
}
$relaComNo= isset($post['relaComNo'])&&$post['relaComNo']!="" ? trim($post['relaComNo']) :"";
if($relaComNo!=""){
$condition[]=["c.inv_out","=",$relaComNo];
}
$apply_id = isset($this->post['apply_id'])&&$this->post['apply_id']!=="" ? intval($this->post['apply_id']):"";
if($apply_id!==""){
$condition[]=["a.apply_id","=",$apply_id];
}
$apply_name = isset($this->post['apply_name'])&&$this->post['apply_name']!==""?trim($this->post['apply_name']) :"";
if($apply_name!==""){
$condition[]=["a.apply_name","like","%$apply_name%"];
}
$status= isset($this->post['status'])&&$this->post['status']!=="" ? intval($this->post['status']):"";
if($status!==""){
$condition[]=["a.status","=",$status];
}
$invNo = isset($this->post['invNo'])&&$this->post['invNo']!=="" ? trim($this->post['invNo']):"";
if($invNo!==""){
$condition[]=["a.invNo","like","%$invNo%"];
}
$returnCode = isset($this->post['returnCode'])&&$this->post['returnCode']!=="" ? trim($this->post['returnCode']):"";
if($returnCode!==""){
$condition[]=["a.returnCode","like","%$returnCode%"];
}
$count=Db::name("invoice_return")->alias("a")
->leftJoin("invoice_ticket b","a.invNo=b.invNo and b.type=1")
->leftJoin("invoice_pool c","a.invNo=c.invNo")
->where($condition)->count();
$total =ceil($count/$size);
$page= $page>$total ? intval($total):$page;
$list=Db::name("invoice_return")->alias("a")
->leftJoin("invoice_ticket b","a.invNo=b.invNo and b.type=1")
->leftJoin("invoice_pool c","a.invNo=c.invNo")
->field("b.*,a.*")->withoutField("pdfstream")->json(["item"])->page($page,$size)->where($condition)->select()
->toArray();
return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
}
/**
* @return \think\response\Json|void
* @throws \think\db\exception\DataNotFoundException
* @throws \think\db\exception\DbException
* @throws \think\db\exception\ModelNotFoundException
*/
public function tikcetList(){
$post=$this->request->only(["invNo"=>"","companyNo"=>"","relaComNo"=>"","page"=>1,"size"=>15],"post","trim");
$where=[];
if($post["invNo"]!="") $where[]=["a.invNo","=",$post['invNo']];
if($post["companyNo"]!="") $where[]=["b.inv_out","=",$post['companyNo']];
if($post["relaComNo"]!="") $where[]=["b.inv_out","=",$post['relaComNo']];
$count=Db::name("invoice_ticket")->where($where)->count();
$total =ceil($count/$post['size']);
$page= $post['page']>$total ? intval($total):intval($post['page']);
$list = Db::name("invoice_ticket")
->alias("a")
->leftJoin("invoice_pool b","a.invNo=b.invNo")
->where($where)
->field("a.*")
->json(["a.item"])
->page($page,intval($post['size']))
->order("a.id desc")
->select()->toArray();
$typename=["004"=>"增值税专用发票",'007'=>"增值税普通发票",'026'=>'增值税电子普通发票','028'=>'增值税电子专用发票'];
foreach ($list as &$value){
$value['invtype_name'] = $typename[$value['inv_type']]??"";
}
return app_show(0,"获取成功",["list"=>$list,"count"=>$count]);
}
public function downorder(){
$post=$this->request->only(["invNo"=>[]],"post","trim");
$condition=[["open_type","in",[2,3]],["is_del","=",0],["status","=",0]];
if(!empty($post['invNo'])){
$condition[]=['invNo',"in",$post['invNo']];
}
$invice = Db::name("invoice_pool")->where($condition)->select()->toArray();
if (empty($invice)){
return error_show(1003,"未找到数据");
}
$data=[];
foreach ($invice as $value){
$temp=[];
$orderNo = Db::name("assoc")->where([["status","=",1],["is_del","=",0],['viceNo',"=",$value['invNo']]])
->find();
if(!$orderNo){
continue;
}
$good = Db::name("qrd_info")->where([['sequenceNo',"=",$orderNo['orderCode']],["status","=",1]])
->findOrEmpty();
if(empty($good)){
continue;
}
if(isset($value['inv_out'])&& $value['inv_out']!=''){
$invout = Db::name("company_info")->where([['companyNo',"=",$value['inv_out']]])->find();
}
$invinfo = Db::name("invoice_pool_info")->where("invNo","=",$value['invNo'])->findOrEmpty();
// foreach ($good as $val){
// $qrd = Db::name("qrd_list")->where("sequenceNo","=",$val['goodNo'])->find();
$temp['invNo'] = $value['invNo'];
$temp['qrdNo'] = $orderNo['orderCode'];
$temp['depart'] = $good['department'];
$temp['apply_name'] =$value['apply_name'];
$temp['code'] ="";
$temp['invoice_title'] =$invinfo['buyer_title']??"";
$temp['invoice_code'] =$invinfo['buyer_code']." ";
$temp['invoice_addr'] =$invinfo['buyer_addr']??"";
$temp['invoice_mobile'] =$invinfo['buyer_mobile']??"";
$temp['invoice_bank'] =$invinfo['buyer_bank']??"";
$temp['invoice_bankNo'] =$invinfo['buyer_bankNo']." ";
$temp['company'] =$good['customerName'];
$temp['goodname'] =$good['goodName'];
$temp['tax'] =$good['tax'];
$temp['inv_name'] =$good['goodName'];
$temp['diff_weight'] =$good['diff_weight'];
$temp['diff_price'] =$good['diff_fee'];
$temp['unit'] =$good['goodUnit'];
$temp['num'] =$good['goodNum'];
$temp['price'] =$good['goodPrice'];
$temp['total_fee'] =$good['totalPrice'];
switch ($value['inv_type']){
case 1:
$temp['inv_type'] = "增值税专用发票";
break;
case 2:
$temp['inv_type'] = "增值税普通发票";
break;
case 3:
$temp['inv_type'] = "增值税电子专用发票";
break;
case 4:
$temp['inv_type'] = "增值税电子普通发票";
break;
default:
$temp['inv_type'] = "-";
break;
}
// $temp['inv_type'] = $value['inv_type']==1?"增值税专用发票": "增值税普通发票";
// $temp['inv_value'] =$value['inv_value'];
$temp['remark'] =$value['remark'];
$temp['kp_companyName'] = $invinfo['seller_title']??"";
$temp['kp_company_address'] = $invinfo['seller_addr']??"";
$temp['kp_company_license'] = $invinfo['seller_code']." ";
$temp['kp_bank_name'] = $invinfo['seller_bank']??"";
$temp['kp_bankNo'] = $invinfo['seller_bankNo']."";
$temp['kp_contector'] = $invout['contector']??"";
$temp['kp_mobile'] = $invinfo['seller_mobile']??"";
$data[]=$temp;
}
// }
if (empty($data)){
return error_show(1003,"未找到数据");
}
$header=[
"申请编号",
"公司订单号",
"申请部门(所属平台)",
"申请人",
"代码",
"发票开具全称",
"发票开具企业纳税识别号",
"发票开具企业地址",
"发票开具企业地址联系方式",
"发票开具企业收款银行",
"发票开具企业收款账户",
"分公司",
"采购商品名",
"税率",
"发票商品名",
"工差重量",
"工差金额",
"单位",
"数量",
"单价",
"总价",
"开票种类",
"备注说明",
'开票企业名称',
'开票企业地址',
'开票企业纳税号',
'开票企业银行名称',
'开票企业银行账户',
'开票企业法人',
'开票企业联系方式'
];
$li = excelExport("待开票",$header,$data);
}
}