public function createForm($id_hopdong)
{
$kh = new Model_Hopdong();
$hopdong = $kh->getWhereIdHopDong($id_hopdong);
$this->setDisableLoadDefaultDecorators(true);
$this->setDecorators(array(array('ViewScript', array('viewScript' => 'formnoindex/hopdong_layout.phtml')), 'Form'));
$data = new My_Data();
$opMau = $data->getOptionMau();
$opLoaiVai = $data->getOptionLoaiVai();
$opNCC = $data->getOptionNCC();
$tenhopdong = $this->createElement('text', 'tenhopdong', array('decorators' => array('ViewHelper')));
$mota = $this->createElement('text', 'mota', array('decorators' => array('ViewHelper')));
$ngayky = $this->createElement('text', 'ngayky', array('decorators' => array('ViewHelper')));
$sotansoi = $this->createElement('text', 'sotansoi', array('decorators' => array('ViewHelper')));
$thanhtien = $this->createElement('text', 'thanhtien', array('decorators' => array('ViewHelper')));
$mamau = $this->createElement('select', 'mamau', array('multioptions' => $opMau, 'decorators' => array('ViewHelper')));
$maloaivai = $this->createElement('select', 'maloaivai', array('multioptions' => $opLoaiVai, 'decorators' => array('ViewHelper')));
$manhacungcap = $this->createElement('select', 'manhacungcap', array('multioptions' => $opNCC, 'decorators' => array('ViewHelper')));
$them = $this->createElement('submit', 'them', array('decorators' => array('ViewHelper'), 'label' => 'Chỉnh sửa'));
$mydate = Zend_Locale_Format::getDate($hopdong['NgayKy'], array("date_format" => "yyyy.MM.dd"));
$date_str = $mydate['day'] . "/" . $mydate['month'] . "/" . $mydate['year'];
$tenhopdong->setAttrib('class', 'formEdit')->setValue($hopdong['TenHopDong']);
$mota->setAttrib('class', 'formEdit')->setValue($hopdong['MoTa']);
$ngayky->setAttrib('class', 'formEdit')->setValue($date_str);
$sotansoi->setAttrib('class', 'formEdit')->setValue($hopdong['SoTanSoi']);
$thanhtien->setAttrib('class', 'formEdit')->setValue($hopdong['ThanhTien']);
$mamau->setAttrib('class', 'formEdit')->setValue($hopdong['MaMau']);
$maloaivai->setAttrib('class', 'formEdit')->setValue($hopdong['MaLoaiVai']);
$manhacungcap->setAttrib('class', 'formEdit')->setValue($hopdong['MaNhaCungCap']);
$this->addElement($tenhopdong)->addElement($mota)->addElement($ngayky)->addElement($sotansoi)->addElement($thanhtien)->addElement($mamau)->addElement($maloaivai)->addElement($manhacungcap)->addElement($them);
}
<?php
echo $this->headMeta();
echo $this->headLink();
$dx = new Model_Donxuat();
$donxuatall = $dx->getAll();
if ($donxuatall) {
$maincontent = array();
$title = array("Tên Đơn Xuất", "Ngày Xuất", "Thuộc Hợp Đồng", "Tùy Chỉnh");
$data = new My_Data();
foreach ($donxuatall as $donxuat) {
$mydate = Zend_Locale_Format::getDate($donxuat['NgayXuat'], array("date_format" => "yyyy.MM.dd"));
$date_str = $mydate['day'] . "/" . $mydate['month'] . "/" . $mydate['year'];
$hd = new Model_Hopdong();
$myhopdong = $hd->getWhereIdHopDong($donxuat['MaHopDong']);
$tendonxuat = "<a href='" . HOST_PROJECT . "/index/main/hopdong_detail/true/mahopdong/" . $myhopdong['MaHopDong'] . "/right/donxuat/madonxuat/" . $donxuat['MaDonXuat'] . "/'>" . $donxuat['TenDonXuat'] . "</a>";
$content = array($tendonxuat, $date_str, $myhopdong['TenHopDong'], '<a href="' . HOST_PROJECT . "/index/chinhsua/donxuat/true/madonxuat/" . $donxuat['MaDonXuat'] . '/option/donxuat/">Sửa</a> | ' . '<a href="' . HOST_PROJECT . "/index/xoa/donxuat/true/mahopdong/" . $myhopdong['TenHopDong'] . "/madonxuat/" . $donxuat['MaDonXuat'] . '/option/donxuat/" onclick="return confirm(' . "'bạn có chắc muốn xóa ?'" . ')">Xóa</a>');
$maincontent[] = $content;
}
$table = $data->createTable($title, $maincontent, "600px");
echo $table;
} else {
echo "<div class='message'>";
echo "Chưa tồn tại Đơn Xuất";
echo "</div>";
}
<?php
echo $this->headMeta();
echo $this->headLink();
$id_hopdong = $this->param->getParam('mahopdong');
$fupdate = new Form_Update_Hopdong();
$fupdate->createForm($id_hopdong);
if ($this->param->isPost()) {
$param = $this->param->getPost();
$check = new Form_Valid_Hopdong($param);
if ($check->valid($param)) {
$mydate = Zend_Locale_Format::getDate($this->param->getParam("ngayky"), array("date_format" => "dd.MM.yyyy"));
$date_str = $mydate['year'] . "-" . $mydate['month'] . "-" . $mydate['day'];
$data = array("MaHopDong" => $id_hopdong, "TenHopDong" => $this->param->getParam("tenhopdong"), "MoTa" => $this->param->getParam("mota"), "NgayKy" => $date_str, "SoTanSoi" => $this->param->getParam("sotansoi"), "ThanhTien" => $this->param->getParam("thanhtien"), "MaMau" => $this->param->getParam("mamau"), "MaLoaiVai" => $this->param->getParam("maloaivai"), "MaNhaCungCap" => $this->param->getParam("manhacungcap"));
$dh = new Model_Hopdong();
$dh->update_data($id_hopdong, $data);
if (array_key_exists('option', $this->param->getParams())) {
echo "<script>window.location.href='" . HOST_PROJECT . "/index/xem/hopdong/true';</script>";
} else {
echo "<script>window.location.href='" . HOST_PROJECT . "/index/main/hopdong_detail/true/mahopdong/" . $this->param->getParam('mahopdong') . "/';</script>";
}
} else {
echo $fupdate;
echo "<div class='message'>";
foreach ($check->messages as $item) {
echo $item . "<br/>";
}
echo "</div>";
}
} else {
echo $fupdate;
<?php
echo $this->headMeta();
echo $this->headLink();
$hd = new Model_Hopdong();
$hopdongall = $hd->getAll();
$data = new My_Data();
if ($hopdongall) {
$maincontent = array();
$data = new My_Data();
$title = array("Mã Hợp Đồng", "Số Tấn Sợi", "Thành Tiền", "Ngày Ký", "Loại Sợi", "Kho Sợi", "Nhà Cung Cấp", "Tùy Chỉnh", "Nhập Kho");
foreach ($hopdongall as $hopdong) {
$mydate = Zend_Locale_Format::getDate($hopdong['NgayMua'], array("date_format" => "yyyy.MM.dd"));
$date_str = $mydate['day'] . "/" . $mydate['month'] . "/" . $mydate['year'];
$op = $data->getOpHopdong($hopdong['MaSoi'], $hopdong['MaKho'], $hopdong['MaNhaCungCap']);
$button = "<a class ='thembutton' href='" . HOST_PROJECT . "/index/nhaplieu/nhapsoi/true/mahopdong/" . $hopdong['MaHopDong'] . "'/>Nhập Kho</a>";
$chinhsua = '<a href="' . HOST_PROJECT . "/index/chinhsua/hopdong/true/mahopdong/" . $hopdong['MaHopDong'] . '/option/hopdong/">Sửa</a> | ' . '<a href="' . HOST_PROJECT . "/index/xoa/hopdong/true/mahopdong/" . $hopdong['MaHopDong'] . '/option/xem/" onclick="return confirm(' . "'bạn có chắc muốn xóa ?'" . ')">Xóa</a>';
$nhapkho = "";
if ($hopdong['TrangThai'] == 1) {
$nhapkho = "Đã Nhập";
} else {
$nhapkho = $button;
}
$content = array($hopdong['MaHopDong'], $hopdong['SoTanSoi'], $hopdong['ThanhTien'], $date_str, $op['tensoi'], $op['tenkho'], $op['tenncc'], $chinhsua, $nhapkho);
$maincontent[] = $content;
}
$table = $data->createTable($title, $maincontent, "1100px");
echo $table;
} else {
echo "<div class='message'>";
echo "Chưa tồn tại Hợp Đồng";
<?php
echo $this->headMeta();
echo $this->headLink();
$mancc = $this->param->getParam('mancc');
$hd = new Model_Hopdong();
$hopdong = $hd->getWhere_ncc($mancc);
if ($hopdong) {
echo "<div class='long_message'>";
echo "Không thể xóa Nhà Cung Cấp đã ký hợp đồng!";
echo "</div>";
} else {
$ncc = new Model_Nhacungcap();
$ncc->delete_nhacungcap($mancc);
echo "<script>window.location.href='" . HOST_PROJECT . "/index/xem/nhacungcap/true';</script>";
}
public function getNameKhachHang($mahopdong)
{
$hd = new Model_Hopdong();
$hopdong = $hd->getWhereIdHopDong($mahopdong);
$madonhang = $hopdong['MaDonHang'];
$dh = new Model_Donhang();
$donhang = $dh->getWhere($madonhang);
$kh = new Model_Khachhang();
$khachhang = $kh->getWhere($donhang['MaKhachHang'])[0];
return $khachhang['TenKhachHang'];
}
<?php
echo $this->headMeta();
echo $this->headLink();
$form = new Form_Searchs_Hopdong();
echo $form;
if ($this->param->isPost()) {
$model = new Model_Hopdong();
$data = new My_Data();
$key = $this->param->getParam("key");
$hopdongs = $model->searchByKey($key);
if ($hopdongs != false) {
$title = array("Mã Hợp Đồng", "Số Tấn Sợi", "Thành Tiền", "Ngày Ký", "Loại Sợi", "Kho Sợi", "Nhà Cung Cấp", "Tùy Chỉnh", "Nhập Kho");
$maincontent = array();
foreach ($hopdongs as $hopdong) {
$mydate = Zend_Locale_Format::getDate($hopdong['NgayMua'], array("date_format" => "yyyy.MM.dd"));
$date_str = $mydate['day'] . "/" . $mydate['month'] . "/" . $mydate['year'];
$op = $data->getOpHopdong($hopdong['MaSoi'], $hopdong['MaKho'], $hopdong['MaNhaCungCap']);
$button = "<a class ='thembutton' href='" . HOST_PROJECT . "/index/nhaplieu/nhapsoi/true/mahopdong/" . $hopdong['MaHopDong'] . "'/>Nhập Kho</a>";
$chinhsua = '<a href="' . HOST_PROJECT . "/index/chinhsua/hopdong/true/mahopdong/" . $hopdong['MaHopDong'] . '/option/hopdong/">Sửa</a> | ' . '<a href="' . HOST_PROJECT . "/index/xoa/hopdong/true/mahopdong/" . $hopdong['MaHopDong'] . '/option/xem/" onclick="return confirm(' . "'bạn có chắc muốn xóa ?'" . ')">Xóa</a>';
$nhapkho = "";
if ($hopdong['TrangThai'] == 1) {
$nhapkho = "Đã Nhập";
} else {
$nhapkho = $button;
}
$content = array($hopdong['MaHopDong'], $hopdong['SoTanSoi'], $hopdong['ThanhTien'], $date_str, $op['tensoi'], $op['tenkho'], $op['tenncc'], $chinhsua, $nhapkho);
$maincontent[] = $content;
}
$table = $data->createTable($title, $maincontent, "1100px");
echo $table;
<?php
echo $this->headMeta();
echo $this->headLink();
$id_hopdong = $this->param->getParam('mahopdong');
$cm = new Model_Caymoc();
$caymoc = $cm->getWhere_IdHopdong($id_hopdong);
if ($caymoc) {
echo "<div class='long_message'>";
echo "Không thể xóa Hợp Đồng đã tạo Cây Mộc !";
echo "</div>";
} else {
$hd = new Model_Hopdong();
$id_donhang = $hd->getWhereIdHopDong($id_hopdong)['MaDonHang'];
$dh = new Model_Donhang();
$id_khachhang = $dh->getWhere($id_donhang)['MaKhachHang'];
$hopdong = $hd->delete_hopdong($id_hopdong);
if (array_key_exists('option', $this->param->getParams())) {
echo "<script>window.location.href='" . HOST_PROJECT . "/index/xem/hopdong/true';</script>";
} else {
echo "<script>window.location.href='" . HOST_PROJECT . "/index/main/khachhang_detail/true/makhachhang/" . $id_khachhang . "/';</script>";
}
}
<?php
echo $this->headMeta();
echo $this->headLink();
$mamau = $this->param->getParam('mamau');
$hd = new Model_Hopdong();
$hopdong = $hd->getWhere_mau($mamau);
if ($hopdong) {
echo "<div class='long_message'>";
echo "Không thể xóa màu vải đã được dùng trong hợp đồng!";
echo "</div>";
} else {
$ln = new Model_Lonhuom();
$lonhuom = $ln->getWhere_mau($mamau);
if ($lonhuom) {
echo "<div class='long_message'>";
echo "Không thể xóa màu vải đã được dùng trong lô nhuộm!";
echo "</div>";
} else {
$mau = new Model_Mau();
$mau->delete_mau($mamau);
echo "<script>window.location.href='" . HOST_PROJECT . "/index/xem/mau/true';</script>";
}
}
<?php
echo $this->headMeta();
echo $this->headLink();
$form = new Form_Formmoi_MuaSoi();
if ($this->param->isPost()) {
$param = $this->param->getPost();
$check = new Form_Valid_Hopdong($param);
if ($check->valid($param)) {
$mydate = Zend_Locale_Format::getDate($this->param->getParam("ngaymua"), array("date_format" => "dd.MM.yyyy"));
$date_str = $mydate['year'] . "-" . $mydate['month'] . "-" . $mydate['day'];
$data = array("MaHopDong" => null, "SoTanSoi" => $this->param->getParam("sotansoi"), "ThanhTien" => $this->param->getParam("thanhtien"), "NgayMua" => $date_str, "MaSoi" => $this->param->getParam("loaisoi"), "MaKho" => $this->param->getParam("nhapkhosoi"), "MaNhaCungCap" => $this->param->getParam("nhacungcap"));
$hd = new Model_Hopdong();
$hd->insert_hopdong($data);
$_redirector = Zend_Controller_Action_HelperBroker::getStaticHelper('redirector');
$_redirector->gotoUrl(HOST_PROJECT . "/index/xem/hopdong/true/");
// update so no cho ncc
// $thanhtien = $this->param->getParam("thanhtien");
// $mancc = $this->param->getParam("manhacungcap");
// $ncc= new Model_Nhacungcap();
// $nhacungcap = $ncc->getWhere($mancc);
// $update = array('No'=>$nhacungcap['No']+$thanhtien);
// $ncc->update_data($mancc, $update);
// if(array_key_exists('congty',$this->param->getParams()))
// {
// $_redirector = Zend_Controller_Action_HelperBroker::getStaticHelper('redirector');
// $_redirector->gotoUrl(HOST_PROJECT."/index/main/congty/true");
// }
// else if(!array_key_exists('option',$this->param->getParams()))
// {
// $_redirector = Zend_Controller_Action_HelperBroker::getStaticHelper('redirector');
<?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);
<?php
echo $this->headMeta();
echo $this->headLink();
$id_donhang = $this->param->getParam('madonhang');
$id_khachhang = $this->param->getParam('makhachhang');
$hd = new Model_Hopdong();
$hopdong = $hd->getWhereIdDH($id_donhang);
if ($hopdong) {
echo "<div class='long_message'>";
echo "Không thể xóa Đơn Hàng đã tạo Hợp Đồng !";
echo "</div>";
} else {
$dh = new Model_Donhang();
$donhang = $dh->delete_donhang($id_donhang);
if (array_key_exists('option', $this->param->getParams())) {
echo "<script>window.location.href='" . HOST_PROJECT . "/index/xem/donhang/true';</script>";
} else {
echo "<script>window.location.href='" . HOST_PROJECT . "/index/main/khachhang_detail/true/makhachhang/" . $id_khachhang . "/';</script>";
}
}
