function getUrnsSortColumn($argSortOrder)
{
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'UrnAddedDate';
} else {
$sortBy = $argSortOrder['sortBy'];
}
$objOrder = new CreateOrder($sortBy, $orderBy);
$objOrder->append('');
if (!isset($_SESSION['sessClientID'])) {
$objOrder->addColumn('Client E-mail', 'ClientLoginID', $_SERVER['PHP_SELF']);
}
$objOrder->addColumn('Urn Name', 'UrnFirstName', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Date Added', 'UrnAddedDate', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Public', 'Public', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Urn Tag Number', 'UrnTagNumber', $_SERVER['PHP_SELF']);
$this->orderOptions = $objOrder->orderOptions();
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
function getSortColumn($argSortOrder)
{
$objCore = new Core();
//Default order by setting
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
//Default sort by setting
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'pkcoupon_id';
} else {
$sortBy = $argSortOrder['sortBy'];
}
//Create sort class object
$objOrder = new CreateOrder($sortBy, $orderBy);
unset($argSortOrder['PHPSESSID']);
//This function return query string. When we will array.
$varQryStr = $objCore->sortQryStr($argSortOrder, $orderBy, $sortBy);
//print_r($varQryStr);
//Pass query string in extra function for add in sorting
$objOrder->extra($varQryStr);
//Prepage sorting heading
$objOrder->append(' ');
$objOrder->addColumn('Code', 'coupon_code');
$objOrder->addColumn('Type', 'coupon_type');
$objOrder->addColumn('Price', 'coupon_price');
$objOrder->addColumn('Date added', 'coupon_date_added');
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
function getNichesSortColumn($argSortOrder)
{
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'NicheAddedDate';
} else {
$sortBy = $argSortOrder['sortBy'];
}
$objOrder = new CreateOrder($sortBy, $orderBy);
$objOrder->append('');
if (!isset($_SESSION['sessClientID'])) {
$objOrder->addColumn('Client E-mail', 'ClientLoginID', $_SERVER['PHP_SELF']);
}
$objOrder->addColumn('Niche Name', 'NicheFirstName', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Date Added', 'NicheAddedDate', $_SERVER['PHP_SELF']);
$objOrder->addColumn('status', 'NicheStatus', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Section Row Column', '', $_SERVER['PHP_SELF']);
$this->orderOptions = $objOrder->orderOptions();
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
function getStaticPageSortColumn($argArr)
{
$varFileName = basename($_SERVER['PHP_SELF']);
//Set sorting here
if ($argArr['orderBy'] == '') {
$varOrderBy = 'DESC';
} else {
$varOrderBy = $argArr['orderBy'];
}
if ($argArr['sortBy'] == '') {
$varSortBy = 'PageDateModified';
} else {
$varSortBy = $argArr['sortBy'];
}
//Set sort with column
$objOrder = new CreateOrder($varSortBy, $varOrderBy);
if ($argArr['page'] != '') {
$objOrder->extra('page=' . $argArr['page']);
}
if ($argArr['PageID'] != '') {
$objOrder->extra('PageID=' . $argArr['PageID']);
}
if ($argArr['PageKeywords'] != '') {
$objOrder->extra('PageKeywords=' . $argArr['PageKeywords']);
}
if ($argArr['PageDescription'] != '') {
$objOrder->extra('PageDescription=' . $argArr['PageDescription']);
}
if ($argArr['PageStatus'] != '') {
$objOrder->extra('PageStatus=' . $argArr['PageStatus']);
}
if ($argArr['frmPageTitle'] != '') {
$objOrder->extra('frmPageTitle=' . $argArr['frmPageTitle']);
}
if ($argArr['PageDateAdded'] != '') {
$objOrder->extra('PageDateAdded=' . $argArr['PageDateAdded']);
}
$objOrder->append('');
$objOrder->addColumn('<strong>Page Title</strong>', 'PageTitle');
$objOrder->addColumn('<strong>Meta Keywords</strong>', 'PageKeywords');
$objOrder->addColumn('<strong>Meta Description</strong>', 'PageDescription');
$objOrder->addColumn('<strong>Date Modified</strong>', 'PageDateModified');
$objOrder->addColumn('<strong>Status</strong>', 'PageStatus');
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varClmnLinkTitle = $objOrder->orderBlock();
return $varClmnLinkTitle;
}
function getCategorySortColumn($argSortOrder)
{
$objCore = new Core();
//SET SORTING HERE
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'CategoryDateAdded';
} else {
$sortBy = $argSortOrder['sortBy'];
}
//CREATE SORT CLASS OBJECT
$objOrder = new CreateOrder($sortBy, $orderBy);
//THIS FUNCTION RETURN QUERY STRING. WHEN WE WILL ARRAY.
$varQryStr = $objCore->sortQryStr($argSortOrder, $orderBy, $sortBy);
//Create sort class object
$objOrder = new CreateOrder($sortBy, $orderBy);
unset($argSortOrder['PHPSESSID']);
unset($argSortOrder['style_cookie']);
unset($argSortOrder['phpbb3_9kmsw_k']);
unset($argSortOrder['phpbb3_9kmsw_sid']);
unset($argSortOrder['phpbb3_9kmsw_u']);
//This function return query string. When we will array.
$varQryStr = $objCore->sortQryStr($argSortOrder, $orderBy, $sortBy);
//Pass query string in extra function for add in sorting
$objOrder->extra($varQryStr);
//Prepage sorting heading
$objOrder->append(' ');
$objOrder->addColumn('Category Name', 'CategoryName');
//$objOrder->addColumn('SEO Page Title','CategorySeoPageTitle');
$objOrder->addColumn('No of Product', 'ProductCount');
$objOrder->addColumn('Date Added', 'CategoryDateAdded');
$objOrder->addColumn('Date Modified', 'CategoryDateModified');
$objOrder->addColumn('Status', 'CategoryStatus');
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
function getUsersSortColumn($argSortOrder)
{
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'ClientAddedDate';
} else {
$sortBy = $argSortOrder['sortBy'];
}
$objOrder = new CreateOrder($sortBy, $orderBy);
$objOrder->append('');
$objOrder->addColumn('Login ID', 'ClientLoginID', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Email', 'ClientEmailAddress', $_SERVER['PHP_SELF']);
$objOrder->addColumn('City', 'ClientCity', $_SERVER['PHP_SELF']);
$objOrder->addColumn('State', 'ClientState', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Date Added', 'ClientAddedDate', $_SERVER['PHP_SELF']);
$objOrder->addColumn('status', 'ClientApprovalStatus', $_SERVER['PHP_SELF']);
$this->orderOptions = $objOrder->orderOptions();
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
function getFeedbackSortColumn($argSortOrder)
{
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'FeedbackDate';
} else {
$sortBy = $argSortOrder['sortBy'];
}
$objOrder = new CreateOrder($sortBy, $orderBy);
$objOrder->append('');
$objOrder->addColumn('Name', 'FeedbackName');
$objOrder->addColumn('Email Id', 'FeedbackEmail');
$objOrder->addColumn('Subject', 'FeedbackSubject');
$objOrder->addColumn('Date', 'FeedbackDate');
$objOrder->addColumn('Status', 'FeedbackStatus');
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
function getNewsletterSortColumn($argSortOrder)
{
//Set sorting here
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'NewsletterDateAdded';
} else {
$sortBy = $argSortOrder['sortBy'];
}
//Set sort with columns
$objOrder = new CreateOrder($sortBy, $orderBy);
if ($argSortOrder['page'] != '') {
$objOrder->extra('&page=' . $argSortOrder['page']);
}
// CREATING SORTING LINK COLUMNS.
$objOrder->append('');
$objOrder->addColumn('Title', 'NewsletterTitle', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Content', 'NewsletterContent', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Posted On', 'NewsletterDateAdded', $_SERVER['PHP_SELF']);
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
function getSubscriberSortColumn($argSortOrder)
{
//Set sorting here
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'SubscriberDateAdded';
} else {
$sortBy = $argSortOrder['sortBy'];
}
//Set sort with columns
$objOrder = new CreateOrder($sortBy, $orderBy);
if ($argSortOrder['page'] != '') {
$objOrder->extra('&page=' . $argSortOrder['page']);
}
if ($argSortOrder['page'] != '') {
$objOrder->extra('&page=' . $argSortOrder['page']);
}
if ($argSortOrder['frmName'] != '') {
$objOrder->extra('&frmName=' . $argSortOrder['frmName']);
}
if ($argSortOrder['frmSubName'] != '') {
$objOrder->extra('&frmSubName=' . $argSortOrder['frmSubName']);
}
if ($argSortOrder['frmSearch'] != '') {
$objOrder->extra('&frmSearch=' . $argSortOrder['frmSearch']);
}
// CREATING SORTING LINK COLUMNS.
$objOrder->append('');
$objOrder->addColumn('E-mail', 'SubscriberEmail', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Date Added', 'SubscriberDateAdded', $_SERVER['PHP_SELF']);
//$objOrder->addColumn('Status', 'SubscriberStatus',$_SERVER['PHP_SELF']);
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
public function actionCurrentprice()
{
$id = Yii::app()->request->getParam('id', 0);
$companyId = Yii::app()->request->getParam('companyId');
$currentPrice = CreateOrder::getProductPrice($companyId, $id, 0);
echo json_encode(array('cp' => $currentPrice));
}
function getCustomerSortColumn($argSortOrder)
{
//Set sorting here
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'CustomerDateAdded';
} else {
$sortBy = $argSortOrder['sortBy'];
}
//Set sort with columns
$objOrder = new CreateOrder($sortBy, $orderBy);
if ($argSortOrder['page'] != '') {
$objOrder->extra('&page=' . $argSortOrder['page']);
}
if ($argSortOrder['frmSearch'] != '') {
$objOrder->extra('&frmSearch=' . $argSortOrder['frmSearch']);
}
if ($argSortOrder['frmName'] != '') {
$objOrder->extra('&frmName=' . $argSortOrder['frmName']);
}
if ($argSortOrder['frmCustomername'] != '') {
$objOrder->extra('&frmCustomername=' . $argSortOrder['frmCustomername']);
}
if ($argSortOrder['frmProductStatus'] != '') {
$objOrder->extra('&frmProductStatus=' . $argSortOrder['frmProductStatus']);
}
if ($argSortOrder['frmOrderStatus'] != '') {
$objOrder->extra('&frmOrderStatus=' . $argSortOrder['frmOrderStatus']);
}
if ($argSortOrder['frmDate'] != '') {
$objOrder->extra('&frmDate=' . $argSortOrder['frmDate']);
}
if ($argSortOrder['frmTodate'] != '') {
$objOrder->extra('&frmTodate=' . $argSortOrder['frmTodate']);
}
if ($argSortOrder['frmSearchPressed'] != '') {
$objOrder->extra('&frmSearchPressed=' . $argSortOrder['frmSearchPressed']);
}
// CREATING SORTING LINK COLUMNS.
$objOrder->append('');
$objOrder->addColumn('Name', 'CustomerFirstName');
$objOrder->addColumn('Last Name', 'CustomerLastName');
$objOrder->addColumn('Email Id', 'CustomerEmailID');
$objOrder->addColumn('Country', 'CustomerCountry');
$objOrder->addColumn('Date Added', 'CustomerDateAdded');
$objOrder->addColumn('Status', 'CustomerStatus');
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
function getTaxDiscountSortColumn($argSortOrder)
{
//Set sorting here
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'TaxDiscountDateAdded';
} else {
$sortBy = $argSortOrder['sortBy'];
}
//Set sort with columns
$objOrder = new CreateOrder($sortBy, $orderBy);
//Set sort with columns
$objOrder = new CreateOrder($sortBy, $orderBy);
if ($argSortOrder['page'] != '') {
$objOrder->extra('&page=' . $argSortOrder['page']);
}
if ($argSortOrder['frmTaxDiscountName'] != '') {
$objOrder->extra('&frmTaxDiscountName=' . $argSortOrder['frmTaxDiscountName']);
}
if ($argSortOrder['frmTaxDiscountType'] != '') {
$objOrder->extra('&frmTaxDiscountType=' . $argSortOrder['frmTaxDiscountType']);
}
if ($argSortOrder['frmDate'] != '') {
$objOrder->extra('&frmDate=' . $argSortOrder['frmDate']);
}
if ($argSortOrder['frmTodate'] != '') {
$objOrder->extra('&frmTodate=' . $argSortOrder['frmTodate']);
}
if ($argSortOrder['frmSearchPressed'] != '') {
$objOrder->extra('&frmSearchPressed=' . $argSortOrder['frmSearchPressed']);
}
if ($argSortOrder['frmSearch'] != '') {
$objOrder->extra('&frmSearch=' . $argSortOrder['frmSearch']);
}
// CREATING SORTING LINK COLUMNS.
$objOrder->append('');
$objOrder->addColumn('Name', 'TaxDiscountName');
$objOrder->addColumn('Type', 'TaxDiscountType');
$objOrder->addColumn('Percentage', 'TaxDiscountValue');
$objOrder->addColumn('Date Added', 'TaxDiscountDateAdded');
//$objOrder->addColumn('Status', 'TaxDiscountStatus');
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
function getOrderSortColumn($argSortOrder)
{
//Set sorting here
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'OrderDateAdded';
} else {
$sortBy = $argSortOrder['sortBy'];
}
//Set sort with columns
$objOrder = new CreateOrder($sortBy, $orderBy);
if ($argSortOrder['page'] != '') {
$objOrder->extra('&page=' . $argSortOrder['page']);
}
if ($argSortOrder['frmOrderID'] != '') {
$objOrder->extra('&frmOrderID=' . $argSortOrder['frmOrderID']);
}
if ($argSortOrder['frmSearchOrderStatus'] != '') {
$objOrder->extra('&frmSearchOrderStatus=' . $argSortOrder['frmSearchOrderStatus']);
}
if ($argSortOrder['frmDate'] != '') {
$objOrder->extra('&frmDate=' . $argSortOrder['frmDate']);
}
if ($argSortOrder['frmTodate'] != '') {
$objOrder->extra('&frmTodate=' . $argSortOrder['frmTodate']);
}
if ($argSortOrder['frmSearch'] != '') {
$objOrder->extra('&frmSearch=' . $argSortOrder['frmSearch']);
}
if ($argSortOrder['customerID'] != '') {
$objOrder->extra('&customerID=' . $argSortOrder['customerID']);
}
// CREATING SORTING LINK COLUMNS.customerID
$objOrder->append('');
$objOrder->addColumn('OrderID', 'OrderUniqueCode', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Amount', 'OrderFinalPrice', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Payment Status', 'OrderPaymentStatus', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Order Status', 'OrderStatus', $_SERVER['PHP_SELF']);
$objOrder->addColumn('Date Added', 'OrderDateAdded', $_SERVER['PHP_SELF']);
//$objOrder->addColumn('Status', 'SubscriberStatus',$_SERVER['PHP_SELF']);
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
public function actionConfirmPadOrder()
{
$goodsIds = isset($_POST) ? $_POST : array();
$padOrder = json_encode(array('status' => false, 'msg' => yii::t('app', '订单为空')));
//Yii::app()->end(json_encode(array('status'=>false,'msg'=>'订单为空wwww')));
if (!empty($goodsIds)) {
try {
$padOrder = CreateOrder::createPadOrder($this->companyId, $goodsIds, $this->padId);
} catch (Exception $e) {
$padOrder = $e->getMessage();
}
}
Yii::app()->end($padOrder);
}
function getSortColumn($argSortOrder)
{
$objCore = new Core();
//Default order by setting
if ($argSortOrder['orderBy'] == '') {
$orderBy = 'DESC';
} else {
$orderBy = $argSortOrder['orderBy'];
}
//Default sort by setting
if ($argSortOrder['sortBy'] == '') {
$sortBy = 'ProductDateAdded';
} else {
$sortBy = $argSortOrder['sortBy'];
}
//Create sort class object
$objOrder = new CreateOrder($sortBy, $orderBy);
unset($argSortOrder['PHPSESSID']);
//This function return query string. When we will array.
$varQryStr = $objCore->sortQryStr($argSortOrder, $orderBy, $sortBy);
//print_r($varQryStr);
//Pass query string in extra function for add in sorting
$objOrder->extra($varQryStr);
//Prepage sorting heading
$objOrder->append(' ');
$objOrder->addColumn('Category Name', 'CategoryName');
$objOrder->addColumn('Product Name', 'ProductName');
$objOrder->addColumn('Product Cost', 'ProductCost');
//RRP recommended retail price
//$objOrder->addColumn('Product Weight','ProductWeight');
$objOrder->addColumn('Product Code', 'ProductCode');
$objOrder->addColumn('Product Status', 'ProductStatus');
$objOrder->addColumn('Product Date Added', 'ProductDateAdded');
$this->orderOptions = $objOrder->orderOptions();
//This string column name with link.
$varStrLnkSrtClmn = $objOrder->orderBlock();
return $varStrLnkSrtClmn;
}
