 |
|
คือผมจะส่งเมล์ครับผม เมื่อเราทำการจัดการข้อมูลเเล้วจะให้มันส่งไปหาเมล์ของคนที่เราจัดการให้ มันติดตรงที่ว่า มันไม่ส่งครับเเต่จัดการ เรียบร้อยเเต่ มันไม่ส่งเมล์ ช่วย แก้โคตให้หน่อยครับ โคตเมลอยู่บันทัดที่ 140 ครับ โคตโปรเเกรม เป็นเเบบนี้ครับ
<?php
defined( '_JEXEC' ) or die( 'Restricted access' );
require_once( JApplicationHelper::getPath( 'admin_html' ) );
JTable::addIncludePath(JPATH_COMPONENT.DS.'tables');
jimport( 'joomla.utilities.utility' );
switch($task)
{
case 'edit':
case 'add': editreserv( $option); break;
case 'apply' :
case 'save': savereserv( $option, $task ); break;
case 'remove': removereserv( $option ); break;
default: showreserv( $option ); break;
}
function showreserv( $option )
{
global $mainframe;
$db =& JFactory::getDBO();
$search = $mainframe->getUserStateFromRequest( $option.'search', 'search', '', 'string' );
if (strpos($search, '"') !== false) {
$search = str_replace(array('=', '<'), '', $search);
}
$search = JString::strtolower($search);
$where = array();
if ( $search ) {
$where[] = 'FnameTH LIKE '.$db->Quote( '%'.$db->getEscaped( $search, true ).'%', false )
. 'OR'
.' LnameTH LIKE '.$db->Quote( '%'.$db->getEscaped( $search, true ).'%', false )
. 'OR'
.' Location LIKE '.$db->Quote( '%'.$db->getEscaped( $search, true ).'%', false )
. 'OR'
.' StartDate LIKE '.$db->Quote( '%'.$db->getEscaped( $search, true ).'%', false )
. 'OR'
.' EndDate LIKE '.$db->Quote( '%'.$db->getEscaped( $search, true ).'%', false )
. 'OR'
.' StartTime LIKE '.$db->Quote( '%'.$db->getEscaped( $search, true ).'%', false )
. 'OR'
.' EndTime LIKE '.$db->Quote( '%'.$db->getEscaped( $search, true ).'%', false )
. 'OR'
.' StatusName LIKE '.$db->Quote( '%'.$db->getEscaped( $search, true ).'%', false );
}
$where = ( count( $where ) ? ' WHERE ' . implode( ' AND ', $where ) : '' );
// get the total number of records
$query = 'SELECT *'
. ' FROM reserv a left join profile b on a.ProfileID = b.ProfileID left join statusreserv c on a.StatusID = c.StatusID'
. $where
. ' order by a.ReservID DESC'
;
$db->setQuery( $query );
$rows = $db->loadObjectList();
if ($db->getErrorNum())
{
echo $db->stderr();
return false;
}
HTML_reserv::showreserv( $option, $rows );
}
function editreserv( $option)
{
$row =& JTable::getInstance('reserv', 'Table');
$cid = JRequest::getVar( 'cid', array(0), '', 'array' );
$id = $cid[0];
$row->load($id);
$a = $row->ReservID;
$db =& JFactory::getDBO();
$query = "SELECT * FROM reserv a left join profile b on a.ProfileID = b.ProfileID left join province c on a.ProID = c.ProID WHERE ReservID = '$a'";
$db->setQuery( $query );
$user = $db->loadObject();
$query2 = "SELECT * FROM driver a LEFT JOIN reserv b ON a.DriverID = b.DriverID WHERE StatusID = '2' AND ((Date('$user->StartDate')BETWEEN StartDate AND EndDate) AND (Date('$user->EndDate') BETWEEN StartDate AND EndDate)) OR ((StartDate BETWEEN Date('$user->StartDate') AND Date('$user->EndDate')) AND (EndDate BETWEEN Date('$user->StartDate') AND Date('$user->EndDate'))) ";
$db->setQuery( $query2 );
$user2 = $db->loadObject();
$database =& JFactory::getDBO();
//$driver = array();
$driver = array('0' => array('value' => '', 'text' => '-- ยังไม่ทำการเลือก --'));
$database->setQuery( "SELECT DriverID, CONCAT(FnameTH,' ',LnameTH) AS totalname FROM driver WHERE DriverID = '$row->DriverID' OR DriverID != '$user2->DriverID' ");
$driver = array_merge( $driver, $database->loadObjectList() );
$lists['driver'] = JHTML::_('select.genericList', $driver, 'DriverID', 'class="inputbox" '. '', 'DriverID', 'totalname', $row->DriverID );
$query3 = "SELECT a.CarID FROM car a left join brand b on a.BrandID = b.BrandID left join reserv c on a.CarID = c.CarID WHERE StatusID = '2' AND ((Date('$user->StartDate')BETWEEN StartDate AND EndDate) AND (Date('$user->EndDate') BETWEEN StartDate AND EndDate)) OR ((StartDate BETWEEN Date('$user->StartDate') AND Date('$user->EndDate')) AND (EndDate BETWEEN Date('$user->StartDate') AND Date('$user->EndDate'))) ";
$db->setQuery( $query3 );
$user3 = $db->loadObject();
$database2 =& JFactory::getDBO();
//$car = array();
$car = array('0' => array('value' => '', 'text' => '-- ยังไม่ทำการเลือก --'));
$database2->setQuery( "SELECT a.CarID, CONCAT(TypeName,' :: ',BrandName,' :: ',CarName,' :: ',CarNumber) AS totalcar FROM car a left join brand b on a.BrandID = b.BrandID left join type c on a.TypeID = c.TypeID WHERE a.CarID = '$row->CarID' OR a.CarID != '$user3->CarID' GROUP BY a.CarID ");
$car = array_merge( $car, $database2->loadObjectList() );
$lists['car'] = JHTML::_('select.genericList', $car, 'CarID', 'class="inputbox" '. '', 'CarID','totalcar', $row->CarID );
$database3 =& JFactory::getDBO();
$statusreserv = array();
$database3->setQuery( "SELECT StatusID,StatusName FROM statusreserv");
$statusreserv = array_merge( $statusreserv, $database3->loadObjectList() );
$lists['statusreserv'] = JHTML::_('select.genericList', $statusreserv, 'StatusID', 'class="inputbox" '. '', 'StatusID', 'StatusName', $row->StatusID );
HTML_reserv::editreserv($row, $lists, $option, $user);
}
function savereserv($option, $task)
{
global $mainframe;
$row =& JTable::getInstance('reserv', 'Table');
$cid = JRequest::getVar( 'cid', array(0), '', 'array' );
$id = $cid[0];
$row->load($id);
if (!$row->bind(JRequest::get('post')))
{
echo "<script> alert('\".$row->getError().\"');window.history.go(-1); </script>\n";
exit();
}
/*
$row->quicktake = JRequest::getVar( 'quicktake', '', 'post', 'string', JREQUEST_ALLOWRAW );
$row->review = JRequest::getVar( 'review', '', 'post', 'string', JREQUEST_ALLOWRAW );
if(!$row->review_date) $row->review_date = date( 'Y-m-d H:i:s' );
*/
if (!$row->store())
{
echo "<script> alert('\".$row->getError().\"');window.history.go(-1); </script>\n";
exit();
}
// $mailer =& JFactory::getMailer();
$db =& JFactory::getDBO();
$query = "SELECT Email FROM profile WHERE ProfileID = '".$row->ProfileID."' ";
$db->setQuery( $query );
$rows = $db->loadObjectList();
$strTo = $rows->Email;
$strSubject = "ผลการอนุมัติ";
$strHeader = "From: ระบบการขอใช้ยานพาหนะ"; // from ??
$strMessage = "มีการอัพเดทผลการอนุมัติการจองรถของคุณเรียบร้อยแล้ว กรุณาดูได้จากเวปไซด์";
$app =&JFactory::getApplication();
JUtility::sendMail($app->getCfg('mailfrom'), $app->getCfg('fromname'),$strTo,$strHeader,$strMessage, 1,null,null,null,null, null);
/*$mailer->setSender($mainframe->getCfg('mailfrom'), $mainframe->getCfg('fromname'));
$mailer->addRecipient($strTo);
$mailer->setSubject($strHeader);
$mailer->setBody(strMessage);
$mailer->IsHTML(1);
$mailer->Send();*/
// ------------------------ Switch TASK --------------------------
switch ($task)
{
case 'apply':
$msg = 'Changes to reserv saved';
$link = 'index.php?option=' . $option . '&task=edit&cid[]='. $row->ReservID;
break;
case 'save':
default:
$msg = 'reserv Saved';
$link = 'index.php?option=' . $option;
break;
}
$mainframe->redirect( $link, $msg);
}
function removereserv( $option )
{
global $mainframe;
$cid = JRequest::getVar( 'cid', array(), '', 'array' );
$db =& JFactory::getDBO();
if(count($cid))
{
$cids = implode( ',', $cid );
$query = "DELETE FROM reserv WHERE ReservID IN ( $cids )";
$db->setQuery( $query );
if (!$db->query())
{
echo "<script> alert('".$db->getErrorMsg()."');
window.history.go(-1); </script>\n";
}
}
$mainframe->redirect( 'index.php?option=' . $option );
}
?>
Tag : PHP, MySQL, HTML/CSS, Outlook Tools, Reporting Service, WebService
|
|
 |
 |
 |
 |
Date :
2011-03-10 20:47:28 |
By :
sangjan |
View :
1246 |
Reply :
2 |
|
 |
 |
 |
 |
|
|
|
 |