purchasing/supplier_trans_gl.php

   1 <?php
   2
   3 $page_security=5;
   4 $path_to_root="..";
   5
   6 include($path_to_root . "/purchasing/includes/supp_trans_class.inc");
   7 include($path_to_root . "/includes/session.inc");
   8
   9 include($path_to_root . "/purchasing/includes/purchasing_ui.inc");
  10 $js = "";
  11 if ($use_date_picker)
  12         $js .= get_js_date_picker();
  13 page(_("Add GL Items"), false, false, "", $js);
  14
  15
  16 if (!isset($_SESSION['supp_trans']))
  17 {
  18         display_note(_("To enter a supplier invoice or credit note the supplier must first be selected."));
  19         exit;
  20         /*It all stops here if there aint no supplier selected and transaction initiated ie $_SESSION['supp_trans'] started off*/
  21 }
  22
  23 //------------------------------------------------------------------------------------------------
  24
  25 function clear_fields()
  26 {
  27         unset($_POST['gl_code']);
  28         unset($_POST['dimension_id']);
  29         unset($_POST['dimension2_id']);
  30         unset($_POST['amount']);
  31         unset($_POST['memo_']);
  32         unset($_POST['AcctSelection']);
  33         unset($_POST['AddGLCodeToTrans']);
  34 }
  35
  36 //------------------------------------------------------------------------------------------------
  37
  38 if (isset($_POST['AddGLCodeToTrans'])){
  39
  40         $input_error = false;
  41         if (!isset($_POST['gl_code']))
  42         {
  43                 $_POST['gl_code'] = $_POST['AcctSelection'];
  44         }
  45
  46         $sql = "SELECT account_code, account_name FROM ".TB_PREF."chart_master WHERE account_code='" . $_POST['gl_code'] . "'";
  47         $result = db_query($sql,"get account information");
  48         if (db_num_rows($result) == 0)
  49         {
  50                 display_error(_("The account code entered is not a valid code, this line cannot be added to the transaction."));
  51                 $input_error = true;
  52         }
  53         else
  54         {
  55                 $myrow = db_fetch_row($result);
  56                 $gl_act_name = $myrow[1];
  57                 if (!is_numeric($_POST['amount']))
  58                 {
  59                         display_error(_("The amount entered is not numeric. This line cannot be added to the transaction."));
  60                         $input_error = true;
  61                 }
  62         }
  63
  64         if ($input_error == false)
  65         {
  66                 $_SESSION['supp_trans']->add_gl_codes_to_trans($_POST['gl_code'], $gl_act_name,
  67                         $_POST['dimension_id'], $_POST['dimension2_id'], $_POST['amount'], $_POST['memo_']);
  68                 clear_fields();
  69         }
  70 }
  71
  72 //------------------------------------------------------------------------------------------------
  73
  74 if (isset($_GET['Delete']))
  75 {
  76         $_SESSION['supp_trans']->remove_gl_codes_from_trans($_GET['Delete']);
  77         clear_fields();
  78 }
  79
  80 //------------------------------------------------------------------------------------------------
  81
  82 display_heading($_SESSION['supp_trans']->supplier_name);
  83
  84 display_gl_items($_SESSION['supp_trans'], 1);
  85
  86 echo "<br>";
  87
  88 if ($_SESSION['supp_trans']->is_invoice == true)
  89 {
  90         hyperlink_no_params("$path_to_root/purchasing/supplier_invoice.php", _("Back to Invoice Entry"));
  91 }
  92 else
  93 {
  94         hyperlink_no_params("$path_to_root/purchasing/supplier_credit.php", _("Back to Credit Note Entry"));
  95 }
  96
  97 echo "<hr>";
  98
  99 //------------------------------------------------------------------------------------------------
 100
 101 /*Set up a form to allow input of new GL entries */
 102 start_form(false, true);
 103
 104 display_heading2(_("Enter a GL Line"));
 105
 106 start_table($table_style2);
 107
 108 $accs = get_supplier_accounts($_SESSION['supp_trans']->supplier_id);
 109 $_POST['AcctSelection'] = $accs['purchase_account'];
 110 gl_all_accounts_list_row(_("GL Account Selection:"), 'AcctSelection', $_POST['AcctSelection']);
 111 $dim = get_company_pref('use_dimension');
 112 if ($dim >= 1)
 113         dimensions_list_row(_("Dimension")." 1", 'dimension_id', null, true, " ", false, 1);
 114 if ($dim > 1)
 115         dimensions_list_row(_("Dimension")." 2", 'dimension2_id', null, true, " ", false, 2);
 116 if ($dim < 1)
 117         hidden('dimension_id', 0);
 118 if ($dim < 2)
 119         hidden('dimension2_id', 0);
 120 amount_row( _("Amount:"), 'amount');
 121
 122 textarea_row(_("Memo:"), "memo_",  null, 40, 2);
 123
 124 end_table();;
 125
 126 submit_center('AddGLCodeToTrans', _("Add GL Line"));
 127
 128 end_form();
 129
 130 //------------------------------------------------------------------------------------------------
 131
 132 end_page();
 133 ?>