Warning: include(../omc/inc/init_db.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/common/inc/buy_upload_read_excel_insert_tasti_sales_daily.php on line 8
Warning: include(../omc/inc/init_db.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/common/inc/buy_upload_read_excel_insert_tasti_sales_daily.php on line 8
Warning: include(): Failed opening '../omc/inc/init_db.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/otomotif/public_html/sipade/common/inc/buy_upload_read_excel_insert_tasti_sales_daily.php on line 8
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/common/inc/buy_upload_read_excel_insert_tasti_sales_daily.php on line 42
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/common/inc/buy_upload_read_excel_insert_tasti_sales_daily.php on line 42
create temporary table tasti_sales_daily_temp (
invoice_date date not null,
seq_no char(4) not null,
invoice_no varchar(15) not null,
so_no varchar(10) not null,
partnumber varchar(20) not null,
partname varchar(50) not null,
qty double unsigned not null,
retail_price double unsigned not null,
total_discount decimal(5,2) not null,
dpp double unsigned not null,
ppn double unsigned not null,
total_amount double unsigned not null,
due_date date not null,
discount decimal(5,2) not null,
rec_status char(1) not null,
last_update_by varchar(10) not null,
last_update_date datetime not null,
last_ip_address char(15) not null
)