Merging version 2.1 RC to main trunk.
[fa-stable.git] / purchasing / supplier_credit.php
index 3f7e8ee7b47e289502926d74ad6951a11a93b987..fc16875ce1b1214053447a7cdc30d8ad56c7ac94 100644 (file)
@@ -1,5 +1,14 @@
 <?php
-
+/**********************************************************************
+    Copyright (C) FrontAccounting, LLC.
+       Released under the terms of the GNU General Public License, GPL, 
+       as published by the Free Software Foundation, either version 3 
+       of the License, or (at your option) any later version.
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
 $path_to_root="..";
 
 include_once($path_to_root . "/purchasing/includes/supp_trans_class.inc");
@@ -50,7 +59,8 @@ if (isset($_GET['AddedID']))
        display_note(get_gl_view_str($trans_type, $invoice_no, _("View the GL Journal Entries for this Credit Note")), 1);
 
     hyperlink_params($_SERVER['PHP_SELF'], _("Enter Another Credit Note"), "New=1");
-
+       hyperlink_params("$path_to_root/admin/attachments.php", _("Add an Attachment"), "filterType=$trans_type&trans_no=$invoice_no");
+       
        display_footer_exit();
 }
 
@@ -67,8 +77,69 @@ if (isset($_GET['New']))
 
        $_SESSION['supp_trans'] = new supp_trans;
        $_SESSION['supp_trans']->is_invoice = false;
+       if (isset($_GET['invoice_no']))
+       {
+               $_SESSION['supp_trans']->supp_reference = $_POST['invoice_no'] = $_GET['invoice_no'];
+       }
 }
 
+function clear_fields()
+{
+       global $Ajax;
+       
+       unset($_POST['gl_code']);
+       unset($_POST['dimension_id']);
+       unset($_POST['dimension2_id']);
+       unset($_POST['amount']);
+       unset($_POST['memo_']);
+       unset($_POST['AddGLCodeToTrans']);
+       $Ajax->activate('gl_items');
+       set_focus('gl_code');
+}
+//------------------------------------------------------------------------------------------------
+//     GL postings are often entered in the same form to two accounts
+//  so fileds are cleared only on user demand.
+//
+if (isset($_POST['ClearFields']))
+{
+       clear_fields();
+}
+
+if (isset($_POST['AddGLCodeToTrans'])){
+
+       $Ajax->activate('gl_items');
+       $input_error = false;
+
+       $sql = "SELECT account_code, account_name FROM ".TB_PREF."chart_master WHERE account_code='" . $_POST['gl_code'] . "'";
+       $result = db_query($sql,"get account information");
+       if (db_num_rows($result) == 0)
+       {
+               display_error(_("The account code entered is not a valid code, this line cannot be added to the transaction."));
+               set_focus('gl_code');
+               $input_error = true;
+       }
+       else
+       {
+               $myrow = db_fetch_row($result);
+               $gl_act_name = $myrow[1];
+               if (!check_num('amount'))
+               {
+                       display_error(_("The amount entered is not numeric. This line cannot be added to the transaction."));
+                       set_focus('amount');
+                       $input_error = true;
+               }
+       }
+
+       if ($input_error == false)
+       {
+               $_SESSION['supp_trans']->add_gl_codes_to_trans($_POST['gl_code'], $gl_act_name,
+                       $_POST['dimension_id'], $_POST['dimension2_id'], 
+                       input_num('amount'), $_POST['memo_']);
+               set_focus('gl_code');
+       }
+}
+
+
 //---------------------------------------------------------------------------------------------------
 
 function check_data()
@@ -140,7 +211,10 @@ function handle_commit_credit_note()
        if (!check_data())
                return;
 
-       $invoice_no = add_supp_invoice($_SESSION['supp_trans']);
+       if (isset($_POST['invoice_no']))
+               $invoice_no = add_supp_invoice($_SESSION['supp_trans'], $_POST['invoice_no']);
+       else
+               $invoice_no = add_supp_invoice($_SESSION['supp_trans']);
 
     $_SESSION['supp_trans']->clear_items();
     unset($_SESSION['supp_trans']);
@@ -155,35 +229,127 @@ if (isset($_POST['PostCreditNote']))
        handle_commit_credit_note();
 }
 
+function check_item_data($n)
+{
+       if (!check_num('This_QuantityCredited'.$n, 0))
+       {
+               display_error(_("The quantity to credit must be numeric and greater than zero."));
+               set_focus('This_QuantityCredited'.$n);
+               return false;
+       }
+
+       if (!check_num('ChgPrice'.$n, 0))
+       {
+               display_error(_("The price is either not numeric or negative."));
+               set_focus('ChgPrice'.$n);
+               return false;
+       }
+
+       return true;
+}
+
+function commit_item_data($n)
+{
+       if (check_item_data($n))
+       {
+               $complete = False;
+
+               $_SESSION['supp_trans']->add_grn_to_trans($n,
+               $_POST['po_detail_item'.$n], $_POST['item_code'.$n],
+               $_POST['item_description'.$n], $_POST['qty_recd'.$n],
+               $_POST['prev_quantity_inv'.$n], input_num('This_QuantityCredited'.$n),
+               $_POST['order_price'.$n], input_num('ChgPrice'.$n), $complete,
+               $_POST['std_cost_unit'.$n], "");
+       }
+}
+
+//-----------------------------------------------------------------------------------------
+
+$id = find_submit('grn_item_id');
+if ($id != -1)
+{
+       commit_item_data($id);
+}
+
+if (isset($_POST['InvGRNAll']))
+{
+       foreach($_POST as $postkey=>$postval )
+    {
+               if (strpos($postkey, "qty_recd") === 0)
+               {
+                       $id = substr($postkey, strlen("qty_recd"));
+                       $id = (int)$id;
+                       commit_item_data($id);
+               }
+    }
+}      
+
+
 //--------------------------------------------------------------------------------------------------
+$id3 = find_submit('Delete');
+if ($id3 != -1)
+{
+       $_SESSION['supp_trans']->remove_grn_from_trans($id3);
+       $Ajax->activate('grn_items');
+       $Ajax->activate('inv_tot');
+}
 
-start_form(false, true);
+$id4 = find_submit('Delete2');
+if ($id4 != -1)
+{
+       $_SESSION['supp_trans']->remove_gl_codes_from_trans($id4);
+       clear_fields();
+       $Ajax->activate('gl_items');
+       $Ajax->activate('inv_tot');
+}
+if (isset($_POST['RefreshInquiry']))
+{
+       $Ajax->activate('grn_items');
+       $Ajax->activate('inv_tot');
+}
+
+if (isset($_POST['go']))
+{
+       $Ajax->activate('gl_items');
+       display_quick_entries($_SESSION['supp_trans'], $_POST['qid'], input_num('totamount'), QE_SUPPINV);
+       $_POST['totamount'] = price_format(0); $Ajax->activate('totamount');
+       $Ajax->activate('inv_tot');
+}
 
-start_table("$table_style width=80%", 8);
-echo "<tr><td valign=center>"; // outer table
 
-echo "<center>";
+//--------------------------------------------------------------------------------------------------
+
+start_form(false, true);
 
 invoice_header($_SESSION['supp_trans']);
 if ($_POST['supplier_id']=='') 
        display_error('No supplier found for entered search text');
 else {
-       echo "</td></tr><tr><td valign=center>"; // outer table
-
-       $total_grn_value = display_grn_items($_SESSION['supp_trans']);
+       start_outer_table("$table_style2 width=98%", 5);
 
-       $total_gl_value = display_gl_items($_SESSION['supp_trans']);
+       $total_grn_value = display_grn_items($_SESSION['supp_trans'], 1);
 
-       echo "</td></tr><tr><td align=center colspan=2>"; // outer table
+       $total_gl_value = display_gl_items($_SESSION['supp_trans'], 1);
 
+       div_start('inv_tot');
        invoice_totals($_SESSION['supp_trans']);
+       div_end();
+
+       end_outer_table(0, false);
+}
+
+if ($id != -1)
+{
+       $Ajax->activate('grn_items');
+       $Ajax->activate('inv_tot');
 }
-echo "</td></tr>";
 
-end_table(1); // outer table
+if (get_post('AddGLCodeToTrans'))
+       $Ajax->activate('inv_tot');
 
+br();
 submit_center('PostCreditNote', _("Enter Credit Note"), true, '', true);
-echo "<br><br>";
+br();
 
 end_form();
 end_page();