amir.bakhtiari
شنبه 29 فروردین 1394, 16:11 عصر
<?php
include_once("header.php");
include_once("GenUtility.php");
?>
<h4 align="right" style="color: #000022; text-align: center; font-weight: bold; font-style: normal;">
<p>لیست کالاها</p>
<table >
<form method="GET" action="Stuffs.php">
کد :
<input name="Code" type="text" value="
<?PHP
if(isset($_GET['Code']))
echo $_GET['Code'];
?>
">
نام کالا :
<input name="Name" type="text"
value="
<?PHP
if(isset($_GET['Name']))
echo $_GET['Name'];
?>
">
<br>
<br>
<input type="submit" value="جستجو">
</form>
</table>
<?PHP
include "KMySQL.php";
$my = new KMySQL;
$utility = new GenUtility();
$sQuery = "SELECT st.iID, st.iCode, st.sName, st.sUnit, st.dSellPrice, st.dCount, st.oPicture, sfc.sName
FROM Stuffs st, StuffFirstClass sfc WHERE st.iStatus=0 ";
$sQuery .= " AND sfc.iID = st.iFirstClassID";
//$sQuery .= " AND (iKind=1 OR iKind=2) ";
if(isset($_GET['Name'])) {
$name = $utility->arabicToPersian($_GET['Name']);
$sQuery .= " AND st.sName LIKE '%" . $name . "%' ";
}
if(isset($_GET['Code']))
{
if(isset($_GET['Name']))
$sQuery .= " AND st.iCode LIKE '%" . $_GET['Code'] . "%' ";
}
$sQuery .= " ORDER BY st.sName";
//echo $sQuery;
$my->ExecuteQuery($sQuery);
if($my->m_result)
{
$iRowFrom = 0;
if(isset($_GET['iFrom']))
$iRowFrom = $_GET['iFrom'];
$iRowTo = $iRowFrom + 20;
if(isset($_GET['iTo']))
$iRowFrom = $_GET['iTo'];
$asTitles = array("ردیف", "شناسه", "کد", "نام", "واحد", "قیمت فروش", "موجودی", "تصویر", "گروه");
if(isset($_GET['Select']))
{
$asTitles[] = "انتخاب";
$my->FillRow($asTitles, $iRowFrom, $iRowTo, 1, true, "order.php?iID=");
}
else
{
$my->FillRow($asTitles, $iRowFrom, $iRowTo, 0, false);
}
}
?>
<br>
</h4>
<?PHP
include_once("footer.php");
?>