<?php
include 'dbTool.php';
$sqliteconn=sqlconnect("../../DB/A104-495","SALES_201811.DB","","","","sqlite");
$year='2018';
$month='11';
$day='29';
$sql="SELECT CST012.CONSECNUMBER AS CONSECNUMBER,CST012.LINENUMBER AS LINENUMBER,CST012.BIZDATE AS BIZDATE,CST012.DTLMODE AS DTLMODE,CST012.DTLTYPE AS DTLTYPE,CST012.DTLFUNC AS DTLFUNC,CST012.ITEMCODE AS ITEMCODE,CST012.ITEMNAME AS ITEMNAME,CST012.ITEMGRPCODE AS ITEMGRPCODE,CST012.ITEMGRPNAME AS ITEMGRPNAME,CST012.ITEMDEPTCODE AS ITEMDEPTCODE,CST012.ITEMDEPTNAME AS ITEMDEPTNAME,CST012.WEIGHT AS WEIGHT,CST012.QTY AS QTY,CST012.UNITPRICE AS UNITPRICE,CST012.AMT AS AMT,CST011.CUSTGPCODE AS CUSTGPCODE,CST011.CUSTGPNAME AS CUSTGPNAME,CST012.ZCOUNTER AS ZCOUNTER,CST012.CREATEDATETIME AS CREATEDATETIME,CST011.SALESTTLAMT AS SALESTTLAMT,CST011.INVOICENUMBER AS INVOICENUMBER FROM CST012 JOIN (SELECT BIZDATE,CONSECNUMBER,ZCOUNTER,CUSTGPCODE,CUSTGPNAME,SALESTTLAMT,INVOICENUMBER FROM CST011) ON CST011.BIZDATE=CST012.BIZDATE AND CST011.CONSECNUMBER=CST012.CONSECNUMBER WHERE CST012.CONSECNUMBER<>'000000' AND ((CST012.DTLMODE='1' AND CST012.DTLTYPE='1' AND (CST012.DTLFUNC='01' OR CST012.DTLFUNC='03') AND CST012.ITEMDEPTCODE<>'000008') OR (CST012.DTLMODE='1' AND (CST012.DTLTYPE='2' OR CST012.DTLTYPE='3'))) ORDER BY CST012.BIZDATE DESC,CST012.CREATEDATETIME ASC,CST012.ZCOUNTER ASC";
$table=sqlquery($sqliteconn,$sql,'sqlite');
print_r($table);
?>