getTable_where_and PHP Code Examples

Example #1

0

Show file

File: claim1.php Project: bbuffsoft/ps_supply

<?php

$con = connect_db();
$result = getTable_where_and('claim', "cl_type='1'", $con);
?>
<div class="panel panel-default">
    <div class="panel-heading">
        ใบแจ้งเครม
        <a href="?module=system_claim&action=form_insert_claim" class="btn btn-sm btn-success pull-right">เพิ่มรายการเครมสินค้า</a>
        <i class="clearfix"></i>
    </div>
    <div class="panel-body">
        <div class="table-responsive">
        <table class="display table-responsive table-data" border="1" cellspacing="0" width="100%">
            <thead>
                <tr>
                    <th>รหัส</th>
                    <th>ผู้ส่งเครม/ชื่อลูกค้า</th>
                    <th>วันที่เครม</th>
                    <th>สถานะ</th>
                    <th></th>
                </tr>
            </thead>
            <tbody>
                <?php 
while ($r = assoc_get($result)) {
    ?>
                <tr>
                    <td align="center">CL-<?php 
    echo $r['cl_id'];
    ?>

Example #2

0

Show file

File: receipt.php Project: bbuffsoft/ps_supply

<?php

date_default_timezone_set("Asia/Bangkok");
$con = connect_db();
$result = getTable_where_and('saleproduct_tb', "sp_id='{$_GET['id']}'", $con);
$r = assoc_get($result);
require_once '../plugin/mpdf60/mpdf.php';
$mpdf = new mPDF('th', 'A4', '', '', 5, 5, 20, 20, 5, 5);
$mpdf->mirrorMargins = 1;
// Use different Odd/Even headers and footers and mirror margins
$header = '
<table width="100%" style="border-bottom: 1px solid #000; vertical-align: bottom; font-size: 9pt; color: #000;"><tr>
<td width="35%"><img src="../img/logo.png" width="150px"></td>
<td width="65%" align="right">
    <span>พีเอส ซัพพลาย</span> 
    <span>อาคารคอมพิวเตอร์พลาซ่า ห้อง A12</span> <br>
    <span>312 ถ.มณีนพรัตน์ ต.ศรีภูมิ อ.เมือง จ.เชียงใหม่ 50200</span><br>
    <span>Tel. 094-6071991 Fax. 053-405399</span><br>
</td>
</tr></table>
';
$footer = '<table width="100%" style="border-top: 1px solid #000000; vertical-align: bottom; font-size: 9pt; color: #000088;"><tr>
<td width="33%"></td>
<td width="33%" align="center">หน้า {PAGENO}</td>
<td width="33%" style="text-align: right;"></td>
</tr></table>';
$mpdf->SetHTMLHeader($header);
$mpdf->SetHTMLHeader($header, E);
$mpdf->SetHTMLFooter($footer);
$mpdf->SetHTMLFooter($footer, E);
$arr = unserialize($r['sp_list']);

Example #3

0

Show file

File: form_send_repair.php Project: bbuffsoft/ps_supply

<?php

$con = connect_db();
$query_rp = getTable_where_and('repair', 'rp_status=1 OR rp_status=2', $con);
$date = date('Y-m-d');
?>
<div class="panel panel-default">
    <div class="panel-heading"><a href="index.php?system=1&module=control&action=list_send_repair">ใบส่งซ่อม</a> > เพิ่มใบส่งซ่อม</div>
    <div class="panel-body">
        <form action="index.php?system=1&module=control&action=insert_send_repair" method="POST" class="form-horizontal" id="myform">
            <div class="form-group">
                <label for="sendrepair" class="col-sm-2 control-label">ร้านที่ส่งซ่อม</label>
                <div class="col-sm-5">
                    <input type="text" class="form-control" name="send[sr_company]" placeholder="ร้านที่ส่งซ่อม">
                </div>
            </div>
            <div class="form-group">
                <label for="sendrepair" class="col-sm-2 control-label">เบอร์โทรศัพท์</label>
                <div class="col-sm-5">
                    <input type="text" class="form-control" name="send[sr_phone]" id="phone" placeholder="เบอร์โทรศัพท์">
                </div>
            </div>
            <div class="form-group">
                <label for="sendrepair" class="col-sm-2 control-label">รหัสใบแจ้งซ่อม</label>
                <div class="col-sm-5">
                    <select name="send[rp_id]" class="form-control">
                        <option value="">-- เลือก --</option>
                        <?php 
while ($r = assoc_get($query_rp)) {
    ?>
                        <option value="<?php

Example #4

0

Show file

File: report_fix.php Project: bbuffsoft/ps_supply

<?php

include '../../connect/function_include.php';
date_default_timezone_set("Asia/Bangkok");
$con = connect_db();
$result = getTable_where_and('repair_tb', "rp_id='{$_GET['id']}'", $con);
$r = assoc_get($result);
require_once '../../plugin/mpdf60/mpdf.php';
$mpdf = new mPDF('th', 'A4', '', '', 5, 5, 20, 20, 5, 5);
$mpdf->mirrorMargins = 1;
// Use different Odd/Even headers and footers and mirror margins
$header = '
<table width="100%" style="border-bottom: 1px solid #000; vertical-align: bottom; font-size: 9pt; color: #000;"><tr>
<td width="35%"><img src="../../img/logo.png" width="150px"></td>
<td width="65%" align="right">
    <span>พีเอส ซัพพลาย</span> 
    <span>อาคารคอมพิวเตอร์พลาซ่า ห้อง A12</span> <br>
    <span>312 ถ.มณีนพรัตน์ ต.ศรีภูมิ อ.เมือง จ.เชียงใหม่ 50200</span><br>
    <span>Tel. 094-6071991 Fax. 053-405399</span><br>
</td>
</tr></table>
';
$footer = '<table width="100%" style="border-top: 1px solid #000000; vertical-align: bottom; font-size: 9pt; color: #000088;"><tr>
<td width="33%"></td>
<td width="33%" align="center">หน้า {PAGENO}</td>
<td width="33%" style="text-align: right;"></td>
</tr></table>';
$mpdf->SetHTMLHeader($header);
$mpdf->SetHTMLHeader($header, E);
$mpdf->SetHTMLFooter($footer);
$mpdf->SetHTMLFooter($footer, E);

PHP getTable_where_and Examples