Warning: include(../omc/inc/init_db.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 6
Warning: include(../omc/inc/init_db.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 6
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/sale_goods_rpt.php on line 6
Warning: include(../common/inc/get_date_format.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 16
Warning: include(../common/inc/get_date_format.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 16
Warning: include(): Failed opening '../common/inc/get_date_format.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 16
Warning: include(../common/inc/get_quantity_format.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 17
Warning: include(../common/inc/get_quantity_format.inc): failed to open stream: No such file or directory in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 17
Warning: include(): Failed opening '../common/inc/get_quantity_format.inc' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 17
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 77
Warning: mysqli_error() expects parameter 1 to be mysqli, null given in /home/otomotif/public_html/sipade/common/inc/sale_goods_rpt.php on line 77
create temporary table t_table (
customer_code varchar(10),
invoice_no char(5),
goods_code varchar(20) not null,
goods_code_ref varchar(20) not null,
goods_group_name varchar(100),
goods_name_complete varchar(100),
stock double unsigned,
quantity double unsigned,
sale_price double unsigned,
unit_of_measure char(2),
total_quantity_buy double unsigned
)