<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
Esempio n. 3
0
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> View Supplier | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	<?php 
if (!isset($_REQUEST['print'])) {
    ?>
	
	<style type="text/css">
	body, #wrapper, #content-wrapper, #content, #box { background: none; }
	</style>
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
Esempio n. 5
0
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
Esempio n. 6
0
    function showReportGeneralPREPSchoolBySupplier($intYearMonth)
    {
        global $STR_URL;
        $intMonth = intval(substr($intYearMonth, -2, 2));
        $intYear = intval(substr($intYearMonth, 0, 4));
        $strReportTitle = HTML::getMonthName($intMonth) . " " . $intYear . " PREP School";
        ?>

		<div style="clear:both;text-align:center;"><h2><?php 
        echo $strReportTitle;
        ?>
</h3></div>
		<div style="clear:both;"><h3 style="font-size:1.3em;">Report by Supplier</h3></div>
		<table class="table table-bordered table-hover">
			<thead class="well">					
				<tr>
					<th style="text-align:center;"><strong>Supplier</strong></th>
					<th style="text-align:center;">Product</th>
					<th style="text-align:center;">Date</th>					
				</tr>
			</thead>
			<tbody>				
				<?php 
        $queryProduct = "SELECT * FROM `mbs_bookings_products` t1, \n\t\t\t\t\t\t\t\t\t\t\t\t   `mbs_bookings_activities` t2,  \n\t\t\t\t\t\t\t\t\t\t\t\t   `mbs_bookings` t3,\n\t\t\t\t\t\t\t\t\t\t\t\t   `mbs_suppliers` t4,\n\t\t\t\t\t\t\t\t\t\t\t\t   `mbs_activities` t5\n\t\t\t\t\t\t\t\t\t\t\t WHERE t1.`booking_activity_id` = t2.`booking_activity_id` \n\t\t\t\t\t\t\t\t\t\t\t AND t1.`booking_id` = t3.`booking_id`\n\t\t\t\t\t\t\t\t\t\t\t AND t3.`supplier_id` = t4.`supplier_id` \n\t\t\t\t\t\t\t\t\t\t\t AND t5.`activity_id` = t2.`activity_id` \n\t\t\t\t\t\t\t\t\t\t\t AND t5.`activity_name` LIKE '%PREP School%'\n\t\t\t\t\t\t\t\t\t\t\t AND t2.`booking_activity_year` = " . $intYear . " \n\t\t\t\t\t\t\t\t\t\t\t AND t2.`booking_activity_month` = " . $intMonth . "\n\t\t\t\t\t\t\t\t\t\t\t ORDER BY t4.`supplier_name`, t1.`booking_product_name`";
        //echo $queryProduct;
        $resultProduct = mysql_query($queryProduct);
        if ($resultProduct) {
            if (mysql_num_rows($resultProduct) > 0) {
                $i = 0;
                $data = array();
                while ($rowProduct = mysql_fetch_assoc($resultProduct)) {
                    $data[$i] = $rowProduct['supplier_id'];
                    $i++;
                    $intSupplierID = DB::dbIDToField('mbs_bookings', 'booking_id', $rowProduct['booking_id'], 'supplier_id');
                    $strSupplierName = DB::dbIDToField('mbs_suppliers', 'supplier_id', $intSupplierID, 'supplier_name');
                    $strActivitySize = DB::dbIDToField('mbs_sizes', 'size_id', $rowProduct['size_id'], 'size_name');
                    $intPagesTally = REPORT::getPagesTally($rowProduct['size_id']);
                    if ($data[$i - 1] !== $data[$i - 2]) {
                        ?>
		
								<tr>
									<td style="text-align:left;" colspan="4"><strong><?php 
                        echo stripslashes($strSupplierName);
                        ?>
</strong></td>
								</tr>
							<?php 
                    }
                    ?>
								<tr>
									<td style="text-align:right;"><?php 
                    echo $i;
                    ?>
</td>								
									<td style="text-align:left;"><?php 
                    echo stripslashes($rowProduct['booking_product_name']);
                    ?>
</td>
									<td style="text-align:left;"><?php 
                    echo stripslashes(HTML::convertDate($rowProduct['booking_date']));
                    ?>
</td>								
									
								</tr>

							<?php 
                }
                // while($rowProduct)
            } else {
                ?>
							<tr>
								<td colspan="4"><div style="text-align:center;"><em>No data was found</em></div></td>	
							</tr>
							<?php 
            }
        }
        // if ($resultProduct)
        ?>

			</tbody>
			<tfoot>
			</tfoot>
		</table>	

		<?php 
        // The Log
        $strLog = "View PREP School by Month by Supplier Report for \"" . HTML::getMonthName($intMonth) . " " . $intYear . "\"";
        $queryLog = "INSERT INTO `logs` (`log_id`, \n\t\t\t\t\t\t\t\t\t\t `log_user`, \n\t\t\t\t\t\t\t\t\t\t `log_action`, \n\t\t\t\t\t\t\t\t\t\t `log_time`, \n\t\t\t\t\t\t\t\t\t\t `log_from`, \n\t\t\t\t\t\t\t\t\t\t `log_logout`)\n\n\t\t\t\t\tVALUES (NULL, \n\t\t\t\t\t\t\t'" . $_SESSION['user']['login_name'] . "',\n\t\t\t\t\t\t\t'" . mysql_real_escape_string($strLog) . "',\n\t\t\t\t\t\t\t'" . date('Y-m-d H:i:s') . "',\n\t\t\t\t\t\t\t'" . $_SESSION['user']['ip_address'] . "', \n\t\t\t\t\t\t\tNULL)";
        $resultLog = mysql_query($queryLog);
    }
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
function build_report_object()
{
    $GLOBALS['time'] = array();
    $ses = $_GET['ses'];
    $form_ses = $_GET['form_ses'];
    $report = $_GET['r'];
    $dir = $_GET['dir'];
    $get_array = array();
    $emailer = $_GET['emailer'];
    while (list($key, $value) = each($_GET)) {
        $get_array["#{$key}#"] = $value;
    }
    include_once "../{$dir}/database.php";
    include_once 'common.php';
    //--------security check-------------------------------
    if ($emailer != '1') {
        if (activityPasswordNeeded($report)) {
            $session = nuSession($ses, false);
            if ($session->foundOK == '') {
                print 'you have been logged out..';
                return;
            }
        }
    }
    //---------------------------------------------------
    $id = uniqid('1');
    $thedate = date('Y-m-d H:i:s');
    $dq = '"';
    $setup = nuSetup();
    $T = nuRunQuery("SELECT * FROM zzsys_activity WHERE sat_all_code = '{$report}'");
    $activity = db_fetch_object($T);
    //----------allow for custom code----------------------------------------------
    //--already done now..	eval($activity->sat_report_display_code);   //---(Reporting Class)
    $displayClass = new Reporting();
    $REPORT = new REPORT($displayClass, $dir, $ses);
    if ($activity->zzsys_activity_id == '') {
        print 'No Such Report...';
        return;
    }
    $viewer = $session->sss_zzsys_user_id;
    $s = "INSERT INTO zzsys_report_log (zzsys_report_log_id, ";
    $s .= "srl_zzsys_activity_id, srl_date ,srl_viewer) ";
    $s .= "VALUES ('{$id}', '{$report}', '{$thedate}', '{$viewer}')";
    nuRunQuery($s);
    $s = "SELECT count(*), MAX(sva_expiry_date) FROM zzsys_variable ";
    $s .= "WHERE sva_id = '{$form_ses}' ";
    $s .= "GROUP BY sva_expiry_date";
    $t1 = nuRunQuery($s);
    $r1 = db_fetch_row($t1);
    $numberOfVariables = $r1[0];
    $expiryDate = $r1[1];
    if ($numberOfVariables == 0) {
        //---must have at least 1 variable
        print 'Report has Expired...';
        return;
    }
    $s = "DELETE FROM zzsys_variable ";
    $s .= "WHERE sva_id = '{$form_ses}' ";
    $s .= "AND sva_name = 'ReportTitle'";
    nuRunQuery($s);
    setnuVariable($form_ses, $expiryDate, 'ReportTitle', $activity->sat_all_description);
    $TT = TT();
    //--Temp table name
    //----------create an array of hash variables that can be used in any "hashString"
    $sesVariables = recordToHashArray('zzsys_session', 'zzsys_session_id', $ses);
    //--session values (access level and user etc. )
    $sesVariables['#dataTable#'] = $TT;
    $sesVariables['#TT#'] = $TT;
    $GLOBALS['TT'] = $TT;
    $dataTable = $TT;
    $sysVariables = sysVariablesToHashArray($form_ses);
    //--values in sysVariables from the calling lookup page
    $arrayOfHashVariables = joinHashArrays($sysVariables, $sesVariables);
    //--join the arrays together
    $formValue = array();
    while (list($key, $value) = each($sesVariables)) {
        $formValue[substr($key, 1, -1)] = $value;
    }
    //-------------------------------build $TT with PHP----------------------------------------
    $v = getSelectionFormVariables($form_ses);
    $hashV = arrayToHashArray($v);
    $arrayOfHashVariables = joinHashArrays($arrayOfHashVariables, $hashV);
    //--join the arrays together
    $REPORT->tablesUsed = getSelectionFormTempTableNames($form_ses, $v);
    //--temp tables to delete when finished
    $formValue = $v;
    $nuHashVariables = $arrayOfHashVariables;
    //--added by sc 23-07-2009
    eval(replaceHashVariablesWithValues($arrayOfHashVariables, $activity->sat_report_data_code));
    $REPORT->no_data = addVariablesToTT($TT, $v);
    nuRunQuery("ALTER TABLE `{$TT}` ADD `nu__id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST");
    $REPORT->nuloopThroughRecords($TT);
}
Esempio n. 10
0
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
Esempio n. 11
0
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
Esempio n. 13
0
    case 5:
        $rw = 'all';
        break;
    case 6:
        $rw = 'all';
        break;
    case 7:
        $rw = 'all';
        break;
    case 8:
        $rw = 'all';
        break;
}
$store = $_GET['s'];
$range = $_GET['r'];
$data = $_GET['d'];
$type = $_GET['t'];
if ($rw == 'all') {
    $store = MYSQL::QUERY("SELECT s_id,s_name FROM core_stores WHERE s_id = ? LIMIT 1", array($store));
} else {
    $store = MYSQL::QUERY("SELECT s_id,s_name FROM core_stores WHERE {$rw} = ? AND s_id = ? LIMIT 1", array($user['user_id'], $store));
}
if (!$store == '') {
    function Date_UTC($dr)
    {
        return array(date('Y', strtotime(str_replace('-', '/', $dr))), date('m', strtotime(str_replace('-', '/', $dr))), date('d', strtotime(str_replace('-', '/', $dr))), date('H', strtotime(str_replace('-', '/', $dr))), date('i', strtotime(str_replace('-', '/', $dr))));
    }
    $pos = strpos($range, ' - ');
    require "{$data}.php";
    REPORT::FORMAT($store, $range, $pos);
}
<?php 
include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';
<?php

include 'inc/_include.php';
#$admin->checkUserLogin();
require_once 'lib/report.php';
$report = new REPORT();
?>
<!DOCTYPE html> 
<!--[if IE 7 ]><html class="no-js ie ie7 lte7 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 8 ]><html class="no-js ie ie8 lte8 lte9" lang="en-US"> <![endif]-->
<!--[if IE 9 ]><html class="no-js ie ie9 lte9>" lang="en-US"> <![endif]-->
<!--[if (gt IE 9)|!(IE)]><!--> <html class="no-js" lang="en-US"> <!--<![endif]-->
<head>
<title> Report | <?php 
echo stripslashes($arrSiteConfig['site_name']);
?>
</title> 
	<meta name="description" content="<?php 
echo stripslashes($arrSiteConfig['site_description']);
?>
" /> 
	<?php 
include 'inc/init.php';
?>
	
</head> 

<body>

	<?php 
include 'inc/header.php';