From ab79693b43787b7b91a696a56d6287d87cfebdc1 Mon Sep 17 00:00:00 2001
From: Janusz Dobrowolski <janusz@frontaccounting.eu>
Date: Fri, 31 Oct 2008 18:21:38 +0000
Subject: [PATCH] Point of sale support.

---
 sales/includes/db/sales_points_db.inc |  64 +++++++++++++
 sales/manage/sales_points.php         | 131 ++++++++++++++++++++++++++
 2 files changed, 195 insertions(+)
 create mode 100644 sales/includes/db/sales_points_db.inc
 create mode 100644 sales/manage/sales_points.php

diff --git a/sales/includes/db/sales_points_db.inc b/sales/includes/db/sales_points_db.inc
new file mode 100644
index 00000000..6f54fa22
--- /dev/null
+++ b/sales/includes/db/sales_points_db.inc
@@ -0,0 +1,64 @@
+<?php
+
+function add_sales_point($name, $location, $account, $cash, $credit)
+{
+	$sql = "INSERT INTO ".TB_PREF."sales_pos (pos_name, pos_location, pos_account, cash_sale, credit_sale) VALUES (".db_escape($name)
+			. ",".db_escape($location).",".db_escape($account)
+			. ",$cash,$credit)";
+	db_query($sql, "could not add point of sale");
+}
+
+function update_sales_point($id, $name, $location, $account, $cash, $credit)
+{
+
+	$sql = "UPDATE ".TB_PREF."sales_pos SET pos_name=".db_escape($name)
+				.",pos_location=".db_escape($location)
+				.",pos_account=".db_escape($account)
+				.",cash_sale =$cash"
+				.",credit_sale =$credit"
+		 		." WHERE id = $id";
+	
+	db_query($sql, "could not update sales type");			
+}
+
+function get_all_sales_points()
+{
+	$sql = "SELECT pos.*, loc.location_name, acc.bank_account_name FROM "
+		.TB_PREF."sales_pos as pos,"
+		.TB_PREF."locations as loc,"
+		.TB_PREF."bank_accounts as acc"
+		." WHERE pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code";
+	
+	return db_query($sql, "could not get all POS definitions");
+} 
+
+function get_sales_point($id)
+{
+	$sql = "SELECT pos.*, loc.location_name, acc.bank_account_name, acc.account_code FROM "
+		.TB_PREF."sales_pos as pos,"
+		.TB_PREF."locations as loc,"
+		.TB_PREF."bank_accounts as acc"
+		." WHERE id=$id AND pos.pos_location=loc.loc_code AND pos.pos_account=acc.account_code";
+	
+	$result = db_query($sql, "could not get POS definition");
+	
+	return db_fetch($result);
+}
+
+function get_sales_point_name($id)
+{
+	$sql = "SELECT pos_name FROM ".TB_PREF."sales_pos WHERE id=$id";
+	
+	$result = db_query($sql, "could not get POS name");
+	
+	$row = db_fetch_row($result);
+	return $row[0];
+}
+
+function delete_sales_point($id)
+{
+	$sql="DELETE FROM ".TB_PREF."sales_pos WHERE id=$id";
+	db_query($sql,"The point of sale record could not be deleted");
+}
+
+?>
\ No newline at end of file
diff --git a/sales/manage/sales_points.php b/sales/manage/sales_points.php
new file mode 100644
index 00000000..fabb2fea
--- /dev/null
+++ b/sales/manage/sales_points.php
@@ -0,0 +1,131 @@
+<?php
+
+$page_security = 15;
+$path_to_root="../..";
+include_once($path_to_root . "/includes/session.inc");
+
+page(_("Sales Types"));
+
+include_once($path_to_root . "/includes/ui.inc");
+include_once($path_to_root . "/sales/includes/db/sales_points_db.inc");
+
+simple_page_mode(true);
+//----------------------------------------------------------------------------------------------------
+
+function can_process()
+{
+	if (strlen($_POST['name']) == 0)
+	{
+		display_error(_("The POS name cannot be empty."));
+		set_focus('pos_name');
+		return false;
+	}
+	if (!check_value('cash') && !check_value('credit'))
+	{
+		display_error(_("You must allow cash or credit sale."));
+		set_focus('credit');
+		return false;
+	}
+
+	return true;
+}
+
+//----------------------------------------------------------------------------------------------------
+
+if ($Mode=='ADD_ITEM' && can_process())
+{
+	add_sales_point($_POST['name'], $_POST['location'], $_POST['account'],
+		check_value('cash'), check_value('credit'));
+	display_notification(_('New point of sale has been added'));
+	$Mode = 'RESET';
+}
+
+//----------------------------------------------------------------------------------------------------
+
+if ($Mode=='UPDATE_ITEM' && can_process())
+{
+
+	update_sales_point($selected_id, $_POST['name'], $_POST['location'],
+		$_POST['account'], check_value('cash'), check_value('credit'));
+	display_notification(_('Selected point of sale has been updated'));
+	$Mode = 'RESET';
+}
+
+//----------------------------------------------------------------------------------------------------
+
+if ($Mode == 'Delete')
+{
+	delete_sales_point($selected_id);
+	display_notification(_('Selected point of sale has been deleted'));
+	$Mode = 'RESET';
+}
+
+if ($Mode == 'RESET')
+{
+	$selected_id = -1;
+	unset($_POST);
+}
+//----------------------------------------------------------------------------------------------------
+
+$result = get_all_sales_points();
+
+start_form();
+start_table("$table_style");
+
+$th = array (_('POS Name'), _('Credit sale'), _('Cash sale'), _('Location'), _('Default account'), 
+	 '','');
+table_header($th);
+$k = 0;
+
+while ($myrow = db_fetch($result))
+{
+    alt_table_row_color($k);
+	label_cell($myrow["pos_name"], "nowrap");
+	label_cell($myrow['credit_sale'] ? _('Yes') : _('No'));
+	label_cell($myrow['cash_sale'] ? _('Yes') : _('No'));
+	label_cell($myrow["location_name"], "");
+	label_cell($myrow["bank_account_name"], "");
+ 	edit_button_cell("Edit".$myrow['id'], _("Edit"));
+ 	edit_button_cell("Delete".$myrow['id'], _("Delete"));
+	end_row();
+}
+
+end_table();
+end_form();
+echo '<br>';
+//----------------------------------------------------------------------------------------------------
+
+start_form();
+
+start_table("$table_style2 width=30%");
+
+if ($selected_id != -1)
+{
+
+ 	if ($Mode == 'Edit') {
+		$myrow = get_sales_point($selected_id);
+
+		$_POST['name']  = $myrow["pos_name"];
+		$_POST['location']  = $myrow["pos_location"];
+		$_POST['account']  = $myrow["pos_account"];
+		$_POST['credit_sale']  = $myrow["credit_sale"];
+		$_POST['cash_sale']  = $myrow["cash_sale"];
+	}
+	hidden('selected_id', $selected_id);
+} 
+
+text_row_ex(_("Point of Sale Name").':', 'name', 20, 30);
+check_row(_('Allowed credit sale'), 'credit', null);
+check_row(_('Allowed cash sale'), 'cash', null);
+locations_list_row(_("POS location").':', 'location');
+cash_accounts_list_row(_("Default cash account").':', 'account');
+
+end_table(1);
+
+submit_add_or_update_center($selected_id == -1, '', true);
+
+end_form();
+
+end_page();
+
+?>
-- 
2.30.2