/**
* 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">
