query($sql); echo "Header item insertted"; $sql="select * from scm_mr_hdr order by jute_receive_no desc limit 1"; $result = $connect->query($sql); while($row = $result->fetch_assoc()) { $mxjhhed=$row["jute_receive_no"]; } echo 'last hdr'. $mxjhhed; $sql="select * from jute_gate_entry_dtl jged where hdr_id =".$payscmn." and is_active=1 order by jged.rec_id desc"; $sql="insert into scm_mr_line_item (accepted_weight,actual_bale,actual_loose,actual_quality,actual_weight, advised_item_code,advised_quality,advised_weight,allowable_moisture,bale,company_id,created_by,is_active, item_code,jute_gate_entry_lineitem_no,loose,jute_receive_no,quantity,quantity_unit,rate,shortage_kgs, status,advised_quantity,drums_consumed,weight_consumed,variable_shortage,bales_consumed ) select qc_jute_weight*100,case when received_in='BALE' then actual_quantity else 0 end actual_bale , case when received_in='BALE' then 0 else actual_quantity end actual_loose , actual_quality,jged.qc_jute_weight, advised_jute_typ,advised_quality,advised_weight,18,case when received_in='BALE' then actual_quantity else 0 end bale,2,created_by,1,qc_jute_type, rec_id,case when received_in='BALE' then 0 else actual_quantity end loose,".$mxjhhed.",actual_quantity,uom,0,0,1,advised_quantity,0,0,0,0 from jute_gate_entry_dtl jged where jged.hdr_id =".$payscmn; $connect->query($sql); echo "line item insertted"; $connect->close(); $conn->close(); } ?>

Submit