<?php
/**
 * Copyright 2012-2026 ShopeX (https://www.shopex.cn)
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */


class invoice_mdl_order extends dbeav_model
{

    //发票类型
    const MODE = [
        0 => '纸质发票',
        1 => '电子发票',
    ];

    //是否有导出配置
     var $has_export_cnf = true;
	 public $defaultOrder = array('id', 'DESC');
    
    /**
     * 须加密字段
     *
     * @var string
     **/
    private $__encrypt_cols = array(
        'ship_tax'     => 'simple',
        'ship_bank'    => 'simple',
        'ship_bank_no' => 'simple',
        'ship_tel'     => 'phone',
        'ship_addr'    => 'simple',
    );

    private $invoiceTemplateColumn = array(
        '订单号'   => 'order_bn',
        '客户名称' => 'tax_company',
        '客户电话' => 'ship_tel',
        '客户税号' => 'ship_tax',
        '收票地区' => 'ship_area',
        '收票地址' => 'ship_addr',
        '注册电话' => 'ship_company_tel',
        '注册地址' => 'ship_company_addr',
        '开户银行' => 'ship_bank',
        '银行账号' => 'ship_bank_no',
    );

    private $waybillTemplateColumn = array(
        '发票代码'     => 'invoice_code',
        '发票号码'       => 'invoice_no',
        '物流公司'  => 'logi_name',
        '运单号'       => 'logi_no',
    );

    /*------------------------------------------------------ */
    //-- 用户信息
    /*------------------------------------------------------ */
    function getUserName($uid)
    {
    	$uid           = intval($uid);
    	$userData      = array();
    	$filter        = array('user_id'=>$uid);
    	$rows          = app::get('desktop')->model('users')->getList('user_id, name', $filter);
    	
    	return $rows[0];
    }
    
    /**
     * 导出数据格式
     * @param unknown_type $filter
     * @param unknown_type $ioType
     */
    function io_title($filter = null, $ioType = 'csv' )
    {
        switch( $ioType ) {
            case 'csv':
            default:
                $this->oSchema['csv'][$filter] = array(
                    '*:订单号' => 'order_bn',
                    '*:订单确认状态' => 'process_status',
                    '*:来源店铺' => 'shop_name',
                    '*:发票类型' => 'type_id',
                    '*:开票金额' => 'amount',
                    '*:税金' => 'cost_tax',
                    '*:税率' => 'tax_rate',
                    '*:发票抬头' => 'title',
                    '*:开票状态' => 'is_status',
                    '*:发票号' => 'invoice_no',
                    '*:发票内容' => 'content',
                    '*:批次号' => 'batch_number',
                    '*:发票备注' => 'remarks',
                    '*:打印次数' => 'print_num',
                    '*:创建日期' => 'create_time',
                    '*:开票时间' => 'dateline',
                    '*:客户名称' => 'tax_company',
                    '*:收货地区' => 'ship_area',
                    '*:客户地址' => 'ship_addr',
                    '*:客户电话' => 'ship_tel',
                    '*:客户税号' => 'ship_tax',
                    '*:客户开户银行' => 'ship_bank',
                    '*:客户银行账号' => 'ship_bank_no',
                );
        }
        $this->ioTitle[$ioType][$filter]        = array_keys( $this->oSchema[$ioType][$filter] );
        return $this->ioTitle[$ioType][$filter];
    }
    /**
     * 导出数据(方法名固定，由系统调用)
     * @param Array $data 导出的数据
     * @param Array $filter 过滤器
     * @param Int $offset 当前记录位置
     * @param Int $exportType 导出类型
     */
    function fgetlist_csv( &$data,$filter,$offset,$exportType = 1 )
    {
        set_time_limit(0);
        @ini_set('memory_limit','128M');
        if ($offset > $max_offset) {
            return false;
        }
        
        if( !$data['title'] ){
            $title = array();
            foreach( $this->io_title('order') as $k => $v ){
                $title[]    = $v;
            }
            $data['title']  = '"' . implode('","', $title) . '"';
        }

        $limit     = 100;
        if( !$list = $this->getlist('*', $filter, $offset * $limit, $limit) )return false;
        
        //字段属性
        $order_Obj      = app::get('invoice')->model('order');
        $columns        = $order_Obj->schema;
        $type_id        = $columns['columns']['type_id']['type'];
        $is_status      = $columns['columns']['is_status']['type'];
        
        $Oorders    = app::get('ome')->model('orders');
        $col_list   = $Oorders->schema;
        $process_status = $col_list['columns']['process_status']['type'];
        
        //批次号(第四段)
        $oDelivery      = app::get('ome')->model('print_queue_items');
        
        //
        $db        = kernel::database();
        foreach($list as $key => $row)
        {
            #来源店铺
            $sql_shop  = "SELECT b.name FROM ".DB_PREFIX."ome_orders as a 
                   LEFT JOIN ".DB_PREFIX."ome_shop as b ON a.shop_id=b.shop_id 
                   WHERE a.order_id='".$row['order_id']."'";
            $shop_name  = $db->select($sql_shop);
            $row['shop_name']   = $shop_name[0]['name'];
            
            #批次号(第四段)
            $delivery_arr   = array();
            if(!empty($row['batch_number']) && !empty($row['delivery_id']))
            {
                $delivery_arr   = $oDelivery->getList('ident_dly', array('delivery_id' => $row['delivery_id'],
                                    'ident' => $row['batch_number']), 0, 1);
                $row['batch_number']    .= '_'.$delivery_arr[0]['ident_dly'];
            }
            
            unset($row['id'], $row['order_id'], $row['is_print'], $row['delivery_id'], $row['operator'], $row['print_time']);
            
            $rowVal = array();
            $rowVal['*:订单号']        = "\t".$row['order_bn'];
            $rowVal['*:订单确认状态']   = $process_status[$row['process_status']];
            $rowVal['*:来源店铺']       = $row['shop_name'];
            $rowVal['*:发票类型']       = $type_id[$row['type_id']];
            $rowVal['*:开票金额']       = $row['amount'];
            
            $rowVal['*:税金']     = $row['cost_tax'];
            $rowVal['*:税率']     = $row['tax_rate'];
            $rowVal['*:发票抬头'] = $row['title'];
            $rowVal['*:开票状态'] = $is_status[$row['is_status']];
            $rowVal['*:发票号']   = $row['invoice_no'];
            
            $rowVal['*:发票内容']   = $row['content'];
            $rowVal['*:批次号']     = $row['batch_number'];
            $rowVal['*:发票备注']   = $row['remarks'];
            $rowVal['*:打印次数']   = $row['print_num'];
            $rowVal['*:创建日期']   = ($row['create_time'] ? date('Y-m-d H:i', $row['create_time']) : '');
            
            $rowVal['*:开票时间']   = ($row['dateline'] ? date('Y-m-d H:i', $row['dateline']) : '');
            $rowVal['*:客户名称']   = $row['tax_company'];
            $rowVal['*:收货地区']   = $row['ship_area'];
            $rowVal['*:客户地址']   = $row['ship_addr'];
            $rowVal['*:客户电话']   = $row['ship_tel'];
            
            $rowVal['*:客户税号']       = $row['ship_tax'];
            $rowVal['*:客户开户银行']   = $row['ship_bank'];
            $rowVal['*:客户银行账号']   = $row['ship_bank_no'];
            
            $data['content'][] = '"' . implode( '","', $rowVal ) . '"';
        }
        
        return true;
    }
    /*------------------------------------------------------ */
    //-- 更新批次号
    /*------------------------------------------------------ */
    function update_batch_number($allItems, $idents){
       if(empty($allItems) || empty($idents['idents'])){
          return false;
       }
       
       $inOrder       = app::get('invoice')->model('order');
       $batch_number  = join(',', $idents['idents']);//批次号前三段,例：1-40409-0176
      
       $new_data      = array();
       foreach ($allItems as $key => $volist){
         foreach ($volist['delivery_order'] as $key_j => $val){
            //更新批次号+发货单号
            $new_data   = array('batch_number' => $batch_number, 'delivery_id'=>$val['delivery_id']);
            $inOrder->update($new_data, array('order_id'=>$val['order_id']));
         }
      }
      return true;
    }
    /**
     * 输出导出数据
     * @param Array $data 数据
     * @param Int $exportType 输出类型
     */
    function export_csv($data, $exportType = 1 )
    {
        if(!$this->is_queue_export)
        {
            foreach ($data['content'] as $key => $value)
            {
                $data['content'][$key] = $value;
            }
        }

        $output     = array();
        $output[]   = $this->charset->utf2local($data['title']."\n".implode("\n",(array)$data['content']));

        if ($this->is_queue_export == true)
        {
            return implode("\n",$output);
        } else {
            echo implode("\n",$output);
        }
    }
    //获取操作人名
    function modifier_operator($row){
       $mdlDesktopUsers = app::get('desktop')->model('users');
       $operator_name = "system";
       if( intval($row)>0 ){
        $rs_user = $mdlDesktopUsers->dump(array("user_id"=>$row));
        $operator_name = $rs_user["name"];
       }
       return $operator_name;
    }

    public function disabled_export_cols(&$cols){
        unset($cols['column_edit']);
    }

    public function modifier_ship_tel($ship_tel,$list,$row)
    {
        $is_encrypt = kernel::single('ome_security_hash')->check_encrypt($ship_tel);
        if (!$is_encrypt) return $ship_tel;
        
        $base_url = kernel::base_url(1);$id = $row['id'];
        $encrypt = kernel::single('ome_view_helper2')->modifier_ciphertext($ship_tel,'invoice','ship_tel');
$return =<<<HTML
<a class="data-hide" href="javascript:void(0);" onclick="Ex_Loader('security',function(){new Security({url:'index.php?app=invoice&ctl=admin_order&act=showSensitiveData&p[0]={$id}&p[1]=invoice',clickElement:\$(event.target)}).desHtml(\$(event.target).getNext()); });"></a><span><span sensitive-field="ship_tel">{$encrypt}</span></span>
HTML;
        return $ship_tel?$return:$ship_tel;
    }

    public function modifier_ship_addr($ship_addr,$list,$row)
    {
        $is_encrypt = kernel::single('ome_security_hash')->check_encrypt($ship_addr);
        if (!$is_encrypt) return $ship_addr;
        
        $id = $row['id'];
        $encryptAddr = kernel::single('ome_view_helper2')->modifier_ciphertext($ship_addr,'invoice','ship_addr');

$return =<<<HTML
<a class="data-hide" href="javascript:void(0);" onclick="Ex_Loader('security',function(){new Security({url:'index.php?app=invoice&ctl=admin_order&act=showSensitiveData&p[0]={$id}&p[1]=invoice',clickElement:\$(event.target)}).desHtml(\$(event.target).getNext()); });"></a><span><span sensitive-field="ship_addr">{$encryptAddr}</span></span>
HTML;
        return $ship_addr?$return:$ship_addr;
    }

    public function modifier_ship_bank_no($ship_bank_no,$list,$row)
    {
        $is_encrypt = kernel::single('ome_security_hash')->check_encrypt($ship_bank_no);
        if (!$is_encrypt) return $ship_bank_no;
        
        $base_url = kernel::base_url(1);$id = $row['id'];
        $encryptValue = kernel::single('ome_view_helper2')->modifier_ciphertext($ship_bank_no,'invoice','ship_bank_no');
$return =<<<HTML
<a class="data-hide" href="javascript:void(0);" onclick="Ex_Loader('security',function(){new Security({url:'index.php?app=invoice&ctl=admin_order&act=showSensitiveData&p[0]={$id}&p[1]=invoice',clickElement:\$(event.target)}).desHtml(\$(event.target).getNext()); });"></a><span><span sensitive-field="ship_bank_no">{$encryptValue}</span></span>
HTML;
        return $ship_bank_no?$return:$ship_bank_no;
    }
    
    public function modifier_ship_tax($ship_tax,$list,$row)
    {
        $is_encrypt = kernel::single('ome_security_hash')->check_encrypt($ship_tax);
        if (!$is_encrypt) return $ship_tax;
        
        $base_url = kernel::base_url(1);$id = $row['id'];
        $encryptValue = kernel::single('ome_view_helper2')->modifier_ciphertext($ship_tax,'invoice','ship_tax');

$return =<<<HTML
<a class="data-hide" href="javascript:void(0);" onclick="Ex_Loader('security',function(){new Security({url:'index.php?app=invoice&ctl=admin_order&act=showSensitiveData&p[0]={$id}&p[1]=invoice',clickElement:\$(event.target)}).desHtml(\$(event.target).getNext()); });"></a><span><span sensitive-field="ship_tax">{$encryptValue}</span></span>
HTML;
        return $ship_tax?$return:$ship_tax;
    }
    
    public function modifier_ship_bank($ship_bank,$list,$row)
    {
        $is_encrypt = kernel::single('ome_security_hash')->check_encrypt($ship_bank);
        if (!$is_encrypt) return $ship_bank;
        
        $base_url = kernel::base_url(1);$id = $row['id'];
        $encryptValue = kernel::single('ome_view_helper2')->modifier_ciphertext($ship_bank,'invoice','ship_bank');

$return =<<<HTML
<a class="data-hide" href="javascript:void(0);" onclick="Ex_Loader('security',function(){new Security({url:'index.php?app=invoice&ctl=admin_order&act=showSensitiveData&p[0]={$id}&p[1]=invoice',clickElement:\$(event.target)}).desHtml(\$(event.target).getNext()); });"></a><span><span sensitive-field="ship_bank">{$encryptValue}</span></span>
HTML;
        return $ship_bank?$return:$ship_bank;
    }

    public function insert(&$data)
    {
        foreach ($this->__encrypt_cols as $field => $type) {
            if (isset($data[$field])) {
                $data[$field] = (string) kernel::single('ome_security_factory')->encryptPublic($data[$field],$type);
            }
        }
        return parent::insert($data);
    }
    
    public function update($data,$filter=array(),$mustUpdate = null)
    {
        foreach ($this->__encrypt_cols as $field => $type) {
            if (isset($data[$field])) {
                $data[$field] = (string) kernel::single('ome_security_factory')->encryptPublic($data[$field],$type);
            }
        }
        
        return parent::update($data,$filter,$mustUpdate);
    }
    
    function _filter($filter,$tableAlias=null,$baseWhere=null)
    {
        $where = " 1 ";
        if (isset($filter['order_bn'])) {
            if($filter['order_bn'] && is_string($filter['order_bn']) && strpos($filter['order_bn'], "\n") !== false){
                $filter['order_bn'] = array_unique(array_map('trim', array_filter(explode("\n", $filter['order_bn']))));
            }
            $oItemList = $this->app->model('order_items')->getList('id',['source_bn'=>$filter['order_bn']]);
            if(!empty($oItemList)){
                $where .= ' AND id IN ('.implode(',', array_column($oItemList,'id')).')';
            }else{
                $where .= ' AND order_bn = "order_bn"';
            }
            unset($filter['order_bn']);
        }

        return $where ." AND ".parent::_filter($filter,$tableAlias,$baseWhere);
    }

    public function getList($cols='*', $filter=array(), $offset=0, $limit=-1, $orderType=null)
    {
        
        $data = parent::getList($cols,$filter,$offset,$limit,$orderType);
        
        foreach ((array) $data as $key => $value) {
            foreach ($this->__encrypt_cols as $field => $type) {
                if (isset($value[$field])) {
                    $data[$key][$field] = (string) kernel::single('ome_security_factory')->decryptPublic($value[$field],$type);
                }
            }
        }
        
        return $data;
    }

    public function getInvoiceTemplateColumn()
    {
        return $this->invoiceTemplateColumn;
    }

    public function getWaybillTemplateColumn()
    {
        return $this->waybillTemplateColumn;
    }

    // public function get_Schema()
    // {

    //     $shopName = array_column(app::get('ome')->model('shop')->getList('name,shop_id'),'name','shop_id');

    //     $data = parent::get_Schema();
    //     $data['columns']['shop_id']['type'] = $shopName;
    //     $data['columns']['shop_id']['filtertype'] = 'fuzzy_search_multiple';
    //     $data['columns']['shop_id']['filterdefault'] = true;
    //     return $data;
        
    // }
    
    public function modifier_payee_name($col,$list,$row){
        $mode      = intval($row[$this->col_prefix.'mode']);
        $shop_id   = $row[$this->col_prefix.'shop_id'];
        $rs = $this->__getOrderSetting($shop_id,$mode);
        return $col ?: $rs['payee_name'];
    }
    
    public function modifier_tax_no($col, $list, $row)
    {
        $mode    = intval($row[$this->col_prefix . 'mode']);
        $shop_id = $row[$this->col_prefix . 'shop_id'];
        $rs      = $this->__getOrderSetting($shop_id, $mode);
        return $col ?: $rs['tax_no'];
    }
    
    public function modifier_address($col, $list, $row)
    {
        $mode    = intval($row[$this->col_prefix . 'mode']);
        $shop_id = $row[$this->col_prefix . 'shop_id'];
        $rs      = $this->__getOrderSetting($shop_id, $mode);
        return $col ?: $rs['address'];
    }
    
    public function modifier_telephone($col, $list, $row)
    {
        $mode    = intval($row[$this->col_prefix . 'mode']);
        $shop_id = $row[$this->col_prefix . 'shop_id'];
        $rs      = $this->__getOrderSetting($shop_id, $mode);
        return $col ?: $rs['telephone'];
    }
    
    public function modifier_payee_operator($col, $list, $row)
    {
        $mode    = intval($row[$this->col_prefix . 'mode']);
        $shop_id = $row[$this->col_prefix . 'shop_id'];
        $rs      = $this->__getOrderSetting($shop_id, $mode);
        return $col ?: $rs['payee_operator'];
    }
    
    public function modifier_bank($col, $list, $row)
    {
        $mode    = intval($row[$this->col_prefix . 'mode']);
        $shop_id = $row[$this->col_prefix . 'shop_id'];
        $rs      = $this->__getOrderSetting($shop_id, $mode);
        return $col ?: $rs['bank'];
    }
    
    public function modifier_bank_no($col, $list, $row)
    {
        $mode    = intval($row[$this->col_prefix . 'mode']);
        $shop_id = $row[$this->col_prefix . 'shop_id'];
        $rs      = $this->__getOrderSetting($shop_id, $mode);
        return $col ?: $rs['bank_no'];
    }
    
    public function modifier_payee_checker($col, $list, $row)
    {
        $mode    = intval($row[$this->col_prefix . 'mode']);
        $shop_id = $row[$this->col_prefix . 'shop_id'];
        $rs      = $this->__getOrderSetting($shop_id, $mode);
        return $col ?: $rs['payee_checker'];
    }
    
    public function modifier_payee_receiver($col, $list, $row)
    {
        $mode    = intval($row[$this->col_prefix . 'mode']);
        $shop_id = $row[$this->col_prefix . 'shop_id'];
        $rs      = $this->__getOrderSetting($shop_id, $mode);
        return $col ?: $rs['payee_receiver'];
    }
    
    /**
     * 查询发票配置信息
     * @Author: xueding
     * @Vsersion: 2023/6/15 下午4:09
     * @param $shop_id
     * @param $mode
     * @return mixed
     */
    public function __getOrderSetting($shop_id, $mode)
    {
        static $res;
        
        if ($res) {
            return $res;
        }
        
        $rs = kernel::single('invoice_func')->get_order_setting($shop_id, $mode);
        if ($rs) {
            $res = $rs[0];
        }
        return $rs[0];
    }
}