Example #1
0
function getcorrDetail($id, $pp_kod, $unit)
{
    $query = "SELECT pp_rkatp_kod FROM p_product\n              WHERE pp_kod='{$pp_kod}'";
    $result = selQuery($query);
    $row = mysqli_fetch_assoc($result);
    ?>
  <div class="tab-block mb25">
    <input type="hidden" id="pp_kod" value="<?php 
    echo $pp_kod;
    ?>
">
    <ul class="nav nav-tabs nav-tabs-right tabs-border">
      <li>
        <a style="cursor:pointer;" onclick="subContent(2,'<?php 
    echo $pp_kod;
    ?>
')" data-toggle="tab"><b><i class="fa fa-check-square-o"></i> Validation List</b></a>
      </li>
      <li class="active">
        <a style="cursor:pointer;" onclick="subContent(1,'<?php 
    echo $pp_kod;
    ?>
')" data-toggle="tab"><b><i class="fa fa-dropbox"></i> Product Details</b></a>
      </li>
    </ul>
    <div class="tab-content admin-form" id="subContent">
      <?php 
    subContent(1, $id, 1, $pp_kod);
    ?>
    </div>
  </div>
  <?php 
}
                            } else {
                                ?>
			<td><?php 
                                echo $totalCountReport;
                                ?>
</td>
		<?php 
                            }
                        }
                    } else {
                        if ($id == 10) {
                            //report id
                            for ($x = 1; $x <= 13; $x++) {
                                if ($x != 13) {
                                    $query2 = "SELECT pp_pkk_screen_tkh,pp_pkk_evaluation_tkh\n\t\t\tFROM p_product\n\t\t\tWHERE MONTH(pp_pkk_evaluation_tkh) = '{$x}'\n\t\t\tAND YEAR(pp_pkk_evaluation_tkh) = '{$year}'\n\t\t\tAND menu_cat_id='{$usId_kod}'";
                                    $result2 = selQuery($query2);
                                    $totalCountReport += mysqli_num_rows($result2);
                                    ?>
			<td><?php 
                                    echo mysqli_num_rows($result2);
                                    ?>
</td>
		<?php 
                                } else {
                                    ?>
			<td><?php 
                                    echo $totalCountReport;
                                    ?>
</td>
		<?php 
                                }
Example #3
0
     if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
         require_once dirname(__FILE__) . '/lang/eng.php';
         $pdf->setLanguageArray($l);
     }
     $pdf->SetFont('helvetica', '', 8);
     $pdf->AddPage();
     $pdf->lastPage();
     $js = 'print(true);';
     // set javascript
     $pdf->IncludeJS($js);
     $pdf->Output($pp_kod . '.pdf', 'I');
 } elseif ($function == "viewProd") {
     $pp_kod = $_GET['pp_kod'];
     $query = "SELECT * FROM p_product";
     $query .= " WHERE pp_kod='{$pp_kod}'";
     $result = selQuery($query);
     $row = mysqli_fetch_assoc($result);
     $pdf = new TCPDF("P", PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
     $pdf->setPrintHeader(false);
     $pdf->setPrintFooter(false);
     $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
     $pdf->SetMargins(5, 5, 5);
     $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
     $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
     if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
         require_once dirname(__FILE__) . '/lang/eng.php';
         $pdf->setLanguageArray($l);
     }
     $pdf->SetFont('helvetica', '', 8);
     $pdf->AddPage();
     $html = '<div align="center">AGENSI REGULATORI FARMASI NEGARA</div>';