示例#1
0
<?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();
    $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>
示例#2
0
<?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)) {
示例#3
0
<?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();
    $code = $_POST['code'];
    $item->setCode($code);
    $item->setName("");
    $item->setPrice(0);
    $item->setQty(0);
    $item->setDetail("");
    $result = $dao->deleteItem($code);
} catch (Exception $e) {
    $error = $e->getMessage();
}
header('Content-Type: text/html; charset=utf-8');
?>
<!DOCTYPE html>
<html>
<head>
<script type="text/javascript"
	src="../javascript/jquery/jquery-2.1.4.js"></script>
<script type="text/javascript" src="zapp.js"></script>
<title>削除結果</title>
</head>
<body>
<?php 
示例#4
0
 /**
  * itemテーブルのレコードを上書きします。
  *
  * @param int $beforeCode
  *            変更したい商品のコード
  * @param ItemDto $item
  *            上書きする商品の内容
  * @return int 更新に成功したレコード数
  */
 public function updateItem($beforeCode, $item)
 {
     $code = $item->getCode();
     $name = $item->getName();
     $price = $item->getPrice();
     $qty = $item->getQty();
     $detail = $item->getDetail();
     $sql = 'update item
          set code = ?,
         name = ?,
         price = ?,
         qty = ?,
         detail = ?
         where code = ? ';
     $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->bindValue(6, $beforeCode, PDO::PARAM_INT);
     $stmt->execute();
     return $stmt->rowCount();
 }
示例#5
0
<?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();
    $code = $_POST['code'];
    $name = $_POST['name'];
    $price = $_POST['price'];
    $qty = $_POST['qty'];
    $detail = $_POST['detail'];
    $item->setCode($code);
    $item->setName($name);
    $item->setPrice($price);
    $item->setQty($qty);
    $item->setDetail($detail);
    $result = $dao->insertItem($item);
} catch (Exception $e) {
    $error = $e->getMessage();
}
header('Content-Type: text/html; charset=utf-8');
?>
<!DOCTYPE html>
<html>
<head>
<script type="text/javascript"
	src="../javascript/jquery/jquery-2.1.4.js"></script>
<script type="text/javascript" src="zapp.js"></script>
示例#6
0
<?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['bcode'];
    $code = $_POST['code'];
    $name = $_POST['name'];
    $price = $_POST['price'];
    $qty = $_POST['qty'];
    $detail = $_POST['detail'];
    $item->setCode($code);
    $item->setName($name);
    $item->setPrice($price);
    $item->setQty($qty);
    $item->setDetail($detail);
    $result = $dao->updateItem($bcode, $item);
} catch (Exception $e) {
    $error = $e->getMessage();
}
header('Content-Type: text/html; charset=utf-8');
?>
<!DOCTYPE html>
<html>
<head>
<script type="text/javascript"
	src="../javascript/jquery/jquery-2.1.4.js"></script>