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 getWarehouse()
 {
     $this->__load();
     return parent::getWarehouse();
 }