如何在【费目】一旦出现的外贸箱提箱作业关键词后 就把金额这一栏的数字保留并且移到优惠这一列中并显示!-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();
}
}