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); }