public static function getTableInstance()
{
if (!self::$_table) {
self::$_table = new Model_Table_EntityActivities();
}
return self::$_table;
}
/**
* Edit IEC form
*/
public function editiecAction()
{
$entity_categories = Model_EntityCategories::getAllCategories();
$this->view->entity_categories = $entity_categories;
$entity_activities = Model_EntityActivities::getAllActivities();
$this->view->entity_activities = $entity_activities;
$states = Model_States::getAllStates();
$this->view->states = $states;
$this->view->financial_years = self::generateLastFinancialYears();
//displays IEC details
if (isset($_GET['id']) && !empty($_GET['id'])) {
$iec_info = Model_EntityIecinfo::getEntityInfobyId($_GET['id'])->toArray();
$category = Model_EntityCategories::getCategoryById($iec_info['category'])->toArray();
$iec_bank_details = Model_EntityBankDetails::getBankDetailsByIecId($_GET['id']);
if (!empty($iec_bank_details)) {
$this->view->iec_bank_details = $iec_bank_details->toArray();
}
$iec_financial_details = Model_FinancialDetails::getFinancialDetailsByIecId($_GET['id']);
if (!empty($iec_financial_details)) {
$this->view->iec_turnover_details = $iec_financial_details->toArray();
}
$iec_details = Model_EntityDetails::getIecDetailsByIecId($_GET['id']);
if (!empty($iec_details)) {
$iec_branches = array();
$iec_category_details = array();
$iec_details_array = $iec_details->toArray();
$i = 0;
$j = 0;
foreach ($iec_details_array as $iec_detail) {
if ($iec_detail['entity_category_id'] == 0) {
$iec_branches[$i] = $iec_detail;
if (!empty($iec_detail['state'])) {
$iec_branches[$i]['districts'] = Model_Districts::getByStateId($iec_detail['state'])->toArray();
$iec_branches[$i]['cities'] = Model_Cities::getByDistrictId($iec_detail['district'])->toArray();
}
$i++;
} else {
$iec_category_details[$category['classname']][$j] = $iec_detail;
if (!empty($iec_detail['state'])) {
$iec_category_details[$category['classname']][$j]['districts'] = Model_Districts::getByStateId($iec_detail['state'])->toArray();
$iec_category_details[$category['classname']][$j]['cities'] = Model_Cities::getByDistrictId($iec_detail['district'])->toArray();
}
$j++;
}
}
}
$this->view->iec_info = $iec_info;
$this->view->iec_branches = $iec_branches;
$this->view->iec_category_details = $iec_category_details;
/*
echo '<pre>';
echo 'IEC INFO ';
print_r($iec_info);
echo 'IEC BRANCHES ';
print_r($iec_branches);
echo 'IEC CATEGORY ';
print_r($iec_category_details);
echo 'TURN OVER DETAILS ';
print_r($this->view->iec_turnover_details);
echo '</pre>';*/
$districts = Model_Districts::getByStateId($iec_info['state']);
$this->view->districts = $districts;
$cities = Model_Cities::getByDistrictId($iec_info['district']);
$this->view->cities = $cities;
}
//Update action for IEC details
if (isset($_POST['submitform']) && $_POST['submitform'] == 'Submit Form' || isset($_POST['saveform']) && $_POST['saveform'] == 'Save Form') {
//$this->validationForm($_POST);
$iec_id = $_POST['iec_id'];
$entity_iec_info = array();
$bank_details = array();
$branch_details = array();
$entity_details = array();
//arranging total branches
$total_branches = $_POST['entity']['total_branches'];
if ($total_branches >= 1) {
$branch_details = $_POST['branch'];
}
//entity activities
if (!empty($_POST['entity']['activities'])) {
$_POST['entity']['activities'] = implode(",", $_POST['entity']['activities']);
}
//if entity is proprietor firm
if (isset($_POST['prop']) && !empty($_POST['prop'])) {
$_POST['prop']['entity_category_id'] = $_POST['entity']['category'];
$entity_details[] = $_POST['prop'];
}
//if entity is partnership firm;
if (isset($_POST['entity_partnership']) && !empty($_POST['entity_partnership'])) {
$_POST['entity']['pan_name_entity'] = $_POST['entity_partnership']['pan_name_entity'];
$_POST['entity']['incorporation_date'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity_partnership']['incorporation_date']}")->format('Y-m-d');
$_POST['entity']['pan_entity'] = $_POST['entity_partnership']['pan_entity'];
$_POST['entity']['total_partners'] = $_POST['entity_partnership']['total_partners'];
if ($_POST['entity']['total_partners'] >= 1) {
$entity_details = $_POST['entity_partnership']['partners'];
}
}
//if entity is private firm;
if (isset($_POST['entity_privateltd']) && !empty($_POST['entity_privateltd'])) {
$_POST['entity']['pan_name_entity'] = $_POST['entity_privateltd']['pan_name_entity'];
$_POST['entity']['incorporation_date'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity_privateltd']['incorporation_date']}")->format('Y-m-d');
$_POST['entity']['pan_entity'] = $_POST['entity_privateltd']['pan_entity'];
$_POST['entity']['llpin_cin'] = $_POST['entity_privateltd']['llpin_cin'];
$_POST['entity']['registration_cert_number'] = $_POST['entity_privateltd']['registration_cert_number'];
$_POST['entity']['total_partners'] = $_POST['entity_privateltd']['total_partners'];
if ($_POST['entity']['total_partners'] >= 1) {
$entity_details = $_POST['entity_privateltd']['partners'];
}
}
//if entity is society
if (isset($_POST['entity_society']) && !empty($_POST['entity_society'])) {
$_POST['entity']['pan_name_entity'] = $_POST['entity_society']['pan_name_entity'];
$_POST['entity']['incorporation_date'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity_society']['incorporation_date']}")->format('Y-m-d');
$_POST['entity']['pan_entity'] = $_POST['entity_society']['pan_entity'];
$_POST['entity']['registration_cert_number'] = $_POST['entity_society']['registration_cert_number'];
if (!empty($_POST['entity_society']['trustee'])) {
$entity_details[] = $_POST['entity_society']['trustee'];
}
}
//if entity is huf
if (isset($_POST['entity_huf']) && !empty($_POST['entity_huf'])) {
$_POST['entity']['pan_name_entity'] = $_POST['entity_huf']['pan_name_entity'];
$_POST['entity']['incorporation_date'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity_huf']['incorporation_date']}")->format('Y-m-d');
$_POST['entity']['pan_entity'] = $_POST['entity_huf']['pan_entity'];
if (!empty($_POST['entity_huf']['karta'])) {
$entity_details[] = $_POST['entity_huf']['karta'];
}
}
if (isset($_POST['turnover_details']) && !empty($_POST['turnover_details'])) {
}
!empty($_POST['entity']['imr_doi']) ? $_POST['entity']['imr_doi'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity']['imr_doi']}")->format('Y-m-d') : '0000-00-00';
!empty($_POST['entity']['imr_validity']) ? $_POST['entity']['imr_validity'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity']['imr_validity']}")->format('Y-m-d') : '0000-00-00';
!empty($_POST['entity']['rcmc_doi']) ? $_POST['entity']['rcmc_doi'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity']['rcmc_doi']}")->format('Y-m-d') : '0000-00-00';
!empty($_POST['entity']['rcmc_validity']) ? $_POST['entity']['rcmc_validity'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity']['rcmc_validity']}")->format('Y-m-d') : '0000-00-00';
!empty($_POST['entity']['shd_doi']) ? $_POST['entity']['shd_doi'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity']['shd_doi']}")->format('Y-m-d') : '0000-00-00';
!empty($_POST['entity']['shd_validity']) ? $_POST['entity']['shd_validity'] = DateTime::createFromFormat("d/m/Y", "{$_POST['entity']['shd_validity']}")->format('Y-m-d') : '0000-00-00';
!empty($_POST['entity']['proof_of_accept']) && $_POST['entity']['proof_of_accept'] == 'on' ? $_POST['entity']['proof_of_accept'] = 1 : ($_POST['entity']['proof_of_accept'] = 0);
$_POST['entity']['updated_on'] = date("Y-m-d H:i:s");
$_POST['entity']['last_updated_by'] = $this->_session->user->user_id;
if (isset($_POST['saveform']) && $_POST['saveform'] == 'Save Form') {
$_POST['entity']['status'] = '6';
} else {
$_POST['entity']['status'] = '1';
}
//print_r($_POST['turnover_details']);exit;
try {
//update the entity_iec_info table
Model_EntityIecInfo::updateIecForm($_POST['entity'], $iec_id);
if (!empty($_POST['bank'])) {
$_POST['bank']['entity_iec_id'] = $iec_id;
Model_EntityBankDetails::updateBankDetails($_POST['bank'], $iec_id);
}
if (!empty($branch_details)) {
Model_EntityDetails::updateEntityDetails($branch_details, 0, $iec_id);
}
if (!empty($entity_details)) {
Model_EntityDetails::updateEntityDetails($entity_details, $_POST['entity']['category'], $iec_id);
}
if (!empty($_POST['turnover_details'])) {
Model_FinancialDetails::updateFinancialDetails($_POST['turnover_details'], $iec_id);
}
if (isset($_FILES['user_image_file']) && !empty($_FILES['user_image_file']['name'])) {
$target_filename = $iec_id . basename($_FILES["user_image_file"]["name"]);
if (move_uploaded_file($_FILES["user_image_file"]["tmp_name"], "user_images/" . $target_filename)) {
Model_EntityIecInfo::updateImageInIecForm($iec_id, $target_filename);
} else {
$error .= "Sorry, there was an error uploading your file.<br/>";
}
}
} catch (Exception $e) {
$error .= $e->getMessage();
}
if ($error) {
$response['status'] = 0;
$response['message'] = $error;
$this->flashMessenger->addMessage($response);
} else {
$response['status'] = 1;
$response['message'] = 'Updated Successfully';
$this->flashMessenger->addMessage($response);
}
$this->redirect('/iec/index');
}
}