part ก็เช็คแล้วถูก ไม่แน่ใจเหมือนกันค่ะว่าเขียนถูกไหม
โค้ด: เลือกทั้งหมด
<?php
class mPaymentype extends CI_Model{
public function FSnClearDatahistory($ptFileName)
{
// $this->load->helper("file");
// delete_files(base_url().'/application/reports/data/',TRUE);
$fp = fopen(APPPATH."/reports/data/".$ptFileName, "r+");
// clear content to 0 bits
ftruncate($fp, 0);
//close file
fclose($fp);
}
function FSnPaymenttype(){
$this->FSnClearDatahistory('chart2.txt');
$sql = "SELECT MRC.FTRcvCode,MRC.FTRcvName,ISNULL(RC.FCSrcNet,0) AS FCSrcNet
FROM TPSMRcv MRC
LEFT JOIN (SELECT FTRcvCode,SUM(FCSrcNet) AS FCSrcNet
FROM TPSTSalRC
WHERE CONVERT(VARCHAR(10),FDShdDocDate,121) = '2018-08-21'
GROUP BY FTRcvCode)RC ON RC.FTRcvCode = MRC.FTRcvCode
WHERE MRC.FTRcvStaUsed = 1";
$oQuery = $this->db->query($sql);
if ($oQuery->num_rows() > 0){
}
$oData = $oQuery->result_array();
$json_arr = json_encode($oData,true);
echo $json_arr;
file_put_contents(APPPATH."/reports/data/chart2.txt", json_encode($oData,true));
return $oQuery->result();
}
}
?>