function getPages($page_id, $level = 0, $class = 'a', $current_page = '')
{
global $db, $class_ul;
$level++;
if($current_page == '')
{
$isfirst == 1;
$current_page = getMainPage($page_id);
$ul_class = ' class="page_menu"';
$sql = "SELECT page_id FROM pages WHERE page_parent = '".$page_id."' AND page_ts_delete IS NULL;";
$has_childs = $db->get_results($sql);
if(count($has_childs)>0) $return.= '<span class="page_menu_title">'.utf8_encode(getDBData('page', 'title', $current_page)).':</span>';
}
$return.= '<ul'.$ul_class.'>';
$level_spacer = '';
for($l=1;$l<=$level;$l++)
{ $level_spacer = $level_spacer.' ';}
$sql = "SELECT * FROM pages WHERE page_parent = '".$current_page."' AND page_ts_delete IS NULL;";
$pages = $db->get_results($sql);
if(count($pages)>0)
{
foreach($pages as $page)
{
$return.= '<li '.(($level>1)? '':'class="menu-'.$class).' id="link_'.$page->page_title.'">'.$level_spacer.'<a href="?p='.$page->page_id.'">'.utf8_encode($page->page_title).'</a>';
if($page->page_id != '' && $page->page_id == $page_id) $return.= '<div class="menu-'.$class.$liclass.'" id="selected"></div>';
$sql = "SELECT page_id FROM pages WHERE page_parent = '".$page->page_id."' AND page_ts_delete IS NULL;";
$has_childs = $db->get_results($sql);
if(count($has_childs)>0) $return.= getPages($page_id, $level, $class, $page->page_id);
$return.= '</li>';
if($class == 'a') { $class = 'b'; } else { $class = 'a'; }
}
$return.= '</ul>';
}
return $return;
}
});
});
</script>
<?php
function getDBData()
{
//log the call
$fetchedData = myDbCode . fetchData();
return $fetchedData;
}
echo getDBData();
?>
<script type="text/javascript">
var getDBData = function(callback) {
$.ajax({
url: "scholarships.php"
}).done(callback);
}
var dbData = <?php
echo json_encode(getDBData());
?>
getDBData(function(data) {
dbData = data;
})
</script>
</body>
</html>
$processedrows++;
}
/* $cper = (100 - ((($nonProd-3600) / $requiredSeconds) * 100));
$TransactionSummary[$currRow]['Percentage'] = number_format($cper, 2, '.', '');
$avgPer+=$cper; */
$currRow++;
}
$currRow = 0;
foreach ($TransactionSummary as $TransactionSummary1) {
$TransactionSummaryShort[$currRow] = array('Working Day' => $TransactionSummary1['Working Day'], 'Employee Code' => $TransactionSummary1['Employee Code'], 'Resource Name' => $TransactionSummary1['Resource Name'], 'Productive' => $TransactionSummary1['Productive'], 'Shortage' => $TransactionSummary1['Shortage']);
$currRow++;
}
return $TransactionSummaryShort;
}
$query = "SELECT a.empcode, a.empname, a.controllerno, a.channelno, a.type, a.adatetime FROM " . "swipe_transactions a WHERE a.isactive = 1 and a.EmpCode in (select empcode from swipe_main_employees " . "where user_id in (72)) and aDate between STR_TO_DATE('04-02-2015','%d-%m-%Y') and " . "STR_TO_DATE('04-02-2015','%d-%m-%Y') ORDER BY a.aDateTime;";
$swipeTransactions = getDBData($query);
$processedTransactions = ProcessTransactions($swipeTransactions);
$TransactionSummary = TransactionSummaryShort($processedTransactions);
?>
<h1>Transactions Summary</h1> <?php
echo ConvertArrayToTable("", $TransactionSummary, "800px");
?>
<h1>Processed Transactions</h1> <?php
echo ConvertArrayToTable("", $processedTransactions, "1200px");
?>
<h1>Swipe Transactions</h1> <?php
echo ConvertArrayToTable("", $swipeTransactions, "1200px");
?>
function getDBData($id = '')
{
getDBData();
}
/**
* 特殊说明：该组件不能使用到 dialog中。
*/
private function getData()
{
return getDBData(0);
}
