public function addLog()
{
$data = $this->form_values;
// App_Controller_Functions::pr($data);
$name = $data['name'];
$father_name = $data['father_name'];
$age = $data['age'];
$contact = $data['contact'];
$address = $data['address'];
$district = $data['district'];
$uc = $data['uc'];
$item_id = $data['item_id'];
$dose_no = $data['dose_no'];
$vaccination_date = $data['vaccination_date'];
$reffers_to = $data['reffers_to'];
$remarks = $data['remarks'];
$user_id = $this->_user_id;
$warehouse_id = $this->_identity->getWarehouseId();
$date = date("Y-m-d h:i:s");
foreach ($district as $key => $val) {
if ($val != '' && $val >= 0) {
$log_book = new LogBook();
$log_book->setName($name[$key]);
$log_book->setFatherName($father_name[$key]);
$log_book->setAge($age[$key]);
$log_book->setContact($contact[$key]);
$log_book->setAddress($address[$key]);
$districtId = $this->_em->getRepository('Locations')->find($district[$key]);
$log_book->setDistrictId($districtId);
$ucId = $this->_em->getRepository('Locations')->find($uc[$key]);
$log_book->setUnionCouncilId($ucId);
$log_book->setVaccinationDate(new \DateTime(App_Controller_Functions::dateToDbFormat($vaccination_date[$key])));
$log_book->setRefferTo($reffers_to[$key]);
$log_book->setRemarks($remarks[$key]);
//
$warehouse = $this->_em->getRepository('Warehouses')->find($warehouse_id);
$log_book->setWarehouse($warehouse);
$log_book->setCreatedDate(new \DateTime(App_Controller_Functions::dateToDbFormat($date)));
$log_book->setCreatedBy($user_id);
$this->_em->persist($log_book);
$this->_em->flush();
$log_book_id = $log_book->getPkId();
foreach ($item_id as $key => $val) {
$log_book_item_doses = new LogBookItemDoses();
$logBook = $this->_em->getRepository('LogBook')->find($log_book_id);
$log_book_item_doses->setLogBookId($logBook);
$itemPack = $this->_em->getRepository('ItemPackSizes')->find($val);
$log_book_item_doses->setItemPackSize($itemPack);
$log_book_item_doses->setDoses($dose_no[$key]);
$this->_em->persist($log_book_item_doses);
$this->_em->flush();
}
}
}
}
public function addLogBook()
{
$data = $this->form_values;
$dose_no = $this->form_values['dose_no_of'];
$temp = $this->form_values['temp'];
$temp = base64_decode(substr($temp, 1, strlen($temp) - 1));
$temp = explode("|", $temp);
$warehouse_id = $temp[0];
//$loc_id = $temp[1];
$rpt_date = $temp[1];
$is_new_rpt = $temp[2];
$tt = explode("-", $rpt_date);
$yy = $tt[0];
$mm = $tt[1];
$dd = $tt[2];
$date = date("Y-m-d h:i:s");
$year_month = $yy . "-" . $mm;
$vaccination_date = $yy . "-" . $mm . "-" . $this->form_values['day'];
$user_id = $this->_user_id;
$log_book = new LogBook();
$log_book->setName($this->form_values['name']);
$log_book->setFatherName($this->form_values['father_name']);
$log_book->setAge($this->form_values['age']);
$log_book->setGender($this->form_values['gender']);
$log_book->setContact($this->form_values['contact']);
$log_book->setAddress($this->form_values['address']);
//$refer_to_warehouseId = $this->_em->getRepository('Warehouses')->find($this->form_values['refer_to']);
//$log_book->setReferToWarehouse($refer_to_warehouseId);
$districtId = $this->_em->getRepository('Locations')->find($this->form_values['district']);
$log_book->setDistrict($districtId);
if (!empty($this->form_values['uc'])) {
$log_book->setUnionCouncilId($this->form_values['uc']);
}
$log_book->setVaccinationDate(new \DateTime($vaccination_date));
//$log_book->setRefferTo(); //warehouseid from session
$log_book->setRemarks($this->form_values['remarks']);
$warehouse = $this->_em->getRepository('Warehouses')->find($warehouse_id);
$log_book->setWarehouse($warehouse);
$log_book->setCreatedDate(App_Tools_Time::now());
$log_book->setModifiedDate(App_Tools_Time::now());
$userId = $this->_em->getRepository('Users')->find($user_id);
$log_book->setCreatedBy($userId);
$log_book->setModifiedBy($userId);
$this->_em->persist($log_book);
$this->_em->flush();
$log_book_id = $log_book->getPkId();
foreach ($dose_no as $prodId => $value) {
if ($value == "") {
$value = NULL;
}
$log_book_item_doses = new LogBookItemDoses();
$logBook = $this->_em->getRepository('LogBook')->find($log_book_id);
$log_book_item_doses->setLogBook($logBook);
$itemPack = $this->_em->getRepository('ItemPackSizes')->find($prodId);
$log_book_item_doses->setItemPackSize($itemPack);
$log_book_item_doses->setDoses($value);
$user = $this->_em->getRepository('Users')->find($this->_user_id);
$log_book_item_doses->setModifiedBy($user);
$log_book_item_doses->setCreatedBy($user);
$log_book_item_doses->setCreatedDate(App_Tools_Time::now());
$log_book_item_doses->setModifiedDate(App_Tools_Time::now());
$this->_em->persist($log_book_item_doses);
$this->_em->flush();
}
}