web-erp-svn Mailing List for webERP Accounting & Business Management (Page 6)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Revision: 7835
          http://sourceforge.net/p/web-erp/reponame/7835
Author:   daintree
Date:     2017-09-17 01:39:01 +0000 (Sun, 17 Sep 2017)
Log Message:
-----------
Fix stuff up deleted by mistake

Added Paths:
-----------
    trunk/PcAuthorizeCash.php

Added: trunk/PcAuthorizeCash.php
===================================================================

--- trunk/PcAuthorizeCash.php	                        (rev 0)
+++ trunk/PcAuthorizeCash.php	2017-09-17 01:39:01 UTC (rev 7835)
@@ -0,0 +1,308 @@
+<?php
+include('includes/session.php');
+$Title = _('Authorisation of Assigned Cash');
+/* webERP manual links before header.php */
+$ViewTopic = 'PettyCash';
+$BookMark = 'AuthorizeCash';
+include('includes/header.php');
+include('includes/SQL_CommonFunctions.inc');
+if (isset($_POST['SelectedTabs'])) {
+	$SelectedTabs = mb_strtoupper($_POST['SelectedTabs']);
+} elseif (isset($_GET['SelectedTabs'])) {
+	$SelectedTabs = mb_strtoupper($_GET['SelectedTabs']);
+}
+if (isset($_POST['SelectedIndex'])) {
+	$SelectedIndex = $_POST['SelectedIndex'];
+} elseif (isset($_GET['SelectedIndex'])) {
+	$SelectedIndex = $_GET['SelectedIndex'];
+}
+if (isset($_POST['Days'])) {
+	$Days = filter_number_format($_POST['Days']);
+} elseif (isset($_GET['Days'])) {
+	$Days = filter_number_format($_GET['Days']);
+}
+if (isset($_POST['Process'])) {
+	if ($SelectedTabs == '') {
+		prnMsg(_('You must first select a petty cash tab to authorise'), 'error');
+		unset($SelectedTabs);
+	}
+}
+if (isset($_POST['Go'])) {
+	if ($Days <= 0) {
+		prnMsg(_('The number of days must be a positive number'), 'error');
+		$Days = 30;
+	}
+}
+
+echo '<p class="page_title_text">
+			<img src="', $RootPath, '/css/', $_SESSION['Theme'], '/images/magnifier.png" title="', _('Petty Cash'), '" alt="" />', _('Authorisation of Assigned Cash '), '
+		</p>';
+		
+if (isset($SelectedTabs)) {
+echo '<br /><table class="selection">';
+echo '	<tr>
+			<td>' . _('Petty Cash Tab') . ':</td>
+			<td>' . $SelectedTabs . '</td>
+		</tr>';
+echo '</table>';	
+}
+
+if (isset($_POST['Submit']) or isset($_POST['update']) or isset($SelectedTabs) or isset($_POST['GO'])) {
+	echo '<form method="post" action="', htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8'), '">';
+	echo '<input type="hidden" name="FormID" value="', $_SESSION['FormID'], '" />';
+	if (!isset($Days)) {
+		$Days = 30;
+	}
+	echo '<input type="hidden" name="SelectedTabs" value="', $SelectedTabs, '" />';
+	echo '<table class="selection">
+			<tr>
+				<th colspan="6">', _('Detail of Tab Movements For Last '), ':
+					<input type="text" class="number" name="Days" value="', $Days, '" maxlength="3" size="4" />', _('Days'), '
+					<input type="submit" name="Go" value="', _('Go'), '" />
+				</th>
+			</tr>';
+	$SQL = "SELECT pcashdetails.counterindex,
+				pcashdetails.tabcode,
+				pcashdetails.date,
+				pcashdetails.codeexpense,
+				pcashdetails.amount,
+				pcashdetails.authorized,
+				pcashdetails.posted,
+				pcashdetails.notes,
+				pcashdetails.receipt,
+				pctabs.glaccountassignment,
+				pctabs.glaccountpcash,
+				pctabs.usercode,
+				pctabs.currency,
+				currencies.rate,
+				currencies.decimalplaces
+			FROM pcashdetails, pctabs, currencies
+			WHERE pcashdetails.tabcode = pctabs.tabcode
+				AND pctabs.currency = currencies.currabrev
+				AND pcashdetails.tabcode = '" . $SelectedTabs . "'
+				AND pcashdetails.date >= DATE_SUB(CURDATE(), INTERVAL '" . $Days . "' DAY)
+				AND pcashdetails.codeexpense='ASSIGNCASH'
+			ORDER BY pcashdetails.date, pcashdetails.counterindex ASC";
+	$Result = DB_query($SQL);
+	echo '<tr>
+			<th>', _('Date'), '</th>
+			<th>', _('Expense Code'), '</th>
+			<th>', _('Amount'), '</th>
+			<th>', _('Notes'), '</th>
+			<th>', _('Receipt'), '</th>
+			<th>', _('Date Authorised'), '</th>
+		</tr>';
+	$k = 0; //row colour counter
+	$CurrDecimalPlaces = 2;
+	while ($MyRow = DB_fetch_array($Result)) {
+		$CurrDecimalPlaces = $MyRow['decimalplaces'];
+		//update database if update pressed
+		if (isset($_POST['Submit']) and $_POST['Submit'] == _('Update') and isset($_POST[$MyRow['counterindex']])) {
+			$PeriodNo = GetPeriod(ConvertSQLDate($MyRow['date']), $db);
+			if ($MyRow['rate'] == 1) { // functional currency
+				$Amount = $MyRow['amount'];
+			} else { // other currencies
+				$Amount = $MyRow['amount'] / $MyRow['rate'];
+			}
+			if ($MyRow['codeexpense'] == 'ASSIGNCASH') {
+				$type = 2;
+				$AccountFrom = $MyRow['glaccountassignment'];
+				$AccountTo = $MyRow['glaccountpcash'];
+				$TagTo = 0;
+			} else {
+				$type = 1;
+				$Amount = -$Amount;
+				$AccountFrom = $MyRow['glaccountpcash'];
+				$SQLAccExp = "SELECT glaccount,
+									tag
+								FROM pcexpenses
+								WHERE codeexpense = '" . $MyRow['codeexpense'] . "'";
+				$ResultAccExp = DB_query($SQLAccExp);
+				$MyRowAccExp = DB_fetch_array($ResultAccExp);
+				$AccountTo = $MyRowAccExp['glaccount'];
+				$TagTo = $MyRowAccExp['tag'];
+			}
+			//get typeno
+			$typeno = GetNextTransNo($type,$db);
+			//build narrative
+			$Narrative = _('PettyCash') . ' - ' . $MyRow['tabcode'] . ' - ' . $MyRow['codeexpense'] . ' - ' . DB_escape_string($MyRow['notes']) . ' - ' . $MyRow['receipt'];
+			//insert to gltrans
+			DB_Txn_Begin();
+			$SQLFrom = "INSERT INTO `gltrans` (`counterindex`,
+											`type`,
+											`typeno`,
+											`chequeno`,
+											`trandate`,
+											`periodno`,
+											`account`,
+											`narrative`,
+											`amount`,
+											`posted`,
+											`jobref`,
+											`tag`)
+									VALUES (NULL,
+											'" . $type . "',
+											'" . $typeno . "',
+											0,
+											'" . $MyRow['date'] . "',
+											'" . $PeriodNo . "',
+											'" . $AccountFrom . "',
+											'" . $Narrative . "',
+											'" . -$Amount . "',
+											0,
+											'',
+											'" . $TagTo ."')";
+			$ResultFrom = DB_Query($SQLFrom, '', '', true);
+			$SQLTo = "INSERT INTO `gltrans` (`counterindex`,
+										`type`,
+										`typeno`,
+										`chequeno`,
+										`trandate`,
+										`periodno`,
+										`account`,
+										`narrative`,
+										`amount`,
+										`posted`,
+										`jobref`,
+										`tag`
+									) VALUES (NULL,
+										'" . $type . "',
+										'" . $typeno . "',
+										0,
+										'" . $MyRow['date'] . "',
+										'" . $PeriodNo . "',
+										'" . $AccountTo . "',
+										'" . $Narrative . "',
+										'" . $Amount . "',
+										0,
+										'',
+										'" . $TagTo ."'
+									)";
+			$ResultTo = DB_Query($SQLTo, '', '', true);
+			if ($MyRow['codeexpense'] == 'ASSIGNCASH') {
+				// if it's a cash assignation we need to updated banktrans table as well.
+				$ReceiptTransNo = GetNextTransNo(2, $db);
+				$SQLBank = "INSERT INTO banktrans (transno,
+												type,
+												bankact,
+												ref,
+												exrate,
+												functionalexrate,
+												transdate,
+												banktranstype,
+												amount,
+												currcode											
+											) VALUES (
+												'" . $ReceiptTransNo . "',
+												1,
+												'" . $AccountFrom . "',
+												'" . $Narrative . "',
+												1,
+												'" . $MyRow['rate'] . "',
+												'" . $MyRow['date'] . "',
+												'Cash',
+												'" . -$MyRow['amount'] . "',
+												'" . $MyRow['currency'] . "'
+											)";
+				$ErrMsg = _('Cannot insert a bank transaction because');
+				$DbgMsg = _('Cannot insert a bank transaction with the SQL');
+				$ResultBank = DB_query($SQLBank, $ErrMsg, $DbgMsg, true);
+			}
+			$SQL = "UPDATE pcashdetails
+					SET authorized = CURRENT_DATE,
+					posted = 1
+					WHERE counterindex = '" . $MyRow['counterindex'] . "'";
+			$Resultupdate = DB_query($SQL, '', '', true);
+			DB_Txn_Commit();
+			prnMsg(_('Assigned cash has been correctly authorised'), 'success');
+			unset($_POST['Submit']);
+			unset($SelectedTabs);
+			unset($_POST['SelectedTabs']);
+		}
+		if ($k == 1) {
+			echo '<tr class="EvenTableRows">';
+			$k = 0;
+		} else {
+			echo '<tr class="OddTableRows">';
+			$k = 1;
+		}
+		
+		/*
+		if ($MyRow['posted'] == 0) {
+			$Posted = _('No');
+		} else {
+			$Posted = _('Yes');
+		}
+		*/
+		
+		echo '<td>', ConvertSQLDate($MyRow['date']), '</td>
+			<td>', $MyRow['codeexpense'], '</td>
+			<td class="number">', locale_number_format($MyRow['amount'], $CurrDecimalPlaces), '</td>
+			<td>', $MyRow['notes'], '</td>
+			<td>', $MyRow['receipt'], '</td>';
+		if (isset($_POST[$MyRow['counterindex']])) {
+			echo '<td>' . ConvertSQLDate(Date('Y-m-d'));
+		} else {
+			//compare against raw SQL format date, then convert for display.
+			if (($MyRow['authorized'] != '0000-00-00')) {
+				echo '<td>', ConvertSQLDate($MyRow['authorized']);
+			} else {
+				echo '<td align="right"><input type="checkbox" name="', $MyRow['counterindex'], '" />';
+			}
+		}
+		echo '<input type="hidden" name="SelectedIndex" value="', $MyRow['counterindex'], '" />
+			</td>
+		</tr>';
+	} //end of looping
+	$SQLamount = "SELECT sum(amount)
+			FROM pcashdetails
+			WHERE tabcode='" . $SelectedTabs . "'
+				AND codeexpense='ASSIGNCASH'";
+	$ResultAmount = DB_query($SQLamount);
+	$Amount = DB_fetch_array($ResultAmount);
+	if (!isset($Amount['0'])) {
+		$Amount['0'] = 0;
+	}
+	echo '<tr>
+			<td colspan="2" class="number">', _('Current balance'), ':</td>
+			<td class="number">', locale_number_format($Amount['0'], $CurrDecimalPlaces), '</td>
+		</tr>';
+	// Do the postings
+	include('includes/GLPostings.inc');
+	echo '</table>';
+	echo '<div class="centre">
+			<input type="submit" name="Submit" value="', _('Update'), '" />
+		</div>
+	</form>';
+} else {
+	/*The option to submit was not hit so display form */
+	echo '<form method="post" action="', htmlspecialchars($_SERVER['PHP_SELF'], ENT_QUOTES, 'UTF-8'), '">';
+	echo '<input type="hidden" name="FormID" value="', $_SESSION['FormID'], '" />';
+	$SQL = "SELECT tabcode
+		FROM pctabs
+		WHERE authorizer='" . $_SESSION['UserID'] . "'";
+	$Result = DB_query($SQL);
+	echo '<table class="selection">
+			<tr>
+				<td>', _('Authorise cash assigned to petty cash tab'), ':</td>
+				<td><select required="required" name="SelectedTabs">';
+	while ($MyRow = DB_fetch_array($Result)) {
+		if (isset($_POST['SelectTabs']) and $MyRow['tabcode'] == $_POST['SelectTabs']) {
+			echo '<option selected="selected" value="', $MyRow['tabcode'], '">', $MyRow['tabcode'], '</option>';
+		} else {
+			echo '<option value="', $MyRow['tabcode'], '">', $MyRow['tabcode'], '</option>';
+		}
+	} //end while loop get type of tab
+	echo '</select>
+			</td>
+		</tr>';
+	echo '</table>'; // close main table
+	echo '<div class="centre">
+			<input type="submit" name="Process" value="', _('Accept'), '" />
+			<input type="submit" name="Cancel" value="', _('Cancel'), '" />
+		</div>';
+	echo '</form>';
+}
+/*end of else not submit */
+include('includes/footer.php');
+?>
\ No newline at end of file





2011	Jan (14)	Feb (42)	Mar (56)	Apr (60)	May (54)	Jun (48)	Jul (74)	Aug (52)	Sep (68)	Oct (64)	Nov (42)	Dec (62)
2012	Jan (142)	Feb (270)	Mar (374)	Apr (230)	May (214)	Jun (116)	Jul (234)	Aug (66)	Sep (120)	Oct (16)	Nov (17)	Dec (41)
2013	Jan (19)	Feb (18)	Mar (8)	Apr (40)	May (121)	Jun (42)	Jul (127)	Aug (145)	Sep (27)	Oct (38)	Nov (83)	Dec (61)
2014	Jan (33)	Feb (35)	Mar (59)	Apr (41)	May (38)	Jun (45)	Jul (17)	Aug (58)	Sep (46)	Oct (51)	Nov (55)	Dec (36)
2015	Jan (57)	Feb (67)	Mar (70)	Apr (34)	May (32)	Jun (11)	Jul (3)	Aug (17)	Sep (16)	Oct (13)	Nov (30)	Dec (30)
2016	Jan (17)	Feb (12)	Mar (17)	Apr (20)	May (47)	Jun (15)	Jul (13)	Aug (30)	Sep (32)	Oct (20)	Nov (32)	Dec (24)
2017	Jan (16)	Feb	Mar (11)	Apr (11)	May (5)	Jun (42)	Jul (9)	Aug (10)	Sep (14)	Oct (15)	Nov (2)	Dec (29)
2018	Jan (28)	Feb (49)	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec

web-erp-svn Mailing List for webERP Accounting & Business Management (Page 6)

Accounting & Best Practice Business Administration System

web-erp-svn — SVN commits