PHP小修改

图片描述

如何在【费目】一旦出现的外贸箱提箱作业关键词后 就把金额这一栏的数字保留并且移到优惠这一列中并显示!-400的字样,附上代码

<?php
class FsslController extends Admin{
    public function __construct() {
        parent::__construct();
        $this->oracle= $this->model("oracle");        
    }
    
    public function indexAction(){
        
        //print_r($data);
        $fields = array(
            "FSNUMBER"=>"清单编号",                            
            "PAYER"=>"付费人",    
            "VNAMECD"=>"船名",    
            "VOYAGE"=>"航次",    
            "FSMODE"=>"付款方式",    
            "CHB_IE"=>"进出口",    
            "REMARK"=>"备注",    
            "FSTIME"=>"制单时间",    
            "FSCONTENT"=>"费目",    
            "CAMT"=>"数量",        
            "PRICE"=>"单价",        
            "MONEY"=>"金额",        
            "PLANNO"=>"计划号",
            "MONEYY"=>"优惠",
            
            //"ADDRESS"=>"受理地点",    

        );
        $this->load->file(APPPATH."fields.php");
        $page         =     $this->input->get("page");
        $page         =     $page ? $page : 1;
        $pagesize    =   $this->input->get("pagesize");
        $pagesize     =     $pagesize ? $pagesize : 25;
        $where      =    array();
        
        $searchData =   $this->input->get("data");

        $payer     =      strtoupper($searchData["PAYER"]);
        $address=    $searchData["ADDRESS"];
        $FSNUMBER=$searchData["FSNUMBER"];
        $payer     &&     $where[]= "payer like '%$payer%'";
        $address     &&     $where[]= "address = '$address'";
        $FSNUMBER     &&     $where[]= "FSNUMBER = '$FSNUMBER'";
        
        if($searchData["start_time"]){
            $where[] = "FSTIME >= '".$searchData["start_time"]."'";//to_date('".$searchData["start_time"]."','yyyy-mm-dd hh24:mi')";
        }
        if($searchData["end_time"]){
            $where[] = "FSTIME <= '".$searchData["end_time"]."'";
        }
        if($this->input->get("submit")=="导出"){
            $data = $this->oracle->page("*", "ALL_FS_SL_LIST_VM", $where, "", $page, 10000);
            $this->export($fields, $data);
        }
        $data = $this->oracle->page("*", "ALL_FS_SL_LIST_VM", $where, "", $page);
        $total= $this->oracle->cnt("ALL_FS_SL_LIST_VM", $where);
        //echo $page;
        $urlparam = array(
            "page" => "{page}",
            'data[PAYER]'    => $payer,
            'data[ADDRESS]'    => $address,
            'data[FSNUMBER]'    => $FSNUMBER,
            "data[start_time]"=>$searchData["start_time"],
            "data[end_time]"=>$searchData["end_time"],
        );
        $pagelist = $this->instance('pagelist');    //加载分页类
        $pagelist->loadconfig();
        $pagelist = $pagelist->total($total)->url(url("admin/fssl/", $urlparam) )->num($pagesize)->page($page)->output();
        //echo $pagelist;
        $searchForm = "清单编号:   ".content_input("FSNUMBER", array($FSNUMBER));
        $searchForm.= "付费人:   ".content_input("PAYER", array($payer));
        $searchForm.= "受理地点:   ".content_input("ADDRESS", array($address));
        $searchForm.= "制单时间:   ".content_datetime("start_time", array($searchData["start_time"]), array("type"=>"yyyy-MM-dd HH:mm"));
        $searchForm.= "—".content_datetime("end_time", array($searchData["end_time"]), array("type"=>"yyyy-MM-dd HH:mm"));
        $searchForm.= '<input type="submit" class="btn btn-success btn-sm" value="搜索" name="submit">';
        $searchForm.= '<input type="submit" class="btn btn-success btn-sm" value="导出" name="submit">';
        $this->view->assign(array(
            'searchValue'    => array('c'=>'fssl', 'a'=>'index'),
            'searchForm'    => $searchForm,
            'data'            => $data,
            'fields'        => $fields,
            'pagelist'      => $pagelist,
            'del'            => 1
        ));
        $this->view->display('admin/list');
    }
    
    private function export($fields, $data){
        $this->load->file(APPPATH."PHPExcel/PHPExcel.php");
        $basepath = APPPATH."PHPExcel//";
        $objPHPExcel = PHPExcel_IOFactory::load($basepath."tpl.xlsx");
        $objSheet = $objPHPExcel->setActiveSheetIndex(0);
        $cnt = 0;
        foreach($fields as $key=>$value){
            $k = chr(ord("A") + $cnt);
            $objSheet->setCellValueExplicit($k."1", $value, PHPExcel_Cell_DataType::TYPE_STRING);
            $cnt += 1;
        }
        //print_r($data);
        foreach ($data as $key => $value) {
            if($key>=10000){break;}
            $cnt = 0;
            foreach ($fields as $k => $v) {
                $col = chr(ord("A") + $cnt);
                if(isset($value[$k])){
                    $objSheet->setCellValueExplicit($col.($key+2), $value[$k], PHPExcel_Cell_DataType::TYPE_STRING);
                }
                $cnt += 1;
            }
        }
        $filename = $this->action.'.xlsx';
        $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
        $objWriter->save($basepath.$filename);
        header ("Location:/cost/extensions/PHPExcel/$filename?t=".time());
        exit();    
    }
}
阅读 1.3k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题