/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { //$model=Niches::model()->findByPk($id); $model = Niches::model()->find('LOWER(name) = :slug', array(':slug' => strtolower($id))); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'common/config/array.inc.php'; require_once SOURCE_ROOT . 'classes/class.urns.php'; require_once SOURCE_ROOT . 'classes/class.clients_login.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once SOURCE_ROOT . 'classes/class.extra.php'; $objClientLogin = new ClientsLogin(); $objClientLogin->isValidClients(); $objExtra = new Extra(); $objUrns = new Urns(); $varExtraWhr = "1 AND fkClientID =" . $_SESSION['sessClientID']; $arrClmn = array('pkExtraID', 'ClientExtra1', 'ClientExtra2', 'NicheExtra1', 'NicheExtra2', 'UrnsExtra1', 'UrnsExtra2'); $extra = $objExtra->getExtraListing(TABLE_EXTRA_SETTINGS, $arrClmn, '', $varExtraWhr); $varClientID = $_SESSION['sessClientID']; $objNiches = new Niches(); $arrNichesFlds = array('NicheTitle', 'pkNicheID', 'NicheStatus'); $fkClientID = $_SESSION['sessClientID']; $arrNichesFlds = array('niches.pkNicheID', 'niches.NicheStatus', 'NicheLastName', 'Section', 'row', 'columns'); $varWhere = ' niches.fkClientID = ' . $fkClientID; $table = 'niches JOIN niche_locations ON niches.pkNicheID = niche_locations.fkNicheID'; $arrNichesRecord = $objNiches->getNichesListing($table, $arrNichesFlds, '', $varWhere); $objUrns = new Urns(); $objSessionRedirectUrl = new SessionRedirectUrl(); $arrUrnsFlds = array(); if ($_SESSION['sessUrnsDetail'] != '') { @extract($_SESSION['sessUrnsDetail']); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">
<?php require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'common/config/array.inc.php'; require_once SOURCE_ROOT . 'classes/class.urns.php'; require_once SOURCE_ROOT . 'classes/class.clients_login.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; $objClientLogin = new ClientsLogin(); $objClientLogin->isValidClients(); $objUrns = new Urns(); $objNiches = new Niches(); $objSessionRedirectUrl = new SessionRedirectUrl(); $arrUrnsFlds = array(); $arrUrnsRecds = array('pkNicheID', 'NicheTitle', 'NicheFirstName', 'NicheLastName'); if (isset($_GET['n_id'])) { $varWhere = ' pkUrnID = \'' . $_GET['n_id'] . '\''; $arrUrnsRecord = $objUrns->getUrnsListing(TABLE_URNS, $arrUrnsFlds, '', $varWhere); $table = "niches JOIN urns ON niches.pkNicheID=urns.fkNicheID"; $arrUrnsList = $objUrns->getUrnsListing($table, $arrUrnsRecds, '', $varWhere); $clientID = $_SESSION['sessClientID']; //print_r($arrUrnsList[0]);die; $arrNichesFlds = array('Section', 'row', 'columns'); $varWhere = ' fkNicheID = \'' . $arrUrnsList[0]['pkNicheID'] . '\''; $arrNichesRecord = $objNiches->getNichesLocationListing(TABLE_NICHE_LOCATIONS, $arrNichesFlds, '', $varWhere); //var_dump($_SESSION['sessClientLoginID']);die; //var_dump($arrNichesRecord[0]["Section"]);die; } //var_dump($arrUrnsList[0]['NicheTitle']);die; @extract($arrUrnsRecord[0]); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once SOURCE_ROOT . 'classes/class.paging.php'; require_once SOURCE_ROOT . 'classes/class.sort.php'; require_once SOURCE_ROOT . 'classes/class.client.php'; require_once SOURCE_ROOT . 'classes/class.clients_login.php'; require_once SOURCE_ROOT . '/classes/excelwriter.php'; $objClientLogin = new ClientsLogin(); $objClientLogin->isValidClients(); $objSessionRedirectUrl = new SessionRedirectUrl(); $objNiches = new Niches(); $objPaging = new Paging(); $varClientID = $_SESSION['sessClientID']; $varWhere = "1 AND fkClientID=" . $varClientID; $varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessClientPagingLimit']); $varLimit = $varPageStart . ',' . $_SESSION['sessClientPagingLimit']; $arrNichesFlds = array('pkNicheID', 'NicheTitle', 'NicheFirstName', 'NicheCity', 'NicheEmailAddress', 'NicheDatePurchase', 'NicheStatus'); $arrNichesRecord = $objGeneral->getRecord(TABLE_NICHES, $arrNichesFlds, $varWhere); $arrNichesLocFlds = array('fkNicheID'); $arrNichesLocRecord = $objGeneral->getRecord(TABLE_NICHE_LOCATIONS, $arrNichesLocFlds, ''); $NumberofRows = count($arrNichesRecord); $varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessClientPagingLimit']); $arrNichesList = $objNiches->getNichesList(TABLE_NICHES, $arrNichesFlds, $varLimit, $varWhere); $excel = new ExcelWriter("niches_list.xls"); if ($excel == false) { echo $excel->error; } $main_array = array('<b>Niche ID</b>', '<b>Niche Title</b>', '<b>First Name</b>', '<b>City</b>', '<b>Email Address</b>', '<b>Date Purchase</b>', '<b>Status</b>'); $columnTitles = array_values($main_array);
/** * Populate the array of site links * @param array[] &$list The array which holds the array of link information: loc, frequency, priority */ public function populateSitemap(&$list) { $offers = Offers::model()->published()->currentSite()->findAll(); $niches = Niches::model()->published()->currentSite()->findAll(); // Add primary items here $list[] = array('loc' => $this->createAbsoluteUrl('/'), 'frequency' => 'weekly', 'priority' => '1'); $list[] = array('loc' => $this->createAbsoluteUrl('/registration'), 'frequency' => 'yearly', 'priority' => '0.5'); $list[] = array('loc' => $this->createAbsoluteUrl('/login'), 'frequency' => 'monthly', 'priority' => '0.5'); $list[] = array('loc' => $this->createAbsoluteUrl('/past'), 'frequency' => 'monthly', 'priority' => '0.5'); $list[] = array('loc' => $this->createAbsoluteUrl('/privacy.html'), 'frequency' => 'yearly', 'priority' => '0.5'); $list[] = array('loc' => $this->createAbsoluteUrl('/offers/index'), 'frequency' => 'weekly', 'priority' => '1'); foreach ($niches as $row) { $list[] = array('loc' => $this->createAbsoluteUrl('/niches/view', array('slug' => $row->name)), 'frequency' => 'weekly', 'priority' => '1'); } foreach ($offers as $row) { $list[] = array('loc' => $this->createAbsoluteUrl('/offers/view', array('slug' => $row->slug)), 'frequency' => 'weekly', 'priority' => '1'); } }
<?php require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once SOURCE_ROOT . 'classes/class.paging.php'; require_once SOURCE_ROOT . 'classes/class.sort.php'; require_once SOURCE_ROOT . 'classes/class.client.php'; require_once SOURCE_ROOT . 'classes/class.adminlogin.php'; $objAdminLogin = new AdminLogin(); $objAdminLogin->isValidAdmin(); $objSessionRedirectUrl = new SessionRedirectUrl(); $objNiches = new Niches(); $objClients = new Clients(); $objPaging = new Paging(); $varPage = $_GET['page']; if ($varPage == '') { $varPage = 0; } $varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']); $varLimit = $varPageStart . ',' . $_SESSION['sessAdminPagingLimit']; $arrNichesFlds = array('clients.ClientLoginID', 'pkNicheID', 'fkClientID', 'NicheTitle', 'NicheFirstName', 'NicheMiddleName', 'NicheMaidenName', 'NicheLastName', 'NicheStreetAddress', 'NicheCity', 'NicheState', 'NicheZipCode', 'NichePhoneNumber', 'NicheEmailAddress', 'NicheDatePurchase', 'NicheExtra1', 'NicheExtra2', 'NicheAddedDate', 'NicheModifiedDate', 'NicheStatus'); /*$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']); $varLimit = $varPageStart.','.$_SESSION['sessAdminPagingLimit'];*/ $arrNichesRecord = $objGeneral->getRecord("niches JOIN clients ON niches.fkClientID = clients.pkClientID", $arrNichesFlds, ''); $NumberofRows = count($arrNichesRecord); $varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessAdminPagingLimit']); $arrNichesList = $objNiches->getNichesList("niches JOIN clients ON niches.fkClientID = clients.pkClientID", $arrNichesFlds, $varLimit, ''); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>
<?php require_once '../common/config/array.inc.php'; require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.urns.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once '../classes/class.adminlogin.php'; require_once SOURCE_ROOT . 'classes/class.extra.php'; $objAdminLogin = new AdminLogin(); $objAdminLogin->isValidAdmin(); $objExtra = new Extra(); $arrClmn = array('UrnsExtra1', 'UrnsExtra2'); $extra = $objExtra->getExtraListing(TABLE_EXTRA_SETTINGS, $arrClmn, ''); $objNiches = new Niches(); $objUrns = new Urns(); $arrNichesFlds = array('niches.pkNicheID', 'niches.NicheStatus', 'NicheLastName', 'Section', 'row', 'columns'); $objSessionRedirectUrl = new SessionRedirectUrl(); if (isset($_GET['n_id'])) { $varWhere = ' niches.fkClientID = \'' . $_GET['n_id'] . '\''; $table = 'niches JOIN niche_locations ON niches.pkNicheID = niche_locations.fkNicheID'; $arrNichesRecord = $objNiches->getNichesListing($table, $arrNichesFlds, '', $varWhere); } $arrNichesFld = array('pkNicheID'); $varWhere = ' pkNicheID = \'' . $arrNiches['pkNicheID'] . '\''; $arrNumRecord = $objNiches->getNichesListing(TABLE_NICHES, $arrNichesFld, '', $varWhere); //var_dump ($arrNichesRecord);die; /*$tag=substr(uniqid(),3); $tag.= rand(10,99);*/ $objSessionRedirectUrl = new SessionRedirectUrl(); $arrUrnsFlds = array(); $fkClientID = $_GET['n_id'];
<?php require_once 'common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once SOURCE_ROOT . 'classes/class.client.php'; $objNiches = new Niches(); $objClients = new Clients(); $arrClientFlds = array(); if (isset($_POST)) { $arrNichesRecord = $objNiches->getNiches($_POST); } if ($arrNichesRecord == NULL) { $_SESSION['window2'] = "{$objCore->setErrorMsg}('<b>This niche is not found in the registry.</b>')"; $objCore->setErrorMsg('<b>This niche is not found in the registry.</b>'); $objCore->standardRedirect('index.php'); } $fkClientID = $arrNichesRecord[0]['fkClientID']; $varClientWhere = ' pkClientID = ' . $fkClientID; $arrClientRecord = $objClients->getUsersListing(TABLE_CLIENTS, $arrClientFlds, '', $varClientWhere); @extract($arrNichesRecord[0]); @extract($arrClientRecord[0]); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
public function getNiches($site_id) { $criteria = new CDbCriteria(); $criteria->condition = 'site_id = :site_id'; $criteria->params = array(':site_id' => $site_id); $criteria->order = 'name'; $niches = CHtml::listData(Niches::model()->findAll($criteria), 'id', 'name'); return $niches; }
<?php require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once SOURCE_ROOT . 'classes/validator.php'; require_once SOURCE_ROOT . 'classes/class.clients_login.php'; $objClientLogin = new ClientsLogin(); $objClientLogin->isValidClients(); $objNiches = new Niches(); if ($_POST['sbmt_niches']) { $varAffectedID = $objNiches->saveNiches($_POST); if ($varAffectedID) { $objCore->standardRedirect('niches_list.php'); } else { $objCore->standardRedirect($_SESSION['sessRedirectURL']); } } if ($_POST['frmChangeAction1'] != '' || $_POST['frmChangeAction2'] != '') { if ($_POST['frmChangeAction1'] == 'Delete' || $_POST['frmChangeAction2'] == 'Delete') { $_SESSION['sessUpdateList'] = $_POST; header('Location:niche_confirm_action.php'); exit; } $varReturnID = $objNiches->updateNichesList($_POST); if ($varReturnID == 1) { $objCore->standardRedirect('niches_list.php'); die; } else { if ($varReturnID == 2 || $varReturnID == 3) { $objCore->standardRedirect($_SESSION['sessRedirectURL']); die;
<?php require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once SOURCE_ROOT . 'classes/validator.php'; $objNiches = new Niches(); if ($_POST['sbmt_niches']) { $varAffectedID = $objNiches->saveNiches($_POST); if ($varAffectedID) { $objCore->standardRedirect('niches_list.php'); } else { $objCore->standardRedirect($_SESSION['sessRedirectURL']); } } if ($_POST['frmChangeAction1'] != '' || $_POST['frmChangeAction2'] != '') { $varReturnID = $objNiches->updateNichesList($_POST); if ($varReturnID == 1) { $objCore->standardRedirect('niches_list.php'); die; } else { if ($varReturnID == 2 || $varReturnID == 3) { $objCore->standardRedirect($_SESSION['sessRedirectURL']); die; } } } if ($_POST['sbmt_niches_locations'] != '') { $varReturnID = $objNiches->saveNichesLocation($_POST); if ($varReturnID) { $objCore->standardRedirect('niches_list.php'); } else {
<?php require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once SOURCE_ROOT . 'classes/class.paging.php'; require_once SOURCE_ROOT . 'classes/class.sort.php'; require_once SOURCE_ROOT . 'classes/class.client.php'; require_once SOURCE_ROOT . 'classes/class.adminlogin.php'; require_once SOURCE_ROOT . '/classes/excelwriter.php'; $objAdminLogin = new AdminLogin(); $objAdminLogin->isValidAdmin(); $objSessionRedirectUrl = new SessionRedirectUrl(); $objNiches = new Niches(); $objClients = new Clients(); $objPaging = new Paging(); //$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']); //$varLimit = $varPageStart.','.$_SESSION['sessAdminPagingLimit']; $arrNichesFlds = array('clients.ClientLoginID', 'pkNicheID', 'NicheTitle', 'NicheFirstName', 'NicheMiddleName', 'NicheMaidenName', 'NicheLastName', 'NicheStreetAddress', 'NicheCity', 'NicheState', 'NicheZipCode', 'NichePhoneNumber', 'NicheEmailAddress', 'NicheDatePurchase', 'NicheExtra1', 'NicheExtra2', 'NicheAddedDate', 'NicheModifiedDate', 'NicheStatus'); //$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']); //$varLimit = $varPageStart.','.$_SESSION['sessAdminPagingLimit']; $arrNichesRecord = $objGeneral->getRecord("niches JOIN clients ON niches.fkClientID = clients.pkClientID", $arrNichesFlds, ''); ///$NumberofRows = count($arrNichesRecord); ///$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessAdminPagingLimit']); $arrNichesList = $objNiches->getNichesList("niches JOIN clients ON niches.fkClientID = clients.pkClientID", $arrNichesFlds, $varLimit, ''); $excel = new ExcelWriter("niches_list.xls"); if ($excel == false) { echo $excel->error; } $main_array = array('<b>Client LoginID</b>', '<b>Niche ID</b>', '<b>Niche Title</b>', '<b>First Name</b>', '<b>Middle Name</b>', '<b>Maiden Name</b>', '<b>Last Name</b>', '<b>Street Address</b>', '<b>City</b>', '<b>State</b>', '<b>Zip Code</b>', '<b>Phone Number Type</b>', '<b>Email Address</b>', '<b>Date Purchase</b>', '<b>Extra 1</b>', '<b>Extra 2</b>', '<b>Added Date</b>', '<b>Modified Date</b>', '<b>Status</b>'); $columnTitles = array_values($main_array); $numColumns = count($columnTitles);
<?php require_once '../common/config/config.inc.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once SOURCE_ROOT . 'classes/class.paging.php'; require_once SOURCE_ROOT . 'classes/class.sort.php'; require_once SOURCE_ROOT . 'common/config/messages.php'; require_once SOURCE_ROOT . 'classes/class.clients_login.php'; $objClientLogin = new ClientsLogin(); $objClientLogin->isValidClients(); $objSessionRedirectUrl = new SessionRedirectUrl(); $objNiches = new Niches(); $varPage = $_GET['page']; if ($varPage == '') { $varPage = 0; } $objPaging = new Paging(); $varClientID = $_SESSION['sessClientID']; $varWhere = "1 AND fkClientID=" . $varClientID; $varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessClientPagingLimit']); $varLimit = $varPageStart . ',' . $_SESSION['sessClientPagingLimit']; $arrNichesFlds = array('pkNicheID', 'fkClientID', 'NicheTitle', 'NicheFirstName', 'NicheLastName', 'NicheCity', 'NicheEmailAddress', 'NicheDatePurchase', 'NicheStatus'); $arrNichesRecord = $objGeneral->getRecord(TABLE_NICHES, $arrNichesFlds, $varWhere); $arrNichesLocFlds = array('fkNicheID'); $arrNichesLocRecord = $objGeneral->getRecord(TABLE_NICHE_LOCATIONS, $arrNichesLocFlds, ''); $NumberofRows = count($arrNichesRecord); $varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessClientPagingLimit']); $arrNichesList = $objNiches->getNichesList(TABLE_NICHES, $arrNichesFlds, $varLimit, $varWhere); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">
<?php require_once '../common/config/config.inc.php'; require_once '../classes/class.clients_login.php'; require_once SOURCE_ROOT . 'classes/class.urns.php'; require_once SOURCE_ROOT . 'classes/class.niches.php'; require_once SOURCE_ROOT . 'classes/class.paging.php'; require_once SOURCE_ROOT . 'classes/class.sort.php'; require_once '../common/config/messages.php'; require_once SOURCE_ROOT . 'classes/class.client.php'; $objClientLogin = new ClientsLogin(); $objClientLogin->isValidClients(); $objSessionRedirectUrl = new SessionRedirectUrl(); $objNiches = new Niches(); $objPaging = new Paging(); $objUrns = new Urns(); $varClientID = $_SESSION['sessClientID']; $varWhere = "1 AND fkClientID=" . $varClientID; $varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessClientPagingLimit']); $varLimit = $varPageStart . ',' . '5'; $arrNichesFlds = array('pkNicheID', 'fkClientID', 'NicheTitle', 'NicheFirstName', 'NicheLastName', 'NicheCity', 'NicheEmailAddress', 'NicheDatePurchase', 'NicheStatus'); $arrNichesRecord = $objGeneral->getRecord(TABLE_NICHES, $arrNichesFlds, $varWhere); $NumberofRows = count($arrNichesRecord); $varClientID = "1 AND fkClientID= " . $varClientID; $arrNichesList = $objNiches->getNichesList(TABLE_NICHES, $arrNichesFlds, $varLimit, $varClientID); $arrUrnsFlds = array('pkUrnID', 'fkNicheID', 'fkClientID', 'UrnTitle', 'UrnFirstName', 'UrnLastName', 'Public', 'UrnSuffix', 'UrnAddedDate', 'UrnAddress'); $arrUrnsRecord = $objGeneral->getRecord(TABLE_URNS, $arrUrnsFlds, $varWhere); $arrUrnsList = $objUrns->getUrnsList(TABLE_URNS, $arrUrnsFlds, $varLimit, $varClientID); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">