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 (!check_num('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'],
  68                         input_num('amount'), $_POST['memo_']);
  69                 clear_fields();
  70         }
  71 }
  72
  73 //------------------------------------------------------------------------------------------------
  74
  75 if (isset($_GET['Delete']))
  76 {
  77         $_SESSION['supp_trans']->remove_gl_codes_from_trans($_GET['Delete']);
  78         clear_fields();
  79 }
  80
  81 //------------------------------------------------------------------------------------------------
  82
  83 display_heading($_SESSION['supp_trans']->supplier_name);
  84
  85 display_gl_items($_SESSION['supp_trans'], 1);
  86
  87 echo "<br>";
  88
  89 if ($_SESSION['supp_trans']->is_invoice == true)
  90 {
  91         hyperlink_no_params("$path_to_root/purchasing/supplier_invoice.php", _("Back to Invoice Entry"));
  92 }
  93 else
  94 {
  95         hyperlink_no_params("$path_to_root/purchasing/supplier_credit.php", _("Back to Credit Note Entry"));
  96 }
  97
  98 echo "<hr>";
  99
 100 //------------------------------------------------------------------------------------------------
 101
 102 /*Set up a form to allow input of new GL entries */
 103 start_form(false, true);
 104
 105 display_heading2(_("Enter a GL Line"));
 106
 107 start_table($table_style2);
 108
 109 $accs = get_supplier_accounts($_SESSION['supp_trans']->supplier_id);
 110 $_POST['AcctSelection'] = $accs['purchase_account'];
 111 gl_all_accounts_list_row(_("GL Account Selection:"), 'AcctSelection', $_POST['AcctSelection']);
 112 $dim = get_company_pref('use_dimension');
 113 if ($dim >= 1)
 114         dimensions_list_row(_("Dimension")." 1", 'dimension_id', null, true, " ", false, 1);
 115 if ($dim > 1)
 116         dimensions_list_row(_("Dimension")." 2", 'dimension2_id', null, true, " ", false, 2);
 117 if ($dim < 1)
 118         hidden('dimension_id', 0);
 119 if ($dim < 2)
 120         hidden('dimension2_id', 0);
 121 amount_row( _("Amount:"), 'amount');
 122
 123 textarea_row(_("Memo:"), "memo_",  null, 40, 2);
 124
 125 end_table();;
 126
 127 submit_center('AddGLCodeToTrans', _("Add GL Line"));
 128
 129 end_form();
 130
 131 //------------------------------------------------------------------------------------------------
 132
 133 end_page();
 134 ?>