public function campaignTargetImportAction() { $this->_helper->layout->disableLayout(); $this->_helper->viewRenderer->setNoRender(TRUE); $import_type = $this->_request->getPost('import_option'); if ($this->_request->isPost()) { if ($this->_request->getPost()) { if ($import_type == 'campaign') { $form_values = $this->_request->getPost(); $campaign_id = $form_values['campaign_import_hidden']; $campaign_target = new Model_CampaignTargets(); $campaign_target->form_values = $form_values; $data = $campaign_target->getCampaignTargets(); if (!empty($data)) { $campaign_target->form_values = $form_values; $campaign_target->deleteCampaignData(); } if (!empty($data)) { foreach ($data as $data1) { $campaign_target = new CampaignTargets(); $campaign_target->setDailyTarget($data1['dailyTarget']); $campaign_id_a = $this->_em->find('Campaigns', $campaign_id); $campaign_target->setCampaign($campaign_id_a); $warehouse_id_a = $this->_em->find('Warehouses', $data1['warehouseId']); $campaign_target->setWarehouse($warehouse_id_a); $item_id = $this->_em->find('ItemPackSizes', $data1['itemId']); $campaign_target->setItemPackSize($item_id); $created_by = $this->_em->find('Users', $this->_userid); $campaign_target->setCreatedBy($created_by); $campaign_target->setModifiedBy($created_by); $campaign_target->setCreatedDate(App_Tools_Time::now()); $campaign_target->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($campaign_target); $this->_em->flush(); } } } else { if ($import_type == 'csv') { $form_values = $this->_request->getPost(); $campaign_target = new Model_CampaignTargets(); $campaign_target->form_values = $form_values; $tempFileName = $_FILES['cvs_import']['tmp_name']; $i = 1; $error = ""; if (($handle = fopen($tempFileName, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $warehouse_name = $data[0]; $target1 = (int) $data[1]; $target = abs($target1); $campaign_target->form_values['warehouse_name'] = $warehouse_name; $res = $campaign_target->getOldCampaignTarget(); if (is_numeric($data[1])) { } else { $error .= "Import with Errors"; } if ($target != 0) { foreach ($res as $result) { if (!empty($result['pk_id'])) { // If data already exists then update // $campaign_target->updateCampaignTarget(); $cam_target = $this->_em->getRepository("CampaignTargets")->find($result['pk_id']); $cam_target->setDailyTarget($target); $created_by = $this->_em->find('Users', $this->_userid); $cam_target->setModifiedBy($created_by); $cam_target->setModifiedDate(App_Tools_Time::now()); $this->_em->persist($cam_target); $this->_em->flush(); } else { // If data not exists then Insert $camp_target = new CampaignTargets(); $campaign = $this->_em->find('Campaigns', $form_values['campaign_import_hidden']); $camp_target->setCampaign($campaign); $item = $this->_em->find('ItemPackSizes', $form_values['item_import_hidden']); $camp_target->setItemPackSize($item); $warehouse = $this->_em->find('Warehouses', $result['warehouse_id']); $camp_target->setWarehouse($warehouse); $camp_target->setDailyTarget($target); $created_by = $this->_em->find('Users', $this->_userid); $camp_target->setModifiedBy($created_by); $camp_target->setModifiedDate(App_Tools_Time::now()); $camp_target->setCreatedBy($created_by); $camp_target->setCreatedDate(App_Tools_Time::now()); $this->_em->persist($camp_target); $this->_em->flush(); } } $i++; } } } } } } } if (!empty($error)) { $success = 0; } else { $success = 1; } $this->_redirect("/campaign/manage-campaigns/campaigns-target?campaign_id={$form_values['campaign_import_hidden']}&district_id={$form_values['district_import_hidden']}&province_id={$form_values['province_import_hidden']}&item_id={$form_values['item_import_hidden']}&success={$success}"); }
public function setCreatedBy(\Users $createdBy) { $this->__load(); return parent::setCreatedBy($createdBy); }