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 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 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; }
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 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; }
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; }
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 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 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; }