5 10=> array('code' => 'si', 'name' => _("Sales Invoice")),
6 11=> array('code' => 'si', 'name' => _("Sales Credit Note")),
7 30=> array('code' => 'so', 'name' => _("Sales Order")),
9 18=> array('code' => 'po', 'name' => _("Purchase Order")),
11 26=> array('code' => 'wo', 'name' => _("Work Order")),
12 28=> array('code' => 'wo', 'name' => _("Work Order Issue")),
13 29=> array('code' => 'wo', 'name' => _("Work Order Production")),
15 40=> array('code' => 'qw', 'name' => _("Cheque Withdrawal")),
16 41=> array('code' => 'qd', 'name' => _("Cheque Deposit")),
18 50=> array('code' => 'cw', 'name' => _("Cash Withdrawal")),
19 51=> array('code' => 'cd', 'name' => _("Cash Deposit")),
21 60=> array('code' => 'ir', 'name' => _("Inventory Release")),
22 61=> array('code' => 'ia', 'name' => _("Inventory Add")),
23 62=> array('code' => 'it', 'name' => _("Inventory Return"))
26 function getFormTypeName($type)
29 return $form_types[$type]['name'];
32 function add_forms_for_sys_type($trans_type, $trans_id, $ParamFrom=null, $ParamTo=null)
34 switch ($trans_type) {
35 case 1 : // bank payment
36 case 22 : // payment to supplier
37 add_form_entry(50, $trans_type, $trans_id, $ParamFrom, $ParamTo);
40 case 12: // payment from customer
41 case 2 : // bank deposit
42 add_form_entry(51, $trans_type, $trans_id, $ParamFrom, $ParamTo);
45 case 4 : // bank transfer - withdraw and deposit
46 add_form_entry(50, $trans_type, $trans_id, $ParamFrom, $ParamTo);
47 add_form_entry(51, $trans_type, $trans_id, $ParamTo, $ParamFrom);
50 case 10 : // sales invoice - invoice form
51 add_form_entry(10, $trans_type, $trans_id);
54 case 13 : // sales dispatch - inventory release
55 add_form_entry(60, $trans_type, $trans_id, $ParamFrom);
58 case 11 : // sales credit - inventory return and credit note forms
59 add_form_entry(62, $trans_type, $trans_id, $ParamFrom);
60 add_form_entry(11, $trans_type, $trans_id);
63 case 16 : // location transfer
64 add_form_entry(60, $trans_type, $trans_id, $ParamFrom);
65 add_form_entry(61, $trans_type, $trans_id, $ParamTo);
68 case systypes::inventory_adjustment() : // inventory adjustment
70 // $ParamFrom : if 1 inventory add, 0 inventory release
72 add_form_entry(61, $trans_type, $trans_id, $ParamTo);
74 add_form_entry(60, $trans_type, $trans_id, $ParamTo);
77 case systypes::po() : // purchase order
78 add_form_entry(18, $trans_type, $trans_id);
81 case 25 : // purchase order delivery
82 add_form_entry(61, $trans_type, $trans_id, $ParamFrom);
85 case systypes::work_order() : // work order
86 add_form_entry(26, $trans_type, $trans_id);
89 case 28 : // work order issue
90 // $ParamFrom : if 1 inventory add, 0 inventory release
92 add_form_entry(61, $trans_type, $trans_id, $ParamTo);
94 add_form_entry(60, $trans_type, $trans_id, $ParamTo);
97 case 29 : // work order production
98 // $ParamFrom is the quantity - if +ve inventory add, -ve inventory release
100 add_form_entry(61, $trans_type, $trans_id, $ParamTo);
102 add_form_entry(60, $trans_type, $trans_id, $ParamTo);
105 case 30 : // sales order - sales order form
106 add_form_entry(30, $trans_type, $trans_id);
111 function add_form_entry($form_type, $trans_type, $trans_id, $param1=null, $param2=null)
113 $sql = "SELECT max(form_id) FROM ".TB_PREF."form_items WHERE form_type=$form_type";
114 $result = db_query($sql, "could not get next form_id");
115 $row = db_fetch_row($result);
116 $form_id = $row[0] + 1;
118 $sql = "INSERT INTO ".TB_PREF."form_items (form_id, form_type, trans_type, trans_id, param1, param2)
119 VALUES ($form_id, $form_type, $trans_type, $trans_id, '$param1', '$param2')";
120 $result = db_query($sql, "could not add form entry for $trans_type, $trans_id");
123 function delete_forms_for_systype($trans_type, $trans_id)
125 $sql = "DELETE FROM ".TB_PREF."form_items WHERE trans_type=$trans_type AND trans_id=$trans_id";
126 $result = db_query($sql, "could not delete form entry for $trans_type, $trans_id");
129 function get_form_entries($trans_type, $trans_id)
131 $sql = "SELECT * FROM ".TB_PREF."form_items WHERE trans_type=$trans_type AND trans_id=$trans_id";
132 $result = db_query($sql, "could not query form entry for $trans_type, $trans_id");