manufacturing/work_order_costs.php

   1 <?php
   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';
  13 $path_to_root = "..";
  14 include_once($path_to_root . "/includes/session.inc");
  15
  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");
  20
  21 include_once($path_to_root . "/manufacturing/includes/manufacturing_db.inc");
  22 include_once($path_to_root . "/manufacturing/includes/manufacturing_ui.inc");
  23
  24 $js = "";
  25 if ($use_popup_windows)
  26         $js .= get_js_open_window(900, 500);
  27 if ($use_date_picker)
  28         $js .= get_js_date_picker();
  29 page(_("Work Order Additional Costs"), false, false, "", $js);
  30
  31 if (isset($_GET['trans_no']) && $_GET['trans_no'] != "")
  32 {
  33         $_POST['selected_id'] = $_GET['trans_no'];
  34 }
  35
  36 //--------------------------------------------------------------------------------------------------
  37
  38 if (isset($_GET['AddedID']))
  39 {
  40         $id = $_GET['AddedID'];
  41         $stype = systypes::work_order();
  42
  43         display_notification(_("The additional cost has been entered."));
  44
  45     display_note(get_trans_view_str($stype, $id, _("View this Work Order")));
  46
  47         display_note(get_gl_view_str($stype, $id, _("View the GL Journal Entries for this Work Order")), 1);
  48
  49         hyperlink_params("work_order_costs.php", _("Enter another additional cost."), "trans_no=$id");
  50
  51         hyperlink_no_params("search_work_orders.php", _("Select another &Work Order to Process"));
  52
  53         end_page();
  54         exit;
  55 }
  56
  57 //--------------------------------------------------------------------------------------------------
  58
  59 $wo_details = get_work_order($_POST['selected_id']);
  60
  61 if (strlen($wo_details[0]) == 0)
  62 {
  63         display_error(_("The order number sent is not valid."));
  64         exit;
  65 }
  66
  67 //--------------------------------------------------------------------------------------------------
  68
  69 function can_process()
  70 {
  71         global $wo_details;
  72
  73         if (!check_num('costs', 0))
  74         {
  75                 display_error(_("The amount entered is not a valid number or less then zero."));
  76                 set_focus('costs');
  77                 return false;
  78         }
  79
  80         if (!is_date($_POST['date_']))
  81         {
  82                 display_error(_("The entered date is invalid."));
  83                 set_focus('date_');
  84                 return false;
  85         }
  86         elseif (!is_date_in_fiscalyear($_POST['date_']))
  87         {
  88                 display_error(_("The entered date is not in fiscal year."));
  89                 set_focus('date_');
  90                 return false;
  91         }
  92         if (date_diff(sql2date($wo_details["released_date"]), $_POST['date_'], "d") > 0)
  93         {
  94                 display_error(_("The additional cost date cannot be before the release date of the work order."));
  95                 set_focus('date_');
  96                 return false;
  97         }
  98
  99         return true;
 100 }
 101
 102 //--------------------------------------------------------------------------------------------------
 103
 104 if (isset($_POST['process']) && can_process() == true)
 105 {
 106         begin_transaction();
 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']);
 110         if ($is_bank_to)
 111         {
 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");
 115         }
 116
 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();
 121
 122         meta_forward($_SERVER['PHP_SELF'], "AddedID=".$_POST['selected_id']);
 123 }
 124
 125 //-------------------------------------------------------------------------------------
 126
 127 display_wo_details($_POST['selected_id']);
 128
 129 //-------------------------------------------------------------------------------------
 130
 131 start_form();
 132
 133 hidden('selected_id', $_POST['selected_id']);
 134 //hidden('WOReqQuantity', $_POST['WOReqQuantity']);
 135
 136 start_table($table_style2);
 137
 138 br();
 139
 140 yesno_list_row(_("Type:"), 'PaymentType', null, $wo_cost_types[WO_OVERHEAD], $wo_cost_types[WO_LABOUR]);
 141
 142 date_row(_("Date:"), 'date_');
 143
 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];
 150
 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);
 154
 155 end_table(1);
 156 hidden('dim1', $item_accounts["dimension_id"]);
 157 hidden('dim2', $item_accounts["dimension2_id"]);
 158
 159 submit_center('process', _("Process Additional Cost"), true, '', true);
 160
 161 end_form();
 162
 163 end_page();
 164
 165 ?>