Code: Select all
<?php
include_once("../includes/common.php");
$todo = Utility::value_by_key("todo", false);
$page = (trim($_POST['page']) != "" ? $_POST['page'] : (trim($_GET['page']) != "" ? $_GET['page'] : "1"));
/*$objLogin = new Login();
$user_checkin = $objLogin->CheckUserCheckin($_SESSION['userid'],date('Y-m-d'));
if($user_checkin == 0 && $_SESSION['issuperadmin'] != 1)
{
header("location: index.php?checkin=true");
exit();
}
$allowed_perm = Utility::UserHasPermission($_SESSION['roleid'],18);*/
$tpl->assign(array("allowed_perm" => $allowed_perm,
"module_name" => 'New Passport',
"func_name" => 'loadNewPassportInquiryAJAX',
"js_filepath" => $config['js'].'pages/admin/newpassport_inquiry.js',
));
switch($todo)
{
case "loadNewPassportInquiryAJAX":
viewAllNewPassportInquiryAJAX();
break;
case "Add":
case "Edit":
addEditNewPassportInquiry();
break;
case "View":
ViewNewPassportInquiry();
break;
case "Save":
saveNewPassportInquiry();
break;
case "deleteNewPassportInquiry":
deleteNewPassportInquiry();
break;
case "StatusChange":
StatusChange();
break;
case "SaveStatus":
SaveStatus();
break;
default:
viewNewPassportInquiry();
break;
}
function viewNewPassportInquiry()
{
global $tpl,$config,$page;
$tpl->assign('arr_perpage', $config['arr_perpage']);
$tpl->display('admin/common_view.tpl');
}
function viewAllNewPassportInquiryAJAX()
{
global $tpl,$config,$page;
$objNewPassport = new NewPassport();
$pagination = false;
$status = Utility::value_by_key('status_val',0,'POST');
$searchRefrence = Utility::value_by_key('searchRefrence','','POST');
$searchClientName = Utility::value_by_key('searchClientName','','POST');
$_SESSION['records_total'] = 0;
$_SESSION['records_perpage'] = (isset($_SESSION['records_perpage']) ? $_SESSION['records_perpage'] : $config['default_perpage_admin']);
$tpl->assign(array( "Data_List" => $objNewPassport->listAllNewPassportInquiry($status,$searchRefrence,$searchClientName),
"searchRefrence" => $searchRefrence,
"searchClientName" => $searchClientName,
));
if($_SESSION['records_total'] > $_SESSION['records_perpage'])
{
//show pagination
$pagination = true;
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($_SESSION['records_total'] / $_SESSION['records_perpage']);
$lpm1 = $lastpage - 1;
$tpl->assign(array(
'pagination' => $pagination,
'prev' => $prev,
'next' => $next,
'lastpage' => $lastpage,
'page' => $page,
));
}
$result = $tpl->fetch('admin/ajax/newpassport_listing.tpl');
echo $result;
}
function saveNewPassportInquiry()
{
global $config,$tpl;
$objNewPassport = new NewPassport();
$postdata = Utility::filterData($_POST);
$npid = Utility::value_by_key('id',0);
if( $npid > 0)
{
$ret = $objNewPassport->updateNewPassportInquiry($postdata);
Utility::ActivityLog("NewPassport Inquiry Edited", "NewPassport Inquiry");
}
else
{
$ret = $objNewPassport->insertNewPassportInquiry($postdata);
Utility::ActivityLog("NewPassport Inquiry Added", "NewPassport Inquiry");
$objMail = new Mail();
$FromEmail = '';
$ToEmail = $postdata['emailid'];
$Subject = 'YOUR INQUIRY HAS BEEN ADDED FOR NP'.str_pad($ret, 5, "0", STR_PAD_LEFT).' ';
$tpl->assign(array(
"postdata" => $postdata,
"loggedin_username" => $_SESSION['userName'],
"module_name" => 'NewPassport Inquiry NP'.str_pad($ret, 5, "0", STR_PAD_LEFT).' ',
));
$result = $tpl->fetch('email_template/admin/newpassport.tpl');
$objMail->Send($FromEmail, $ToEmail, $ToName, $Subject, $result);
if($postdata['mobilenumber'] != '')
{
$Utility = new Utility();
$main_url = "http://alerts.valueleaf.com/api/web2sms.php";
$param['workingkey'] = '98581u399h81z9g7h70';
$param['sender'] = 'URTRIP';
$param['to'] = $postdata['mobilenumber'];
$param['message'] = "Thanks for doing service inquiry with Shree Vishal Travels. Your Future Reference ID is : NP".str_pad($ret, 5, "0", STR_PAD_LEFT).". Tel No. : +91-2637-244748";
$test = $Utility->send_sms($main_url, $param);
}
}
if($ret)
{
echo '<script language="javascript">parent.location.href= "new_passport.php";parent.$.fancybox.close();</script>';
die;
}
else
{
$ERROR .= "Sorry something went wrong, please re-try";
}
}
function addEditNewPassportInquiry()
{
global $tpl;
$objNewPassport = new NewPassport();
$objReport = new Report();
$npid = Utility::value_by_key('id',0);
if(npid > 0)
{
$ret = $objNewPassport->getNewPassportInquiryDetail($npid);
$postdata['npid'] = $ret['npid'];
$postdata['contactname'] = $ret['contactname'];
$postdata['referrence'] = $ret['referrence'];
$postdata['contactway'] = $ret['contactway'];
$postdata['contactwayother'] = $ret['contactwayother'];
$postdata['inquiryfor'] = $ret['inquiryfor'];
$postdata['mobilenumber'] = $ret['mobilenumber'];
$postdata['landlinenumber'] = $ret['landlinenumber'];
$postdata['emailid'] = $ret['emailid'];
$postdata['address'] = $ret['address'];
$postdata['inquirydescription'] = $ret['inquirydescription'];
$postdata['assigneduser'] = $ret['assigneduser'];
}
else
{
}
$tpl->assign(array( "frm_action" => 'new_passport.php?id='.$npid,
"postdata" => $postdata,
"npid" => $npid,
"assigneduser" => $_SESSION['userid'],
"user_name" => Utility::getUserNamebyID($_SESSION['userid']),
));
$tpl->display('admin/newpassport_add_edit.tpl');
}
function ViewNewPassportInquiry()
{
global $tpl;
$objNewPassport = new NewPassport();
$objReport = new Report();
$npid = Utility::value_by_key('id',0);
$ret = $objNewPassport->getNewPassportInquiryDetail($npid);
$postdata['npid'] = $ret['npid'];
$postdata['contactname'] = $ret['contactname'];
$postdata['referrence'] = $ret['referrence'];
$postdata['contactway'] = $ret['contactway'];
$postdata['contactwayother'] = $ret['contactwayother'];
$postdata['inquiryfor'] = $ret['inquiryfor'];
$postdata['mobilenumber'] = $ret['mobilenumber'];
$postdata['landlinenumber'] = $ret['landlinenumber'];
$postdata['emailid'] = $ret['emailid'];
$postdata['address'] = $ret['address'];
$postdata['inquirydescription'] = $ret['inquirydescription'];
$postdata['assigneduser'] = Utility::getUserNamebyID($ret['assigneduser']);
$tpl->assign(array( "frm_action" => 'new_passport.php?id='.$npid,
"postdata" => $postdata,
"npid" => $npid,
"module_name" => 'NewPassport Inquiry [ NP'.str_pad($npid, 5, "0", STR_PAD_LEFT).' ]',
));
$tpl->display('admin/newpassport_view.tpl');
}
function deleteNewPassportInquiry()
{
$objNewPassport = new NewPassport();
$arr = array();
$npid = Utility::cleanstring($_POST['npid']);
if($objNewPassport->deleteNewPassportInquiry($npid))
{
$result = array("result" => "Success","message" => "Data deleted successfully");
}
else
{
$result = array("result" => "Fail","message" => "Sorry, Could not delete comment");
}
Utility::ActivityLog("NewPassport Inquiry Deleted", "NewPassport Inquiry");
echo json_encode($result);
}
function StatusChange()
{
global $tpl;
$objNewPassport = new NewPassport();
$npid = Utility::value_by_key('id',0);
if($npid > 0)
{
$ret = $objNewPassport->getNewPassportInquiryDetail($npid);
$postdata['npid'] = $ret['npid'];
$postdata['status'] = $ret['status'];
}
else
{
}
$tpl->assign(array( "frm_action" => 'new_passport.php?id='.$npid,
"postdata" => $postdata,
"npid" => $npid,
));
$tpl->display('admin/newpassport_statuschange.tpl');
}
function SaveStatus()
{
global $config;
$objNewPassport = new NewPassport();
$postdata = Utility::filterData($_POST);
$npid = Utility::value_by_key('id',0);
$ret = $objNewPassport->updateNewPassportStatus($postdata);
Utility::ActivityLog("NewPassport Status Updated", "NewPassport Inquiry");
if($ret)
{
echo '<script language="javascript">parent.location.href= "new_passport.php";parent.$.fancybox.close();</script>';
die;
}
else
{
$ERROR .= "Sorry something went wrong, please re-try";
}
}
?>