Esempi di codice in PHP per Urns

Esempio n. 1

0

Mostra file

File: urns_detail.php Progetto: saurabhs4/niches

<?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">

Esempio n. 2

0

Mostra file

File: urns_add.php Progetto: saurabhs4/niches

$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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Add Urn</title>
<link href="css/menu.css" rel="stylesheet" type="text/css" />
<link href="css/common.css" rel="stylesheet" type="text/css" />
<link href="css/form.css" rel="stylesheet" type="text/css" />
<link href="css/tables.css" rel="stylesheet" type="text/css" />

Esempio n. 3

0

Mostra file

File: urns_export.php Progetto: saurabhs4/niches

<?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 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();
$objUrns = new Urns();
$objPaging = new Paging();
$varClientID = $_SESSION['sessClientID'];
$varWhere = "1 AND urns.fkClientID=" . $varClientID . " AND niches.fkClientID =" . $varClientID;
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessClientPagingLimit']);
$varLimit = $varPageStart . ',' . $_SESSION['sessClientPagingLimit'];
$arrUrnsFlds = array('pkUrnID', 'fkNicheID', 'NicheTitle', 'urns.fkClientID', 'UrnTitle', 'UrnFirstName', 'UrnLastName', 'Public', 'UrnSuffix', 'UrnAddedDate', 'UrnTagNumber');
$arrUrnsRecord = $objGeneral->getRecord('niches JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varWhere);
$NumberofRows = count($arrUrnsRecord);
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessClientPagingLimit']);
$arrUrnsList = $objUrns->getUrnsList('niches JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varLimit, $varWhere);
$excel = new ExcelWriter("urns_list.xls");
if ($excel == false) {
    echo $excel->error;
}
$main_array = array('<b>Urn ID</b>', '<b>Niche ID</b>', '<b>Niche Title</b>', '<b>Client ID</b>', '<b>Urn Title</b>', '<b>First Name</b>', '<b>Last Name</b>', '<b>Public</b>', '<b>Suffix</b>', '<b>Added Date</b>', '<b>Tag Number</b>');
$columnTitles = array_values($main_array);
$numColumns = count($columnTitles);

Esempio n. 4

0

Mostra file

File: urns_export.php Progetto: saurabhs4/niches

<?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 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();
$objClients = new Clients();
$objNiches = new Niches();
$objSessionRedirectUrl = new SessionRedirectUrl();
$objUrns = new Urns();
$objPaging = new Paging();
$varClientID = $_SESSION['sessClientID'];
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']);
$varLimit = $varPageStart . ',' . $_SESSION['sessAdminPagingLimit'];
$arrUrnsFlds = array('clients.ClientLoginID', 'niches.NicheFirstName', 'pkUrnID', 'UrnTitle', 'UrnFirstName', 'UrnLastName', 'Public', 'UrnAddedDate', 'UrnAddress', 'UrnTagNumber');
$arrUrnsRecord = $objGeneral->getRecord('(clients JOIN niches  ON niches.fkClientID = clients.pkClientID) 
JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varWhere);
$NumberofRows = count($arrUrnsRecord);
$varClientID = "1";
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessAdminPagingLimit']);
$arrUrnsList = $objUrns->getUrnsList('(clients JOIN niches  ON niches.fkClientID = clients.pkClientID) 
JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varLimit, $varClientID);
$excel = new ExcelWriter("urns_export.xls");
if ($excel == false) {
    echo $excel->error;

Esempio n. 5

0

Mostra file

File: urn_list_uil.php Progetto: saurabhs4/niches

<?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 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();
$objClients = new Clients();
$objNiches = new Niches();
$objSessionRedirectUrl = new SessionRedirectUrl();
$objUrns = new Urns();
$objPaging = new Paging();
$varClientID = $_SESSION['sessClientID'];
$varPage = $_GET['page'];
if ($varPage == '') {
    $varPage = 0;
}
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessAdminPagingLimit']);
$varLimit = $varPageStart . ',' . $_SESSION['sessAdminPagingLimit'];
$arrUrnsFlds = array('clients.ClientLoginID', 'niches.NicheFirstName', 'pkUrnID', 'fkNicheID', 'urns.fkClientID', 'UrnTitle', 'UrnFirstName', 'UrnLastName', 'Public', 'UrnAddedDate', 'UrnAddress', 'UrnTagNumber');
$arrUrnsRecord = $objGeneral->getRecord('(clients JOIN niches  ON niches.fkClientID = clients.pkClientID) 
JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varWhere);
$NumberofRows = count($arrUrnsRecord);
$varClientID = "1";
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessAdminPagingLimit']);
$arrUrnsList = $objUrns->getUrnsList('(clients JOIN niches  ON niches.fkClientID = clients.pkClientID) 
JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varLimit, $varClientID);

Esempio n. 6

0

Mostra file

File: urns_action.php Progetto: saurabhs4/niches

<?php

require_once '../common/config/config.inc.php';
require_once SOURCE_ROOT . 'classes/class.urns.php';
require_once SOURCE_ROOT . 'classes/validator.php';
require_once '../classes/class.clients_login.php';
$objClientLogin = new ClientsLogin();
$objClientLogin->isValidClients();
$objUrns = new Urns();
if ($_POST['sbmt_urns']) {
    $varAffectedID = $objUrns->saveUrns($_POST);
    if ($varAffectedID) {
        $objCore->standardRedirect('urn_list_uil.php');
    } else {
        $objCore->standardRedirect($_SESSION['sessRedirectURL']);
    }
}
if ($_POST['frmChangeAction1'] != '' || $_POST['frmChangeAction2'] != '') {
    $varReturnID = $objUrns->updateUrnsList($_POST);
    if ($varReturnID == 1) {
        $objCore->standardRedirect('urn_list_uil.php');
        die;
    } else {
        if ($varReturnID == 2 || $varReturnID == 3) {
            $objCore->standardRedirect($_SESSION['sessRedirectURL']);
            die;
        }
    }
}
if ($_POST['assign_urns'] != '') {
    $varReturnID = $objUrns->assignUrnsList($_POST);

Esempio n. 7

0

Mostra file

File: welcome.php Progetto: saurabhs4/niches

<?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">

Esempio n. 8

0

Mostra file

File: urn_list_uil.php Progetto: saurabhs4/niches

<?php

require_once '../common/config/config.inc.php';
require_once SOURCE_ROOT . 'classes/class.urns.php';
require_once SOURCE_ROOT . 'classes/class.paging.php';
require_once SOURCE_ROOT . 'classes/class.sort.php';
require_once SOURCE_ROOT . 'classes/class.clients_login.php';
$objClientLogin = new ClientsLogin();
$objClientLogin->isValidClients();
$varPage = $_GET['page'];
if ($varPage == '') {
    $varPage = 0;
}
$objSessionRedirectUrl = new SessionRedirectUrl();
$objUrns = new Urns();
$objPaging = new Paging();
$varClientID = $_SESSION['sessClientID'];
$varWhere = "1 AND urns.fkClientID=" . $varClientID . " AND niches.fkClientID =" . $varClientID;
$varPageStart = $objPaging->getPageStartLimit($_GET['page'], $_SESSION['sessClientPagingLimit']);
$varLimit = $varPageStart . ',' . $_SESSION['sessClientPagingLimit'];
$arrUrnsFlds = array('pkUrnID', 'fkNicheID', 'NicheTitle', 'urns.fkClientID', 'UrnTitle', 'UrnFirstName', 'UrnLastName', 'Public', 'UrnSuffix', 'UrnAddedDate', 'UrnAddress', 'UrnTagNumber');
$arrUrnsRecord = $objGeneral->getRecord('niches JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varWhere);
$NumberofRows = count($arrUrnsRecord);
//$varClientID="1 AND fkClientID= ".$varClientID;
$varNumberPages = $objPaging->calculateNumberofPages($NumberofRows, $_SESSION['sessClientPagingLimit']);
$arrUrnsList = $objUrns->getUrnsList('niches JOIN urns ON niches.pkNicheID = urns.fkNicheID', $arrUrnsFlds, $varLimit, $varWhere);
//print_r($arrUrnsList);die;
?>
<!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>

Esempi in PHP per Urns