Menu
▾
▴
[Weberp-cvs] SF.net SVN: web-erp:[3514] trunk
|
From: <tim...@us...> - 2010-06-23 14:38:22
|
Revision: 3514
http://web-erp.svn.sourceforge.net/web-erp/?rev=3514&view=rev
Author: tim_schofield
Date: 2010-06-23 14:38:16 +0000 (Wed, 23 Jun 2010)
Log Message:
-----------
View, accept, or reject any offers made
Modified Paths:
--------------
trunk/SupplierTenders.php
trunk/doc/Change.log.html
trunk/index.php
Added Paths:
-----------
trunk/OffersReceived.php
Added: trunk/OffersReceived.php
===================================================================
--- trunk/OffersReceived.php (rev 0)
+++ trunk/OffersReceived.php 2010-06-23 14:38:16 UTC (rev 3514)
@@ -0,0 +1,254 @@
+<?php
+
+$PageSecurity = 4;
+
+include('includes/session.inc');
+$title = _('Supplier Offers');
+include('includes/header.inc');
+include('includes/SQL_CommonFunctions.inc');
+
+if (isset($_POST['supplierid'])) {
+ $sql='SELECT suppname,
+ email,
+ currcode,
+ paymentterms
+ FROM suppliers
+ WHERE supplierid="'.$_POST['supplierid'].'"';
+ $result = DB_query($sql, $db);
+ $myrow=DB_fetch_array($result);
+ $SupplierName=$myrow['suppname'];
+ $Email=$myrow['email'];
+ $CurrCode=$myrow['currcode'];
+ $PaymentTerms=$myrow['paymentterms'];
+}
+
+if (!isset($_POST['supplierid'])) {
+ $sql='SELECT DISTINCT
+ offers.supplierid,
+ suppliers.suppname
+ FROM offers
+ LEFT JOIN purchorderauth
+ ON offers.currcode=purchorderauth.currabrev
+ LEFT JOIN suppliers
+ ON suppliers.supplierid=offers.supplierid
+ WHERE purchorderauth.userid="'.$_SESSION['UserID'].'"
+ AND offers.expirydate>"'.date('Y-m-d').'"';
+ $result=DB_query($sql, $db);
+ echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' .
+ _('Select Supplier') . '" alt="">' . ' ' . _('Select Supplier') . '</p>';
+ echo "<form method='post' action=" . $_SERVER['PHP_SELF'] . '?' . SID . '>';
+ echo '<table class=selection>';
+ echo '<tr><td>'._('Select Supplier').'</td>';
+ echo '<td><select name=supplierid>';
+ while ($myrow=DB_fetch_array($result)) {
+ echo '<option value="'.$myrow['supplierid'].'">'.$myrow['suppname'].'</option>';
+ }
+ echo '</select></td></tr>';
+ echo '<tr><td colspan=12><div class="centre"><input type=submit name=select value=' . _('Enter Information') . '></div></td></tr>';
+ echo '</table>';
+ echo '</form>';
+}
+
+if (!isset($_POST['submit']) and isset($_POST['supplierid'])) {
+ $sql = 'SELECT offers.offerid,
+ offers.tenderid,
+ offers.supplierid,
+ suppliers.suppname,
+ offers.stockid,
+ stockmaster.description,
+ offers.quantity,
+ offers.uom,
+ offers.price,
+ offers.expirydate,
+ offers.currcode,
+ stockmaster.decimalplaces
+ FROM offers
+ LEFT JOIN purchorderauth
+ ON offers.currcode=purchorderauth.currabrev
+ LEFT JOIN suppliers
+ ON suppliers.supplierid=offers.supplierid
+ LEFT JOIN stockmaster
+ ON stockmaster.stockid=offers.stockid
+ WHERE purchorderauth.userid="'.$_SESSION['UserID'].'"
+ AND offers.expirydate>"'.date('Y-m-d').'"
+ AND offers.supplierid="'.$_POST['supplierid'].'"
+ ORDER BY offerid';
+ $result=DB_query($sql, $db);
+
+ echo "<form method='post' action=" . $_SERVER['PHP_SELF'] . '?' . SID . '>';
+
+ echo '<p class="page_title_text"><img src="'.$rootpath.'/css/'.$theme.'/images/supplier.png" title="' .
+ _('Supplier Offers') . '" alt="">' . ' ' . _('Supplier Offers') . '</p>';
+
+ echo '<table class=selection>';
+ echo '<tr><th>'._('Offer ID').'</th>';
+ echo '<th>'._('Supplier').'</th>';
+ echo '<th>'._('Stock Item').'</th>';
+ echo '<th>'._('Quantity').'</th>';
+ echo '<th>'._('Units').'</th>';
+ echo '<th>'._('Price').'</th>';
+ echo '<th>'._('Total').'</th>';
+ echo '<th>'._('Currency').'</th>';
+ echo '<th>'._('Offer Expires').'</th>';
+ echo '<th>'._('Accept').'</th>';
+ echo '<th>'._('Reject').'</th>';
+ echo '<th>'._('Defer').'</th></tr>';
+ $k=0;
+
+ while ($myrow=DB_fetch_array($result)) {
+ if ($k==1){
+ echo '<tr class="EvenTableRows">';
+ $k=0;
+ } else {
+ echo '<tr class="OddTableRows">';
+ $k++;
+ }
+ echo '<td>'.$myrow['offerid'].'</td>';
+ echo '<td>'.$myrow['suppname'].'</td>';
+ echo '<td>'.$myrow['description'].'</td>';
+ echo '<td class=number>'.number_format($myrow['quantity'],$myrow['decimalplaces']).'</td>';
+ echo '<td>'.$myrow['uom'].'</td>';
+ echo '<td class=number>'.number_format($myrow['price'],2).'</td>';
+ echo '<td class=number>'.number_format($myrow['price']*$myrow['quantity'],2).'</td>';
+ echo '<td>'.$myrow['currcode'].'</td>';
+ echo '<td>'.$myrow['expirydate'].'</td>';
+ echo '<td><input type="radio" name="action'.$myrow['offerid'].'" value="1"></td>';
+ echo '<td><input type="radio" name="action'.$myrow['offerid'].'" value="2"></td>';
+ echo '<td><input type="radio" checked name="action'.$myrow['offerid'].'" value="3"></td>';
+ echo '<td><input type="hidden" name="supplierid" value="'.$myrow['supplierid'].'"></td>';
+ echo '</tr>';
+ }
+ echo '<tr><td colspan=12><div class="centre"><input type=Submit name=submit value=' . _('Enter Information') . '></div></td></tr>';
+ echo '</form></table>';
+} else if(isset($_POST['submit']) and isset($_POST['supplierid'])) {
+ include ('includes/htmlMimeMail.php');
+ $accepts=array();
+ $rejects=array();
+ $defers=array();
+ foreach ($_POST as $key => $value) {
+ if(substr($key,0,6)=='action') {
+ $OfferID=substr($key,6);
+ switch ($value) {
+ case 1:
+ $accepts[]=$OfferID;
+ break;
+ case 2:
+ $rejects[]=$OfferID;
+ break;
+ case 3:
+ $defers[]=$OfferID;
+ break;
+ }
+ }
+ }
+ if (sizeOf($accepts)>0){
+ $MailText=_('This email has been automatically generated by the webERP installation at').' '.
+ $_SESSION['CompanyRecord']['coyname']."\n";
+ $MailText.=_('The following offers you made have been accepted')."\n";
+ $MailText.=_('An official order will be sent to you in due course')."\n\n";
+ $sql='SELECT rate FROM currencies where currabrev="'.$CurrCode.'"';
+ $result=DB_query($sql, $db);
+ $myrow=DB_fetch_array($result);
+ $Rate=$myrow['rate'];
+ $OrderNo = GetNextTransNo(18, $db);
+ $sql='INSERT INTO purchorders (
+ orderno,
+ supplierno,
+ orddate,
+ rate,
+ initiator,
+ intostocklocation,
+ deliverydate,
+ status,
+ stat_comment,
+ paymentterms)
+ VALUES (
+ '.$OrderNo.',
+ "'.$_POST['supplierid'].'",
+ "'.date('Y-m-d').'",
+ '.$Rate.',
+ "'.$_SESSION['UserID'].'",
+ "'.$_SESSION['DefaultFactoryLocation'].'",
+ "'.date('Y-m-d').'",
+ "'._('Pending').'",
+ "'._('Automatically generated from tendering system').'",
+ "'.$PaymentTerms.'")';
+ DB_query($sql, $db);
+ foreach ($accepts as $AcceptID) {
+ $sql='SELECT offers.quantity,
+ offers.price,
+ offers.uom,
+ stockmaster.description,
+ stockmaster.stockid
+ FROM offers
+ LEFT JOIN stockmaster
+ ON offers.stockid=stockmaster.stockid
+ WHERE offerid='.$AcceptID;
+ $result= DB_query($sql, $db);
+ $myrow=DB_fetch_array($result);
+ $MailText.=$myrow['description']."\t"._('Quantity').' '.$myrow['quantity']."\t"._('Price').' '.
+ number_Format($myrow['price'])."\n";
+ $sql='INSERT INTO purchorderdetails (
+ orderno,
+ itemcode,
+ deliverydate,
+ itemdescription,
+ unitprice,
+ actprice,
+ quantityord,
+ itemno,
+ uom)
+ VALUES (
+ '.$OrderNo.',
+ "'.$myrow['stockid'].'",
+ "'.date('Y-m-d').'",
+ "'.$myrow['description'].'",
+ '.$myrow['price'].',
+ '.$myrow['price'].',
+ '.$myrow['quantity'].',
+ "'.$myrow['stockid'].'",
+ "'.$myrow['uom'].'")';
+ $result=DB_query($sql, $db);
+ $sql='DELETE FROM offers WHERE offerid="'.$AcceptID.'"';
+ $result=DB_query($sql, $db);
+ }
+ $mail = new htmlMimeMail();
+ $mail->setSubject(_('Your offer to').' '.$_SESSION['CompanyRecord']['coyname'].' '._('has been accepted'));
+ $mail->setText($MailText);
+ $mail->setFrom($_SESSION['CompanyRecord']['coyname'] . ' <' . $_SESSION['CompanyRecord']['email'] . '>');
+ $result = $mail->send(array($Email), 'smtp');
+ prnMsg(_('The accepted offers from').' '.$SupplierName.' '._('have been converted to purchase orders and an email sent to')
+ .' '.$Email."\n"._('Please review the order contents').' '.'<a href="'.$rootpath .
+ "/PO_Header.php?" . SID . "&ModifyOrderNumber=" . $OrderNo.'">'._('here').'</a>"', 'success');
+ }
+ if (sizeOf($rejects)>0){
+ $MailText=_('This email has been automatically generated by the webERP installation at').' '.
+ $_SESSION['CompanyRecord']['coyname']."\n";
+ $MailText.=_('The following offers you made have been rejected')."\n\n";
+ foreach ($rejects as $RejectID) {
+ $sql='SELECT offers.quantity,
+ offers.price,
+ stockmaster.description
+ FROM offers
+ LEFT JOIN stockmaster
+ ON offers.stockid=stockmaster.stockid
+ WHERE offerid='.$RejectID;
+ $result= DB_query($sql, $db);
+ $myrow=DB_fetch_array($result);
+ $MailText.=$myrow['description']."\t"._('Quantity').' '.$myrow['quantity']."\t"._('Price').' '.
+ number_Format($myrow['price'])."\n";
+ $sql='DELETE FROM offers WHERE offerid="'.$RejectID.'"';
+ $result=DB_query($sql, $db);
+ }
+ $mail = new htmlMimeMail();
+ $mail->setSubject(_('Your offer to').' '.$_SESSION['CompanyRecord']['coyname'].' '._('has been rejected'));
+ $mail->setText($MailText);
+ $mail->setFrom($_SESSION['CompanyRecord']['coyname'] . ' <' . $_SESSION['CompanyRecord']['email'] . '>');
+ $result = $mail->send(array($Email), 'smtp');
+ prnMsg(_('The rejected offers from').' '.$SupplierName.' '._('have been removed from the system and an email sent to')
+ .' '.$Email, 'success');
+ }
+}
+include('includes/footer.inc');
+
+?>
\ No newline at end of file
Modified: trunk/SupplierTenders.php
===================================================================
--- trunk/SupplierTenders.php 2010-06-21 08:19:00 UTC (rev 3513)
+++ trunk/SupplierTenders.php 2010-06-23 14:38:16 UTC (rev 3514)
@@ -142,7 +142,7 @@
}
include ('includes/htmlMimeMail.php');
$mail = new htmlMimeMail();
- $mail->SetSubject(_('Offer received from').' '.$Supplier);
+ $mail->setSubject(_('Offer received from').' '.$Supplier);
$mail->setText(_('This email is automatically generated by webERP')."\n" .
_('You have received the following offer from').' '.$Supplier."\n\n".$MailText);
$mail->setFrom($_SESSION['CompanyRecord']['coyname'] . ' <' . $_SESSION['CompanyRecord']['email'] . '>');
Modified: trunk/doc/Change.log.html
===================================================================
--- trunk/doc/Change.log.html 2010-06-21 08:19:00 UTC (rev 3513)
+++ trunk/doc/Change.log.html 2010-06-23 14:38:16 UTC (rev 3514)
@@ -1,5 +1,6 @@
<p><font SIZE=4 COLOR=BLUE><b>webERP Change Log</b></font></p>
<p></p>
+<p>23/06/10 Tim: View, accept, or reject any offers made.</p>
<p>21/06/10 Pak Ricard: Z_ChangeStockCode.php - updated Z_ChangeStockCode.php as the last one broke due to the recent changes in contractBOM table (just changed the field name).</p>
<p>18/06/10 Tim: AddCustomerNotes.php - Layout improvements</p>
<p>18/06/10 Tim: AddCustomerContacts.php - Layout improvements</p>
Modified: trunk/index.php
===================================================================
--- trunk/index.php 2010-06-21 08:19:00 UTC (rev 3513)
+++ trunk/index.php 2010-06-23 14:38:16 UTC (rev 3514)
@@ -487,6 +487,11 @@
</tr>
<tr>
<td class="menu_group_item">
+ <?php echo '<p>• <a href="' . $rootpath . '/OffersReceived.php?' . sid . '">' . _('Process Tenders and Offers') . '</a></p>'; ?>
+ </td>
+ </tr>
+ <tr>
+ <td class="menu_group_item">
<?php echo '<p>• <a href="' . $rootpath . '/PO_AuthoriseMyOrders.php?' . sid . '">' . _('Orders to Authorise') . '</a></p>'; ?>
</td>
</tr>
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
