2 /**********************************************************************
3 Copyright (C) FrontAccounting, LLC.
4 Released under the terms of the GNU General Public License, GPL,
5 as published by the Free Software Foundation, either version 3
6 of the License, or (at your option) any later version.
7 This program is distributed in the hope that it will be useful,
8 but WITHOUT ANY WARRANTY; without even the implied warranty of
9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10 See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
11 ***********************************************************************/
12 $page_security = 'SA_WORKORDERCOST';
14 include_once($path_to_root . "/includes/session.inc");
16 include_once($path_to_root . "/includes/date_functions.inc");
17 include_once($path_to_root . "/gl/includes/db/gl_db_bank_trans.inc");
18 include_once($path_to_root . "/includes/db/inventory_db.inc");
19 include_once($path_to_root . "/includes/manufacturing.inc");
21 include_once($path_to_root . "/manufacturing/includes/manufacturing_db.inc");
22 include_once($path_to_root . "/manufacturing/includes/manufacturing_ui.inc");
25 if ($use_popup_windows)
26 $js .= get_js_open_window(900, 500);
28 $js .= get_js_date_picker();
29 page(_("Work Order Additional Costs"), false, false, "", $js);
31 if (isset($_GET['trans_no']) && $_GET['trans_no'] != "")
33 $_POST['selected_id'] = $_GET['trans_no'];
36 //--------------------------------------------------------------------------------------------------
38 if (isset($_GET['AddedID']))
40 $id = $_GET['AddedID'];
41 $stype = systypes::work_order();
43 display_notification(_("The additional cost has been entered."));
45 display_note(get_trans_view_str($stype, $id, _("View this Work Order")));
47 display_note(get_gl_view_str($stype, $id, _("View the GL Journal Entries for this Work Order")), 1);
49 hyperlink_params("work_order_costs.php", _("Enter another additional cost."), "trans_no=$id");
51 hyperlink_no_params("search_work_orders.php", _("Select another &Work Order to Process"));
57 //--------------------------------------------------------------------------------------------------
59 $wo_details = get_work_order($_POST['selected_id']);
61 if (strlen($wo_details[0]) == 0)
63 display_error(_("The order number sent is not valid."));
67 //--------------------------------------------------------------------------------------------------
69 function can_process()
73 if (!check_num('costs', 0))
75 display_error(_("The amount entered is not a valid number or less then zero."));
80 if (!is_date($_POST['date_']))
82 display_error(_("The entered date is invalid."));
86 elseif (!is_date_in_fiscalyear($_POST['date_']))
88 display_error(_("The entered date is not in fiscal year."));
92 if (date_diff2(sql2date($wo_details["released_date"]), $_POST['date_'], "d") > 0)
94 display_error(_("The additional cost date cannot be before the release date of the work order."));
102 //--------------------------------------------------------------------------------------------------
104 if (isset($_POST['process']) && can_process() == true)
107 add_gl_trans_std_cost(systypes::work_order(), $_POST['selected_id'], $_POST['date_'], $_POST['cr_acc'],
108 0, 0, $wo_cost_types[$_POST['PaymentType']], -input_num('costs'), payment_person_types::WorkOrder(), $_POST['PaymentType']);
109 $is_bank_to = is_bank_account($_POST['cr_acc']);
112 add_bank_trans(systypes::work_order(), $_POST['selected_id'], $is_bank_to, "",
113 $_POST['date_'], -input_num('costs'), payment_person_types::WorkOrder(), $_POST['PaymentType'], get_company_currency(),
114 "Cannot insert a destination bank transaction");
117 add_gl_trans_std_cost(systypes::work_order(), $_POST['selected_id'], $_POST['date_'], $_POST['db_acc'],
118 $_POST['dim1'], $_POST['dim2'], $wo_cost_types[$_POST['PaymentType']], input_num('costs'), payment_person_types::WorkOrder(),
119 $_POST['PaymentType']);
120 commit_transaction();
122 meta_forward($_SERVER['PHP_SELF'], "AddedID=".$_POST['selected_id']);
125 //-------------------------------------------------------------------------------------
127 display_wo_details($_POST['selected_id']);
129 //-------------------------------------------------------------------------------------
133 hidden('selected_id', $_POST['selected_id']);
134 //hidden('WOReqQuantity', $_POST['WOReqQuantity']);
136 start_table($table_style2);
140 yesno_list_row(_("Type:"), 'PaymentType', null, $wo_cost_types[WO_OVERHEAD], $wo_cost_types[WO_LABOUR]);
142 date_row(_("Date:"), 'date_');
144 $item_accounts = get_stock_gl_code($wo_details['stock_id']);
145 $_POST['db_acc'] = $item_accounts['assembly_account'];
146 $sql = "SELECT DISTINCT account_code FROM ".TB_PREF."bank_accounts";
147 $rs = db_query($sql,"could not get bank accounts");
148 $r = db_fetch_row($rs);
149 $_POST['cr_acc'] = $r[0];
151 amount_row(_("Additional Costs:"), 'costs');
152 gl_all_accounts_list_row(_("Debit Account"), 'db_acc', null);
153 gl_all_accounts_list_row(_("Credit Account"), 'cr_acc', null);
156 hidden('dim1', $item_accounts["dimension_id"]);
157 hidden('dim2', $item_accounts["dimension2_id"]);
159 submit_center('process', _("Process Additional Cost"), true, '', true);