cxinv/app/admin/controller/Company.php

<?php
declare (strict_types = 1);

namespace app\admin\controller;
use app\admin\BaseController;
use think\App;
use think\facade\Db;


class Company extends BaseController
{
    public function __construct(App $app) {parent::__construct($app);}
    /**
     * 显示资源列表
     *
     * @return \think\Response
     */
    public function Info()
    {
        $post  =$this->post;
         if($this->level==1){
        	$companyNo = isset($post['companyNo'])&& $post['companyNo']!="" ? trim($post['companyNo']) :"";
        }else{
            $companyNo = isset($post['relaComNo'])&& $post['relaComNo']!="" ? trim($post['relaComNo']) :"";
        }
        if($companyNo==""){
            return error_show(1004,"参数companyNo 不能为空");
        }
        $company = Db::name("company_info")->where("companyNo","=",$companyNo)->find();
        if(empty($company)){
            return error_show(1004,"未找到对应的数据");
        }
        return app_show(0,"获取成功",$company);
    }

    /**
     * 显示创建资源表单页.
     *
     * @return \think\Response
     */
    public function create()
    {
        $post  =$this->post;
       if($this->level==1){
        	$companyNo = isset($post['companyNo'])&& $post['companyNo']!="" ? trim($post['companyNo']) :"";
        }else{
            $companyNo = isset($post['relaComNo'])&& $post['relaComNo']!="" ? trim($post['relaComNo']) :"";
        }
        if($companyNo==""){
            return error_show(1004,"参数companyNo 不能为空");
        }
        $supplierinfo =Db::name("supplier_info")->where(["code"=>$companyNo])->findOrEmpty();
        if(empty($supplierinfo)){
        	return error_show(1004,"未找到企业信息");
        }
        $isIn =Db::name("company_info")->where(["companyNo"=>$companyNo,"is_del"=>0])->findOrEmpty();
        if(!empty($isIn))return error_show(1004,"财务信息已存在！");
        $name = isset($post['company_name'])&&$post['company_name']!="" ? trim($post['company_name']) :"";
        if($name==""){
            return error_show(1004,"参数company_name 不能为空");
        }
        $title = isset($post['company_license'])&&$post['company_license']!="" ? trim($post['company_license']) :"";
        if($title==""){
            return error_show(1004,"参数company_license 不能为空");
        }
        $bank = isset($post['bank_name'])&&$post['bank_name']!="" ? trim($post['bank_name']) :"";
        if($bank==""){
            return error_show(1004,"参数bank_name 不能为空");
        }
        $bankNo = isset($post['bankNo'])&&$post['bankNo']!="" ? trim($post['bankNo']) :"";
        if($bankNo==""){
            return error_show(1004,"参数bankNo 不能为空");
        }
        $is_bank = Db::name("company_info")->where([["bankNo","=",$bankNo],["status","=",1]])->find();
        if(!empty($is_bank)){
            return error_show(1004,"银行卡号已存在!");
        }
        $address = isset($post['company_address'])&&$post['company_address']!="" ? trim($post['company_address']) :"";
        if($address==""){
            return error_show(1004,"参数company_address 不能为空");
        }
        $contector = isset($post['contector'])&&$post['contector']!="" ? trim($post['contector']) :"";
        $mobile = isset($post['mobile'])&&$post['mobile']!="" ? trim($post['mobile']) :"";
        $img = isset($post['company_img'])&&$post['company_img']!="" ? trim($post['company_img']) :"";
        if($mobile!=""){
            if(!checkTel($mobile)&&!checkMobile($mobile)){
                return error_show(1004,"手机号/电话格式不正确");
            }
        }

        $inputTicket = isset($post['input_ticket'])&&$post['input_ticket']!="" ? intval($post['input_ticket']) :"0";
        if($inputTicket==""){
             return error_show(1004,"进项票未设置验票方式");
        }
        $outTicket = isset($post['out_ticket'])&&$post['out_ticket']!="" ? intval($post['out_ticket']) :"0";
        if($outTicket==""){
             return error_show(1004,"销项票未设置验票方式");
        }
            $voider = isset($post['voider'])&&$post['voider']!="" ? trim($post['voider']) :"";
            $payee = isset($post['payee'])&&$post['payee']!="" ? trim($post['payee']) :"";
            $drawer = isset($post['drawer'])&&$post['drawer']!="" ? trim($post['drawer']) :"";
            $reviewer = isset($post['reviewer'])&&$post['reviewer']!="" ? trim($post['reviewer']) :"";
            $ownerPlace = isset($post['ownerPlace'])&&$post['ownerPlace']!="" ? trim($post['ownerPlace']) :"";
            $denomination = isset($post['denomination'])&&$post['denomination']!="" ? trim($post['denomination']) :"";
            $invoiceType = isset($post['invoiceType'])&&!empty($post['invoiceType']) ? implode(",", $post['invoiceType']):"";
       $data = [
           "companyNo"=>$companyNo,
           "company_name"=>$name,
           "company_address"=>$address,
           "company_license"=>$title,
           "bank_name"=>$bank,
           "bankNo"=>$bankNo,
           "contector"=>$contector,
           "mobile"=>$mobile,
           "company_img"=>$img,
           "input_ticket"=>$inputTicket,
           "out_ticket"=>$outTicket,
           "voider"=>$voider,
           "payee"=>$payee,
           "drawer"=>$drawer,
           "reviewer"=>$reviewer,
           "ownerPlace"=>$ownerPlace,
           "denomination"=>$denomination,
           "invoiceType"=>$invoiceType,
           "status"=>1,
           "addtime"=>date("Y-m-d H:i:s"),
           "updatetime"=>date("Y-m-d H:i:s")
       ];
       $result = Db::name("company_info")->insert($data);
       return $result? app_show(0,"新建成功",["companyNo"=>$companyNo]):error_show(1005,"新建失败");
    }

    /**
     * 保存新建的资源
     *
     * @param  \think\Request  $request
     * @return \think\Response
     */
    public function save()
    {
          $post  =$this->post;
        if($this->level==1){
        	$companyNo = isset($post['companyNo'])&& $post['companyNo']!="" ? trim($post['companyNo']) :"";
        }else{
            $companyNo = isset($post['relaComNo'])&& $post['relaComNo']!="" ? trim($post['relaComNo']) :"";
        }
        if($companyNo==""){
            return error_show(1004,"参数companyNo 不能为空");
        }
        $name = isset($post['company_name'])&&$post['company_name']!="" ? trim($post['company_name']) :"";
        if($name==""){
            return error_show(1004,"参数company_name 不能为空");
        }
        $title = isset($post['company_license'])&&$post['company_license']!="" ? trim($post['company_license']) :"";
        if($title==""){
            return error_show(1004,"参数company_license 不能为空");
        }
        $bank = isset($post['bank_name'])&&$post['bank_name']!="" ? trim($post['bank_name']) :"";
        if($bank==""){
            return error_show(1004,"参数bank_name 不能为空");
        }
        $bankNo = isset($post['bankNo'])&&$post['bankNo']!="" ? trim($post['bankNo']) :"";
        if($bankNo==""){
            return error_show(1004,"参数bankNo 不能为空");
        }
        $address = isset($post['company_address'])&&$post['company_address']!="" ? trim($post['company_address']) :"";
        $contector = isset($post['contector'])&&$post['contector']!="" ? trim($post['contector']) :"";
        $mobile = isset($post['mobile'])&&$post['mobile']!="" ? trim($post['mobile']) :"";
        $img = isset($post['company_img'])&&$post['company_img']!="" ? trim($post['company_img']) :"";
        if($mobile!=""){
            if(!checkTel($mobile)&&!checkMobile($mobile)){
                return error_show(1004,"手机号/电话格式不正确");
            }
        }
           $inputTicket = isset($post['input_ticket'])&&$post['input_ticket']!="" ? intval($post['input_ticket']) :"0";
        if($inputTicket==""){
             return error_show(1004,"进项票未设置验票方式");
        }
        $outTicket = isset($post['out_ticket'])&&$post['out_ticket']!="" ? intval($post['out_ticket']) :"0";
        if($outTicket==""){
             return error_show(1004,"销项票未设置验票方式");
        }
            $voider = isset($post['voider'])&&$post['voider']!="" ? trim($post['voider']) :"";
            $payee = isset($post['payee'])&&$post['payee']!="" ? trim($post['payee']) :"";
            $drawer = isset($post['drawer'])&&$post['drawer']!="" ? trim($post['drawer']) :"";
            $reviewer = isset($post['reviewer'])&&$post['reviewer']!="" ? trim($post['reviewer']) :"";
            $ownerPlace = isset($post['ownerPlace'])&&$post['ownerPlace']!="" ? trim($post['ownerPlace']) :"";
            $denomination = isset($post['denomination'])&&$post['denomination']!="" ? trim($post['denomination']) :"";
            $invoiceType = isset($post['invoiceType'])&&!empty($post['invoiceType']) ? implode(",", $post['invoiceType']):"";
        $data = [
            "company_name"=>$name,
            "company_address"=>$address,
            "company_license"=>$title,
            "bank_name"=>$bank,
            "bankNo"=>$bankNo,
            "contector"=>$contector,
            "mobile"=>$mobile,
            "company_img"=>$img,
           "input_ticket"=>$inputTicket,
           "out_ticket"=>$outTicket,
           "voider"=>$voider,
           "payee"=>$payee,
           "drawer"=>$drawer,
           "reviewer"=>$reviewer,
           "ownerPlace"=>$ownerPlace,
           "denomination"=>$denomination,
           "invoiceType"=>$invoiceType,
            "updatetime"=>date("Y-m-d H:i:s")
        ];
        $result = Db::name("company_info")->where("companyNo","=",$companyNo)->update($data);
        return $result? app_show(0,"更新成功"):error_show(1005,"更新失败");
    }

    /**
     * 显示指定的资源
     *
     * @param  int  $id
     * @return \think\Response
     */
    public function status()
    {
        $post  =$this->post;

        $companyNo = isset($post['companyNo'])&& $post['companyNo']!="" ? trim($post['companyNo']) :"";

        if($companyNo==""){
            return error_show(1004,"参数companyNo 不能为空");
        }
        $status = isset($post['status'])&&$post['status']!="" ? trim($post['status']) :"";
        if($status==""){
            return error_show(1004,"参数status 不能为空");
        }
        if(!in_array($status,[0,1])){
            return error_show(1004,"参数status 无效");
        }
        $message = $status==1 ?"启用" :"禁用";
        $data = [
            "status"=>$status,
            "updatetime"=>date("Y-m-d H:i:s")
        ];
        $result = Db::name("company_info")->where("companyNo","=",$companyNo)->update($data);
        return $result? app_show(0,"{$message}成功"):error_show(1005,"{$message}失败");
    }

    /**
     * 显示编辑资源表单页.
     *
     * @param  int  $id
     * @return \think\Response
     */
    public function list()
    {
        $post  =$this->post;
        $condition = [["is_del","=",0]];
        $companyNo = isset($post['companyNo'])&& $post['companyNo']!="" ? trim($post['companyNo']) :"";
        if($companyNo!=""){
            $condition[]=['companyNo',"=",$companyNo];
        }
        $companyName = isset($post['companyName'])&&$post['companyName']!="" ? trim($post['companyName']) :"";
        if($companyName!=""){
            $condition[]=['b.name',"like","%$companyName%"];
        }
        $status = isset($post['status'])&&$post['status']!=="" ? intval($post['status']) :"";
        if($status!==""){
             $condition[]=['a.status',"=",$status];
        }
        $page = isset($post['page'])&& $post['page']!="" ? intval($post['page']) :1;
        $size = isset($post['size'])&& $post['size']!="" ? intval($post['size']) :10;
        $count = Db::name("company_info")->alias("a")
        ->leftJoin("supplier_info b","a.companyNo=b.code")
        ->where($condition)->count();
        $total = ceil($count/$size)>1 ? ceil($count/$size) : 1;
        $page = $page>=$total?intval($total):$page;
        $list = Db::name("company_info")->alias("a")
        ->leftJoin("supplier_info b","a.companyNo=b.code")
        ->where($condition)
        ->field("a.*,b.name")
        ->page($page,$size)
        ->order("id desc")
        ->select();
        return app_show(0,"获取成功",['list'=>$list,"count"=>$count]);
    }

    /**
     * 保存更新的资源
     *
     * @param  \think\Request  $request
     * @param  int  $id
     * @return \think\Response
     */
    public function all()
    {


        $condition = [["is_del","=",0]];

        $companyNo = isset($post['companyNo'])&& $post['companyNo']!="" ? trim($post['companyNo']) :"";
        if($companyNo!=""){
            $condition[]=['companyNo',"=",$companyNo];
        }
         $companyName = isset($post['companyName'])&&$post['companyName']!="" ? trim($post['companyName']) :"";
        if($companyName!=""){
            $condition[]=['company_name',"like","%$companyName%"];
        }
        $list = Db::name("company_info")->where($condition)->field("companyNo,company_name,status,bank_name,bankNo,company_license,LENGTH('company_name') as weight")->order("weight asc")->select();
        return app_show(0,"获取成功",$list);
    }

    /** 获取利率设置
    * @return \think\response\Json|void
    * @throws \think\db\exception\DataNotFoundException
    * @throws \think\db\exception\DbException
    * @throws \think\db\exception\ModelNotFoundException
     */
    public function RateList(){
        $list=Db::name("order_rate")->where("status","=",1)->select();
        return app_show(0,"获取成功",$list);
    }
}