public function executeList()
{
$this->returnModule = 'opname';
$this->returnAction = 'list';
$code = trim($this->getRequestParameter('code'));
if ($code != null && $code != '') {
$c = new Criteria();
$c->add(ColItemPeer::INDEX_NO, $code);
$ci = ColItemPeer::doSelectOne($c);
if ($code != null && $code != '' && $ci != null) {
$this->item = $ci;
$this->_title = 'Stock Opname Koleksi';
$this->setTemplate('order');
} else {
$this->getRequest()->setParameter('code', '');
$this->err_title = 'ERROR_IN_CHECK_OUT';
$this->err_msg = 'ITEM_NOT_FOUND';
}
}
}
public function executeDelete()
{
$catalog = CatalogPeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($catalog);
$c = new Criteria();
$c->add(CatalogEmployeePeer::CATALOG_ID, $catalog->getId());
$ce = CatalogEmployeePeer::doSelectOne($c);
$cw = new Criteria();
$cw->add(ColItemPeer::CATALOG_ID, $catalog->getId());
$ci = ColItemPeer::doSelectOne($cw);
$ce->delete();
$ci->delete();
$catalog->delete();
return $this->redirect('employee_bank/list');
}
public function executeReturn()
{
$this->returnModule = 'visitor_list';
$this->returnAction = 'return';
$member = MemberPeer::retrieveByPk($this->getRequestParameter('member_id'));
$this->forward404Unless($member);
$this->member = $member;
$actions2 = array(array('name' => '<span>Pengembalian Buku</span>', 'url' => 'visitor_list/return?member_id=' . $member->getId(), 'color' => 'sun', 'type' => 'direct'));
array_unshift($actions2, array('name' => '<span>Daftar Kunjungan</span>', 'url' => 'visitor_list/list', 'color' => 'sky'));
$this->actions2 = $actions2;
$code = trim($this->getRequestParameter('code'));
if ($code != null && $code != '') {
$c = new Criteria();
$c->add(ColItemPeer::INDEX_NO, $code);
$ci = ColItemPeer::doSelectOne($c);
if ($code != null && $code != '' && $ci != null) {
$c = new Criteria();
$c->addJoin(CirHistoryPeer::COL_ITEM_ID, ColItemPeer::ID);
$c->add(ColItemPeer::INDEX_NO, $code);
$c->addDescendingOrderByColumn(CirHistoryPeer::ORDER_DATE);
$c->setLimit(1);
$ch = CirHistoryPeer::doSelectOne($c);
if ($ch && $ch->getReturnDate() == null && $ch->getReturnDate() == '') {
$this->member_id = $ch->getMemberId();
$this->item = $ch->getColItem();
$this->member = $ch->getMember();
$this->returnOder = true;
$this->_title = 'ReturnOrder';
$this->setTemplate('retorder');
} else {
$this->getRequest()->setParameter('code', '');
$this->err_title = 'ERROR_IN_CHECK_OUT';
$this->err_msg = 'CO_ITEM_NOT_FOUND';
}
} else {
$this->getRequest()->setParameter('code', '');
$this->err_title = 'ERROR_IN_CHECK_OUT';
$this->err_msg = 'ITEM_NOT_FOUND';
}
}
}
public function executeReturn()
{
$member_code = trim($this->getRequestParameter('member_code'));
$this->returnModule = 'col_item';
$this->returnAction = 'return';
$this->getMember = false;
$this->returnOrder = false;
$this->max_loan_limit = false;
$this->can_loan = false;
if ($member_code != null && $member_code != '') {
$ci_id = $this->getRequestParameter('col_item_id');
$ci = ColItemPeer::retrieveByPk($ci_id);
$this->forward404Unless($ci);
$this->item = $ci;
#$member = MemberPeer::doSelectByCode($this->getRequestParameter('member_code'));
$member = MemberPeer::retrieveByCode($member_code);
$this->forward404Unless($member);
$this->member = $member;
$c = new Criteria();
$dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo');
$c->add(CirRegulationPeer::DEPARTMENT_ID, $dept->getChildRecurs(), Criteria::IN);
$c->add(CirRegulationPeer::MEMBER_TYPE_ID, $member->getType());
$c->add(CirRegulationPeer::CAT_CATEGORY_ID, $ci->getCatalog()->getCatCategoryId());
$regulation = CirRegulationPeer::doSelectOne($c);
$this->forward404Unless($regulation);
if ($regulation->getCanLoan() === true) {
$this->can_loan = true;
}
$c = new Criteria();
$c->add(CirHistoryPeer::MEMBER_ID, $member->getId());
$c->add(CirHistoryPeer::RETURN_DATE, null);
$c->addJoin(CirHistoryPeer::COL_ITEM_ID, ColItemPeer::ID);
$c->addJoin(ColItemPeer::CATALOG_ID, CatalogPeer::ID);
$c->add(CatalogPeer::CAT_CATEGORY_ID, $regulation->getCatCategoryId());
$cir_hist_array = CirHistoryPeer::doSelect($c);
if ($regulation->getMaxLoan() <= count($cir_hist_array)) {
$this->max_loan_limit = true;
}
$this->_title = 'LoanOrder';
$this->setTemplate('order');
} else {
$code = trim($this->getRequestParameter('code'));
// $index = preg_replace('/(.+-)/', '', $code);
// $cat_code = preg_replace('/(-\d+$)/', '', $code);
// if ($index != null && $index != '' && $cat_code != null && $cat_code != '') {
if ($code != null && $code != '') {
$c = new Criteria();
$c->add(ColItemPeer::INDEX_NO, $code);
// $c->addJoin(ColItemPeer::CATALOG_ID, CatalogPeer::ID);
$ci = ColItemPeer::doSelectOne($c);
if ($code != null && $code != '' && $ci != null) {
$c = new Criteria();
$c->addJoin(CirHistoryPeer::COL_ITEM_ID, ColItemPeer::ID);
$c->add(ColItemPeer::INDEX_NO, $code);
$c->addDescendingOrderByColumn(CirHistoryPeer::ORDER_DATE);
$c->setLimit(1);
$ch = CirHistoryPeer::doSelectOne($c);
if ($ch && $ch->getReturnDate() == null && $ch->getReturnDate() == '') {
$this->member_id = $ch->getMemberId();
$this->item = $ch->getColItem();
$this->member = $ch->getMember();
$this->returnOder = true;
$this->_title = 'ReturnOrder';
$this->setTemplate('order');
} else {
$this->getRequest()->setParameter('code', '');
$this->err_title = 'ERROR_IN_CHECK_OUT';
$this->err_msg = 'CO_ITEM_NOT_FOUND';
// $this->getMember = true;
// $this->id = $ci->getId();
}
} else {
$this->getRequest()->setParameter('code', '');
$this->err_title = 'ERROR_IN_CHECK_OUT';
$this->err_msg = 'ITEM_NOT_FOUND';
}
}
}
}
public function addCopies($action)
{
$copies = $action->getRequestParameter('copies');
if (is_numeric($copies)) {
for ($i = 1; $i < $copies + 1; $i++) {
$c = new Criteria();
$c->add(ColItemPeer::CALL_NO, $this->getCode() . '-' . $i);
$col_item = ColItemPeer::doSelectOne($c);
if ($col_item) {
++$copies;
continue;
} else {
$ci = new ColItem();
$ci->setCatalog($this);
$ci->setCallNo($this->getCode());
$ci->setIndexNo($this->getCode() . '-' . $i);
$ci->setColConditionId(1);
$ci->setColStatusId(1);
$ci->save();
}
}
}
$this->save();
}
public function executeSimpan()
{
$i18n = new sfI18N();
$i18n->initialize($this->getContext());
$i18n->setCulture($this->getUser()->getCulture());
$action_i18n = $i18n->globalMessageFormat->format('save as new');
$action_edit_i18n = $i18n->globalMessageFormat->format('edit');
$action_type = $this->getRequestParameter('action_type');
if ($action_type == $action_i18n || !$this->getRequestParameter('id', 0)) {
$catalog = new Catalog();
} else {
$catalog = CatalogPeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($catalog);
}
$catalog->setId($this->getRequestParameter('id'));
$catalog->setCatLanguageId(1);
$catalog->setCatCategoryId(15);
$catalog->setCatSubjectId(4202);
$catalog->setTitle($this->getRequestParameter('title'));
$catalog->setPublishedYear(2011);
$catalog->setPublishedLocation('Jakarta');
$catalog->setSynopsis($this->getRequestParameter('synopsis'));
$catalog->setSearchKeywords($this->getRequestParameter('search_keywords'));
$catalog->setPublisherId(8682);
$catalog->save();
$cw = new CatalogWriter();
$cw->setCatalog($catalog);
$cw->setWriterId(8112);
$cw->save();
$writer_name = $catalog->getFirstWriterName();
$writer_name = preg_replace('/\\W+/', '', $writer_name);
$writer_name = strtoupper(substr($writer_name, 0, 3));
$title = substr(strtoupper(str_replace(' ', '', $catalog->getTitle())), 0, 3);
$subject_code = $catalog->getCatSubject()->getCode();
$catalog->setCode("{$subject_code}-{$writer_name}-{$title}");
$catalog->save();
if ($this->hasRequestParameter('copies') && $this->getRequestParameter('copies') > 0) {
$catalog->addCopies($this);
}
$cover_dir = sfConfig::get('sf_data_dir') . DIRECTORY_SEPARATOR . 'photos' . DIRECTORY_SEPARATOR;
if ($this->hasRequestParameter('coverFile') && $this->getRequestParameter('coverFile') != '' && $this->getRequestParameter('coverFile') != null) {
// get cover content
$cover_file = $cover_dir . 'tmp' . DIRECTORY_SEPARATOR . $this->getRequestParameter('coverFile');
$content = file_get_contents($cover_file);
$im = imagecreatefromstring($content);
list($w, $h) = getimagesize($cover_file);
// generate cover
$cover = imagecreatetruecolor(150, 200);
imagecopyresized($cover, $im, 0, 0, 0, 0, 150, 200, $w, $h);
// generate thumbnail
$thumb = imagecreatetruecolor(100, 150);
imagecopyresized($thumb, $im, 0, 0, 0, 0, 100, 150, $w, $h);
// get cover record
$c = new Criteria();
$c->add(CatalogCopiedPeer::CATALOG_ID, $catalog->getId());
$catalog_cover = CatalogCopiedPeer::doSelectOne($c);
if ($catalog_cover == null) {
$catalog_cover = new CatalogCopied();
$catalog_cover->setCatalog($catalog);
}
// save cover
imagepng($cover, $cover_file);
$catalog_cover->setCover(base64_encode(file_get_contents($cover_file)));
imagepng($thumb, $cover_file);
$catalog_cover->setThumbnail(base64_encode(file_get_contents($cover_file)));
$catalog_cover->save();
unlink($cover_dir . 'tmp' . DIRECTORY_SEPARATOR . $this->getRequestParameter('coverFile'));
}
if ($this->hasRequestParameter('file') && $this->getRequestParameter('file') != '' && $this->getRequestParameter('file') != null) {
$fileName = $this->getRequestParameter('file');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_1') && $this->getRequestParameter('file_1') != '' && $this->getRequestParameter('file_1') != null) {
$fileName = $this->getRequestParameter('file_1');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_2') && $this->getRequestParameter('file_2') != '' && $this->getRequestParameter('file_2') != null) {
$fileName = $this->getRequestParameter('file_2');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_3') && $this->getRequestParameter('file_3') != '' && $this->getRequestParameter('file_3') != null) {
$fileName = $this->getRequestParameter('file_3');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_4') && $this->getRequestParameter('file_4') != '' && $this->getRequestParameter('file_4') != null) {
$fileName = $this->getRequestParameter('file_4');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_5') && $this->getRequestParameter('file_5') != '' && $this->getRequestParameter('file_5') != null) {
$fileName = $this->getRequestParameter('file_5');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_6') && $this->getRequestParameter('file_6') != '' && $this->getRequestParameter('file_6') != null) {
$fileName = $this->getRequestParameter('file_6');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_7') && $this->getRequestParameter('file_7') != '' && $this->getRequestParameter('file_7') != null) {
$fileName = $this->getRequestParameter('file_7');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_8') && $this->getRequestParameter('file_8') != '' && $this->getRequestParameter('file_8') != null) {
$fileName = $this->getRequestParameter('file_8');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_9') && $this->getRequestParameter('file_9') != '' && $this->getRequestParameter('file_9') != null) {
$fileName = $this->getRequestParameter('file_9');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
if ($this->hasRequestParameter('file_10') && $this->getRequestParameter('file_10') != '' && $this->getRequestParameter('file_10') != null) {
$fileName = $this->getRequestParameter('file_10');
$catalog_file = new CatalogFile();
$catalog_file->setCatalog($catalog);
$catalog_file->setFile($fileName);
$catalog_file->save();
}
$dept_id = $this->getContext()->getUser()->getAttribute('department_id', null, 'bo');
$dept = $this->getContext()->getUser()->getAttribute('department', null, 'bo');
if ($dept_id == 2) {
$c = new Criteria();
$c->add(ColItemPeer::CATALOG_ID, $catalog->getId());
$ci = ColItemPeer::doSelectOne($c);
$ci->setColLocationId(102);
$ci->save();
} elseif ($dept_id == 3) {
$c = new Criteria();
$c->add(ColItemPeer::CATALOG_ID, $catalog->getId());
$ci = ColItemPeer::doSelectOne($c);
$ci->setColLocationId(103);
$ci->save();
} else {
$c = new Criteria();
$c->add(ColItemPeer::CATALOG_ID, $catalog->getId());
$ci = ColItemPeer::doSelectOne($c);
$ci->setColLocationId(104);
$ci->save();
}
return $this->redirect('catalog/listBank');
}
