iframe-proxy | Sunbelt Computer Software

83 lines (74 loc) · 3.08 KB

$accessDataCollection = '';
if( $surveyAuth == false && $callCenterAuth == false)
   $accessDataCollection = "No Access";
$smarty->assign("accessDataCollection",$accessDataCollection);
require_once "$_SERVER[DOCUMENT_ROOT]/datacollection/functions.php";
if(isset($_POST['cityId']) && !empty($_POST['cityId'])){
    unset($_SESSION[$_SERVER['PHP_SELF']]);
    $_SESSION[$_SERVER['PHP_SELF']]['city'] = $_POST['cityId'];
    $_SESSION[$_SERVER['PHP_SELF']]['suburb'] = $_POST['suburbId'];
if(isset($_SESSION[$_SERVER['PHP_SELF']]['city']) && !empty($_SESSION[$_SERVER['PHP_SELF']]['city'])){
    $projectsfromDB = getProjectListForManagers($_SESSION[$_SERVER['PHP_SELF']]['city'], $_SESSION[$_SERVER['PHP_SELF']]['suburb']);
    $projectSummary = prepareDisplayData($projectsfromDB);
    $projectSummaryTotal = $projectSummary['total'];
    unset($projectSummary['total']);
$CityDataArr = City::CityArr();
if(isset($projectSummary) && $_REQUEST['download'] == 'true'){
    download_xls_file($projectSummary);
$smarty->assign("CityDataArr", $CityDataArr);
$smarty->assign("projectSummary", $projectSummary);
$smarty->assign("projectSummaryTotal", $projectSummaryTotal);
$smarty->assign("selectedCity", $_SESSION[$_SERVER['PHP_SELF']]['city']);
function prepareDisplayData($data){ 
    $result = array();
    foreach ($data as $value) {
        $stage = $value['PROJECT_STAGE'];
        $aAssignedTo = explode('|', $value['ASSIGNED_TO']);
        $aAssignedToDep = explode('|', $value['DEPARTMENT']);
        $assignmentType = '';
        if($value['PREV_PROJECT_PHASE'] == 'Audit1' || $value['PREV_PROJECT_PHASE'] == 'Audit2') $assignmentType .= 'Reverted-';
        if($aAssignedToDep[count($aAssignedToDep)-1] === 'SURVEY')$assignmentType .= 'Field';
        elseif(empty($aAssignedTo[0])) $assignmentType .= 'Unassigned';
        else{
            $assignmentType .= 'Assigned-'.  strval(count($aAssignedTo));
        $aStatus = explode('|', $value['STATUS']);
        $completionStatus = end($aStatus);
        $result[$assignmentType][$stage]['total'] += 1;
        $result[$assignmentType][$stage][$completionStatus] += 1;
        $result['total'][$stage]['total'] += 1;
        $result['total'][$stage][$completionStatus] += 1;
    return $result;
function download_xls_file($projectSummary){
    $filename = "/tmp/data_collection_summary_".time().".xls";
    $newProjectSummaryStorage = array();
    foreach($projectSummary as $key=>$summary){
        foreach($summary as $pkey => $val){
            $val['AssignmentType'] = $key;
            $val['Stage'] = $pkey;
            $val = enter_missing_keys($val);
            array_push($newProjectSummaryStorage, $val);
    excel_file_download($newProjectSummaryStorage, $filename);
function enter_missing_keys($arr){
    $val = array();
    $keys = array("AssignmentType","Stage","total","incomplete","doneExceptInventory","notAttempted");
    foreach($keys as $key){
        if(array_key_exists($key, $arr)){
            $val[$key] = $arr[$key];
        else{
            $val[$key] = NULL;
    return $val;

Sunbelt Computer Software

PL/B Language Development and Support

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Sunbelt Computer Software

PL/B Language Development and Support

Uh oh!

FilesExpand file tree

projectStatusSummaryProcess.php

Latest commit

History

projectStatusSummaryProcess.php

File metadata and controls