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