require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/ItemDto.php';
require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/dao/ItemDao.php';
require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/Util.php';
try {
$dao = new ItemDao();
$item = new ItemDto();
$util = new Util();
$code = $_POST['code'];
$name = $_POST['name'];
$price = $_POST['price'];
$qty = $_POST['qty'];
$detail = $_POST['detail'];
$priCd = $_POST['priCd'];
$qtyCd = $_POST['qtyCd'];
$item->setCode($code);
$item->setName($name);
$item->setPrice($price);
$item->setQty($qty);
$item->setDetail($detail);
$items = array();
$items = $dao->getItem($item, $priCd, $qtyCd);
} catch (Exception $e) {
$error = $e->getMessage();
}
header('Content-Type: text/html; charset=utf-8');
?>
<!DOCTYPE html>
<html>
<head>
<script type="text/javascript"
/**
* ItemDtoからテーブルitemをselect検索します。
* 在庫数qtyと値段priceは以上以下の選択ができます。
*
* @param ItemDto $item
* 検索するitemのオブジェクト
* @param int $priCd
* 値段コード、0=以上,1=以下
* @param int $qtyCd
* 在庫数コード、0=以上,1=以下
*/
public function getItem($item, $priCd, $qtyCd)
{
$code = $item->getCode();
if (empty($code)) {
$code = '%';
}
$name = $item->getName();
$price = $item->getPrice();
$detail = $item->getDetail();
$qty = $item->getQty();
$sql = 'select code, name, price, detail, qty
from item
where code like ?
and name like ? ';
switch ($priCd) {
case 0:
$sql .= 'and price >= ? ';
break;
case 1:
$sql .= 'and price <= ? ';
break;
}
switch ($qtyCd) {
case 0:
$sql .= 'and qty >= ? ';
break;
case 1:
$sql .= 'and qty <= ? ';
break;
}
if (!empty($detail)) {
$sql .= 'and detail like ? ';
}
$stmt = $this->pdo->prepare($sql);
$stmt->bindValue(1, $code, PDO::PARAM_INT);
$stmt->bindValue(2, '%' . $this->esc_str($name) . '%', PDO::PARAM_STR);
$stmt->bindValue(3, $price, PDO::PARAM_INT);
$stmt->bindValue(4, $qty, PDO::PARAM_INT);
$stmt->bindValue(5, '%' . $this->esc_str($detail) . '%', PDO::PARAM_STR);
$stmt->execute();
$rItems = array();
foreach ($stmt as $row) {
$rItem = new ItemDto();
$rItem->setCode($row['code']);
$rItem->setName($row['name']);
$rItem->setPrice($row['price']);
$rItem->setDetail($row['detail']);
$rItem->setQty($row['qty']);
array_push($rItems, $rItem);
}
return $rItems;
}
<?php
require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/ItemDto.php';
require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/dao/ItemDao.php';
require_once '/export/home/g2sn/enrlprc/html/kura/z-ap/Util.php';
try {
$dao = new ItemDao();
$item = new ItemDto();
$util = new Util();
$bcode = $_POST['code'];
$item->setCode($bcode);
$item->setName("");
$item->setPrice(0);
$item->setQty(0);
$item->setDetail("");
$items = array();
$items = $dao->getItem($item, 0, 0);
} catch (Exception $e) {
$error = $e->getMessage();
}
header('Content-Type: text/html; charset=utf-8');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>変更情報入力</title>
</head>
<body>
<?php
if (isset($error)) {
<?php
require_once 'J:/enrlprc/html/kura/z-ap/ItemDto.php';
require_once 'J:/enrlprc/html/kura/z-ap/dao/ItemDao.php';
$dao = new ItemDao();
$item = new ItemDto();
echo "--------検索----------\n";
$item->setCode("");
$item->setName("");
$item->setPrice(0);
$item->setQty(0);
$item->setDetail("");
$items = array();
$items = $dao->getItem($item, 0, 0);
foreach ($items as $item) {
echo "---------------------------------\n";
echo 'code==>' . $item->getCode() . "\n";
echo 'name==>' . $item->getName() . "\n";
echo 'price==>' . $item->getPrice() . "\n";
echo 'qty==>' . $item->getQty() . "\n";
echo 'detail==>' . $item->getDetail() . "\n";
echo "---------------------------------\n";
}
echo "--------削除----------\n";
$result = $dao->deleteItem(8888);
var_dump($result);
$item->setCode(8888);
$item->setName("");
$item->setPrice(0);
$item->setQty(0);
$item->setDetail("");
