public function getNguyenLieu()
{
$lv = new Model_Loaivai();
$khosoi = new Model_Khosoi();
$makho = $khosoi->getIdKho();
// echo "<pre>";
// print_r($makho);
// echo "</pre>";
$option = array();
foreach ($makho as $item) {
$khohangrow = $khosoi->getWhere_khohang($item['MaKho']);
//1,5
$opsoi = array();
foreach ($khohangrow as $khitem) {
$opvai = array();
$loaivai = $lv->getWhere_loaisoi($khitem['MaSoi']);
foreach ($loaivai as $itemvai) {
$opvai[$itemvai['MaVai']] = $itemvai['TenLoaiVai'];
}
$opsoi[$khitem['MaSoi']] = $opvai;
}
$option[$item['MaKho']] = $opsoi;
}
return $option;
}
<?php
echo $this->headMeta();
echo $this->headLink();
$form = new Form_Formmoi_Xemkhosoi();
if ($this->param->isPost()) {
$param = $this->param->getPost();
$form->populate($param);
echo $form;
$makhohang = $this->param->getParam("mykhohang");
$khosoi = new Model_Khosoi();
$khosoiall = $khosoi->getWhere_khohang($makhohang);
$data = new My_Data();
$loaisoi = new Model_Loaisoi();
$title = array("Loại Sợi", "Số tấn sợi", "Chọn");
$content = array();
foreach ($khosoiall as $item) {
$button = "<a class ='thembutton' href='" . HOST_PROJECT . "/index/xem/caymoc/true/option/them/makhoisoi/" . $item['MaKhoSoi'] . "/'/>Chọn</a>";
$loaisoirow = $loaisoi->getWhere($item['MaSoi']);
$subcontent = array($loaisoirow['TenSoi'], $item['SoTanSoi'], $button);
$content[] = $subcontent;
}
$query = $data->createTable($title, $content, "300px");
?>
<h1 class="title">Chọn Nguyên Liệu</h1>
<?php
echo $query;
} else {
echo $form;
}
<?php
echo $this->headMeta();
echo $this->headLink();
$mamoc = $this->param->getParam('mamoc');
$caymoc = new Model_Caymoc();
$caymocrow = $caymoc->getWhere($mamoc);
$updatecm = array('TrangThai' => 1);
$caymoc->update_data($caymocrow['MaMoc'], $updatecm);
$khosoi = new Model_Khosoi();
$khosoirow = $khosoi->getWhere_khohang($caymocrow['MaKho']);
$loaivai = new Model_Loaivai();
$loaivairow = $loaivai->getWhere($caymocrow['MaVai']);
// $loaisoi = new Model_Loaisoi();
// $loaisoirow = $loaisoi->getWhere($loaivairow['MaSoi']);
// dung bien flag de kiem tra xem trong kho da co loai soi chua
$flag = false;
$row = array();
if ($khosoirow) {
foreach ($khosoirow as $item) {
if ($item['MaSoi'] == $loaivairow['MaSoi']) {
$flag = true;
$update = array('SoTanSoi' => $item['SoTanSoi'] + $caymocrow['SoKgSoi'] / 1000);
$khosoi->update_data($item['MaKhoSoi'], $update);
$_redirector = Zend_Controller_Action_HelperBroker::getStaticHelper('redirector');
$_redirector->gotoUrl(HOST_PROJECT . "/index/xem/caymoc/true");
}
}
}
<?php
echo $this->headMeta();
echo $this->headLink();
$mahopdong = $this->param->getParam('mahopdong');
$hopdong = new Model_Hopdong();
$myhopdong = $hopdong->getWhere($mahopdong);
$updatehd = array('TrangThai' => 1);
$hopdong->update_data($myhopdong['MaHopDong'], $updatehd);
$ncc = new Model_Nhacungcap();
$myncc = $ncc->getWhere($myhopdong['MaNhaCungCap']);
$update = array("No" => $myncc['No'] + $myhopdong['ThanhTien']);
$ncc->update_data($myncc['MaNhaCungCap'], $update);
$ks = new Model_Khosoi();
$khosoi = $ks->getWhere_khohang($myhopdong['MaKho']);
// dung bien flag de kiem tra xem trong kho da co loai soi chua
$flag = false;
$row = array();
if ($khosoi) {
foreach ($khosoi as $item) {
if ($item['MaSoi'] == $myhopdong['MaSoi']) {
$flag = true;
$update = array('SoTanSoi' => $item['SoTanSoi'] + $myhopdong['SoTanSoi']);
$ks->update_data($item['MaKhoSoi'], $update);
$_redirector = Zend_Controller_Action_HelperBroker::getStaticHelper('redirector');
$_redirector->gotoUrl(HOST_PROJECT . "/index/xem/hopdong/true");
}
}
}
$data = array("MaKhoSoi" => null, "MaSoi" => $myhopdong['MaSoi'], "SoTanSoi" => $myhopdong['SoTanSoi'], "MaKho" => $myhopdong['MaKho']);
$ks->insert_kho($data);
