$query2 = "SELECT pp_pkk,pp_pkk_tkh\n\t\t\tFROM p_product\n\t\t\tWHERE MONTH(pp_pkk_tkh) = '{$x}'\n\t\t\tAND YEAR(pp_pkk_tkh) = '{$year}'\n\t\t\tAND menu_cat_id='{$kod}'\n\t\t\tAND pp_pkk='P'"; $result2 = selQuery($query2); $totalCountReport += mysqli_num_rows($result2); ?> <td><?php echo mysqli_num_rows($result2); ?> </td> <?php } else { $query2 = "SELECT pp_pkk,pp_pkk_tkh\n\t\t\tFROM p_product\n\t\t\tWHERE YEAR(pp_pkk_tkh) = '{$year}'\n\t\t\tAND menu_cat_id='{$kod}'\n\t\t\tAND pp_pkk='P'"; // $result2 = selQuery($query2); // $totalCountReport += mysqli_num_rows($result2); ?> <td><?php echo countRow($query2); ?> </td> <?php } } } else { if ($id == 9) { //report id ref unit for ($x = 1; $x <= 13; $x++) { if ($x != 13) { $query2 = "SELECT date_assign,pp_kod\n\t\t\tFROM lab_assign\n\t\t\tWHERE MONTH(date_assign) = '{$x}'\n\t\t\tAND YEAR(date_assign) = '{$year}'\n\t\t\tAND ru_kod='{$ru_kod}'\n\t\t\tGROUP BY pp_kod"; $result2 = selQuery($query2); $totalCountReport += mysqli_num_rows($result2); ?> <td><?php
function countTask($task, $id) { if ($task == "protocol") { $query = "SELECT pp_nama FROM p_product\n LEFT JOIN lab_assign ON la_pp_kod=pp_kod\n WHERE la_us_id='{$id}' AND la_rs_kod IN (403,443)\n GROUP BY pp_kod"; } elseif ($task == "sample") { $query = "SELECT klb_kod FROM k_lab\n WHERE klb_tp_kod='{$id}' AND klb_rs_level IN(403,405)\n GROUP BY klb_kp_id"; } else { $query = "SELECT klb_kod FROM k_lab\n LEFT JOIN k_lab_task_test ON kltt_kp_id=klb_kp_id\n WHERE kltt_tp_kod='{$id}' AND klb_rs_level IN(404)\n GROUP BY kltt_kp_id"; } return countRow($query); }
<?php error_reporting(E_ALL & ~E_NOTICE); error_reporting(E_ERROR | E_PARSE); include_once '../includes/config.php'; include_once '../includes/sqlfunctions.php'; connectDB(); $code = $_REQUEST['code']; $app_reload_url = 'https://www.facebook.com/OpenNirvana/app_1615223755370942'; session_start(); require_once '../header.php'; $user_id = $facebook->getUser(); $level = 1; if ($user_id) { $_SESSION['facebook_id'] = $user_id; $user_count = countRow($user_id, 'facebook', 'user'); if ($user_count > 0) { $user_exist_data = getDataRowsInArray('level', 'user', 'facebook', $user_id, 'id'); if ($user_exist_data[0][0]) { $level = $user_exist_data[0][0] + 1; } } } ?> <!DOCTYPE html> <html> <head> <title>Zeiss Puzzle</title> <link href="css/main.css" type="text/css" rel="stylesheet"> <link href="css/animate.css" type="text/css" rel="stylesheet">
<td> </td> </tr> <tr align="left"> <td><b>PENGHANTAR</b></td> <td></td> <td colspan="2"> </td> </tr> <tr align="left"> <td><b>PENGILANG</b></td> <td colspan="3"></td> </tr> </table> </div> <div class="col-md-12" style="border-top: 1px solid #000;"></div>'; $query = "SELECT kltt_rt_kod,kltt_remark\n FROM k_lab_task_test\n WHERE kltt_kp_id='" . $row['kp_id'] . "' AND kltt_remark IS NOT NULL"; if (countRow($query) > 0) { $pdf->setHeaderData($ln = '', $lw = 0, $ht = '', $header2, $tc = array(0, 0, 0), $lc = array(0, 0, 0)); $pdf->AddPage(); $html = '<table border="0" cellpadding="5" width="100%"> <tr align="center"> <td width="15%"><b>Kod</b></td> <td width="85%"><b>Catatan</b></td> </tr>'; $result = selQuery($query); while ($rows = mysqli_fetch_assoc($result)) { if ($rows['kltt_remark'] != "") { $html .= '<tr> <td style="border-right: 1px solid #000;" align="center">' . getTestCode($rows['kltt_rt_kod']) . '</td> <td>' . nl2br($rows['kltt_remark']) . '</td> </tr>'; }
function countTask($id) { $query = "SELECT pp_nama,pp_ref_no,pharma_assign_date FROM p_product\n LEFT JOIN lab_assign ON la_pp_kod=pp_kod\n WHERE la_us_id='{$id}' AND la_rs_kod IN (403,443)\n GROUP BY pp_kod"; return countRow($query); }