/**
*
* @param string $uid
* @return unknown|\Symfony\Component\HttpFoundation\RedirectResponse
*/
public function editPostAction($uid)
{
$urlFrom = $this->getReferer();
if (null == $urlFrom || trim($urlFrom) == '') {
$urlFrom = $this->generateUrl('_admin_company_list');
}
$em = $this->getEntityManager();
try {
$company = $em->getRepository('AcfDataBundle:Company')->find($uid);
if (null == $company) {
$this->flashMsgSession('warning', $this->translate('Company.edit.notfound'));
} else {
$sc = $this->getSecurityTokenStorage();
$ac = $this->getSecurityAuthorizationChecker();
$user = $sc->getToken()->getUser();
if ($ac->isGranted('ROLE_SUPERADMIN', $user)) {
$traces = $em->getRepository('AcfDataBundle:Trace')->getAllByCompany($company, true);
$this->gvars['traces'] = array_reverse($traces);
} else {
$traces = $em->getRepository('AcfDataBundle:Trace')->getAllByCompany($company, false);
$this->gvars['traces'] = array_reverse($traces);
}
$achatMarchNature = $em->getRepository('AcfDataBundle:CompanyNature')->findOneBy(array('company' => $company, 'label' => 'ACHATS DE MARCHANDISES'));
if (null == $achatMarchNature) {
$achatMarchNature = new CompanyNature();
$achatMarchNature->setCompany($company);
$achatMarchNature->setLabel('ACHATS DE MARCHANDISES');
$em->persist($achatMarchNature);
$em->flush();
}
$em->getRepository('AcfDataBundle:Buy')->updateCompanyNatureNullByCompany($company, $achatMarchNature);
$em->flush();
$companyUpdateTypeForm = $this->createForm(CompanyUpdateTypeTForm::class, $company);
$companyUpdateCorporateNameForm = $this->createForm(CompanyUpdateCorporateNameTForm::class, $company);
$companyUpdateRefForm = $this->createForm(CompanyUpdateRefTForm::class, $company);
$companyUpdateFiscForm = $this->createForm(CompanyUpdateFiscTForm::class, $company);
$companyUpdateTribunalForm = $this->createForm(CompanyUpdateTribunalTForm::class, $company);
$companyUpdatePhysicaltypeForm = $this->createForm(CompanyUpdatePhysicaltypeTForm::class, $company);
$companyUpdateCnssForm = $this->createForm(CompanyUpdateCnssTForm::class, $company);
$companyUpdateCnssBureauForm = $this->createForm(CompanyUpdateCnssBureauTForm::class, $company);
$companyUpdateSectorsForm = $this->createForm(CompanyUpdateSectorsTForm::class, $company);
$companyUpdatePhoneForm = $this->createForm(CompanyUpdatePhoneTForm::class, $company);
$companyUpdateMobileForm = $this->createForm(CompanyUpdateMobileTForm::class, $company);
$companyUpdateFaxForm = $this->createForm(CompanyUpdateFaxTForm::class, $company);
$companyUpdateEmailForm = $this->createForm(CompanyUpdateEmailTForm::class, $company);
$companyUpdateAdrForm = $this->createForm(CompanyUpdateAdrTForm::class, $company);
$companyUpdateOtherInfosForm = $this->createForm(CompanyUpdateOtherInfosTForm::class, $company);
$companyUpdateActionvnForm = $this->createForm(CompanyUpdateActionvnTForm::class, $company);
$stock = new Stock();
$stock->setCompany($company);
$stockNewForm = $this->createForm(StockNewTForm::class, $stock, array('company' => $company));
$address = new Address();
$address->setCompany($company);
$addressNewForm = $this->createForm(AddressNewTForm::class, $address, array('company' => $company));
$phone = new Phone();
$phone->setCompany($company);
$phoneNewForm = $this->createForm(PhoneNewTForm::class, $phone, array('company' => $company));
$companyFrame = new CompanyFrame();
$companyFrame->setCompany($company);
$companyFrameNewForm = $this->createForm(CompanyFrameNewTForm::class, $companyFrame, array('company' => $company));
$companyNature = new CompanyNature();
$companyNature->setCompany($company);
$companyNatureNewForm = $this->createForm(CompanyNatureNewTForm::class, $companyNature, array('company' => $company));
$companyNatureImportForm = $this->createForm(CompanyNatureImportTForm::class);
$doc = new Doc();
$doc->setCompany($company);
$docNewForm = $this->createForm(DocNewTForm::class, $doc, array('company' => $company));
$pilot = new Pilot();
$pilot->setCompany($company);
$pilotNewForm = $this->createForm(PilotNewTForm::class, $pilot, array('company' => $company));
$companyUser = new CompanyUser();
$companyUser->setCompany($company);
$companyUserNewForm = $this->createForm(CompanyUserNewTForm::class, $companyUser, array('company' => $company));
$companyAdmin = new CompanyAdmin();
$companyAdmin->setCompany($company);
$companyAdminNewForm = $this->createForm(CompanyAdminNewTForm::class, $companyAdmin, array('company' => $company));
$companyLabel = new CompanyLabel();
$companyLabel->setCompany($company);
$companyLabelNewForm = $this->createForm(CompanyLabelNewTForm::class, $companyLabel, array('company' => $company));
$companyLabelImportForm = $this->createForm(CompanyLabelImportTForm::class);
$customer = new Customer();
$customer->setCompany($company);
$customerNewForm = $this->createForm(CustomerNewTForm::class, $customer, array('company' => $company));
$customerImportForm = $this->createForm(CustomerImportTForm::class);
$supplier = new Supplier();
$supplier->setCompany($company);
$supplierNewForm = $this->createForm(SupplierNewTForm::class, $supplier, array('company' => $company));
$supplierImportForm = $this->createForm(SupplierImportTForm::class);
$bank = new Bank();
$bank->setCompany($company);
$bankNewForm = $this->createForm(BankNewTForm::class, $bank, array('company' => $company));
$bankImportForm = $this->createForm(BankImportTForm::class);
$fund = new Fund();
$fund->setCompany($company);
$fundNewForm = $this->createForm(FundNewTForm::class, $fund, array('company' => $company));
$fundImportForm = $this->createForm(FundImportTForm::class);
$withholding = new Withholding();
$withholding->setCompany($company);
$withholdingNewForm = $this->createForm(WithholdingNewTForm::class, $withholding, array('company' => $company));
$withholdingImportForm = $this->createForm(WithholdingImportTForm::class);
$mbsale = new MBSale();
$mbsale->setCompany($company);
$mbsaleNewForm = $this->createForm(MBSaleNewTForm::class, $mbsale, array('company' => $company));
$mbsaleNewYearForm = $this->createForm(MBSaleNewYearTForm::class, $mbsale, array('company' => $company));
$mbpurchase = new MBPurchase();
$mbpurchase->setCompany($company);
$mbpurchaseNewForm = $this->createForm(MBPurchaseNewTForm::class, $mbpurchase, array('company' => $company));
$mbpurchaseNewYearForm = $this->createForm(MBPurchaseNewYearTForm::class, $mbpurchase, array('company' => $company));
$mpaye = new MPaye();
$mpaye->setCompany($company);
$mpayeNewForm = $this->createForm(MPayeNewTForm::class, $mpaye, array('company' => $company));
$mpayeNewYearForm = $this->createForm(MPayeNewYearTForm::class, $mpaye, array('company' => $company));
$docgroupcomptable = new Docgroupcomptable();
$docgroupcomptable->setCompany($company);
$docgroupcomptableNewForm = $this->createForm(DocgroupcomptableNewTForm::class, $docgroupcomptable, array('company' => $company));
$docgroup = new Docgroup();
$docgroup->setCompany($company);
$docgroupNewForm = $this->createForm(DocgroupNewTForm::class, $docgroup, array('company' => $company));
$shareholder = new Shareholder();
$shareholder->setCompany($company);
$shareholderNewForm = $this->createForm(ShareholderNewTForm::class, $shareholder, array('company' => $company));
$docgroupfiscal = new Docgroupfiscal();
$docgroupfiscal->setCompany($company);
$docgroupfiscalNewForm = $this->createForm(DocgroupfiscalNewTForm::class, $docgroupfiscal, array('company' => $company));
$docgroupperso = new Docgroupperso();
$docgroupperso->setCompany($company);
$docgrouppersoNewForm = $this->createForm(DocgrouppersoNewTForm::class, $docgroupperso, array('company' => $company));
$docgroupsyst = new Docgroupsyst();
$docgroupsyst->setCompany($company);
$docgroupsystNewForm = $this->createForm(DocgroupsystNewTForm::class, $docgroupsyst, array('company' => $company));
$docgroupaudit = new Docgroupaudit();
$docgroupaudit->setCompany($company);
$docgroupauditNewForm = $this->createForm(DocgroupauditNewTForm::class, $docgroupaudit, array('company' => $company));
$docgroupbank = new Docgroupbank();
$docgroupbank->setCompany($company);
$docgroupbankNewForm = $this->createForm(DocgroupbankNewTForm::class, $docgroupbank, array('company' => $company));
$this->gvars['tabActive'] = $this->getSession()->get('tabActive', 2);
$this->getSession()->remove('tabActive');
$this->gvars['stabActive'] = $this->getSession()->get('stabActive', 1);
$this->getSession()->remove('stabActive');
$request = $this->getRequest();
$reqData = $request->request->all();
$cloneCompany = clone $company;
if (isset($reqData['CompanyUpdateTypeForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateTypeForm->handleRequest($request);
if ($companyUpdateTypeForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateCorporateNameForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateCorporateNameForm->handleRequest($request);
if ($companyUpdateCorporateNameForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateRefForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateRefForm->handleRequest($request);
if ($companyUpdateRefForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateFiscForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateFiscForm->handleRequest($request);
if ($companyUpdateFiscForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateTribunalForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateTribunalForm->handleRequest($request);
if ($companyUpdateTribunalForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdatePhysicaltypeForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdatePhysicaltypeForm->handleRequest($request);
if ($companyUpdatePhysicaltypeForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateCnssForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateCnssForm->handleRequest($request);
if ($companyUpdateCnssForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateCnssBureauForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateCnssBureauForm->handleRequest($request);
if ($companyUpdateCnssBureauForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateSectorsForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateSectorsForm->handleRequest($request);
if ($companyUpdateSectorsForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdatePhoneForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdatePhoneForm->handleRequest($request);
if ($companyUpdatePhoneForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateMobileForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateMobileForm->handleRequest($request);
if ($companyUpdateMobileForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateFaxForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateFaxForm->handleRequest($request);
if ($companyUpdateFaxForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateEmailForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateEmailForm->handleRequest($request);
if ($companyUpdateEmailForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateAdrForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateAdrForm->handleRequest($request);
if ($companyUpdateAdrForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateOtherInfosForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateOtherInfosForm->handleRequest($request);
if ($companyUpdateOtherInfosForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['CompanyUpdateActionvnForm'])) {
$this->gvars['tabActive'] = 2;
$this->getSession()->set('tabActive', 2);
$companyUpdateActionvnForm->handleRequest($request);
if ($companyUpdateActionvnForm->isValid()) {
$em->persist($company);
$em->flush();
$this->flashMsgSession('success', $this->translate('Company.edit.success', array('%company%' => $company->getCorporateName())));
$this->traceEntity($cloneCompany, $company);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Company.edit.failure', array('%company%' => $company->getCorporateName())));
}
} elseif (isset($reqData['StockNewForm'])) {
$this->gvars['tabActive'] = 3;
$this->getSession()->set('tabActive', 3);
$stockNewForm->handleRequest($request);
if ($stockNewForm->isValid()) {
$em->persist($stock);
$em->flush();
$this->flashMsgSession('success', $this->translate('Stock.add.success', array('%stock%' => $stock->getYear())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Address.add.failure'));
}
} elseif (isset($reqData['AddressNewForm'])) {
$this->gvars['tabActive'] = 4;
$this->getSession()->set('tabActive', 4);
$addressNewForm->handleRequest($request);
if ($addressNewForm->isValid()) {
$em->persist($address);
$em->flush();
$this->flashMsgSession('success', $this->translate('Address.add.success', array('%address%' => $address->getLabel())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Address.add.failure'));
}
} elseif (isset($reqData['PhoneNewForm'])) {
$this->gvars['tabActive'] = 5;
$this->getSession()->set('tabActive', 5);
$phoneNewForm->handleRequest($request);
if ($phoneNewForm->isValid()) {
$em->persist($phone);
$em->flush();
$this->flashMsgSession('success', $this->translate('Phone.add.success', array('%phone%' => $phone->getLabel())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Phone.add.failure'));
}
} elseif (isset($reqData['CompanyFrameNewForm'])) {
$this->gvars['tabActive'] = 6;
$this->getSession()->set('tabActive', 6);
$companyFrameNewForm->handleRequest($request);
if ($companyFrameNewForm->isValid()) {
$em->persist($companyFrame);
$em->flush();
$this->flashMsgSession('success', $this->translate('CompanyFrame.add.success', array('%companyFrame%' => $companyFrame->getFullName())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('CompanyFrame.add.failure'));
}
} elseif (isset($reqData['CompanyNatureNewForm'])) {
$this->gvars['tabActive'] = 7;
$this->getSession()->set('tabActive', 7);
$this->gvars['stabActive'] = 1;
$this->getSession()->set('stabActive', 1);
$companyNatureNewForm->handleRequest($request);
if ($companyNatureNewForm->isValid()) {
$em->persist($companyNature);
$em->flush();
$this->flashMsgSession('success', $this->translate('CompanyNature.add.success', array('%companyNature%' => $companyNature->getLabel())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('CompanyNature.add.failure'));
}
} elseif (isset($reqData['CompanyNatureImportForm'])) {
$this->gvars['tabActive'] = 8;
$this->getSession()->set('tabActive', 8);
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$companyNatureImportForm->handleRequest($request);
if ($companyNatureImportForm->isValid()) {
ini_set('memory_limit', '4096M');
ini_set('max_execution_time', '0');
$extension = $companyNatureImportForm['excel']->getData()->guessExtension();
if ($extension == 'zip') {
$extension = 'xlsx';
}
$filename = uniqid() . '.' . $extension;
$companyNatureImportForm['excel']->getData()->move($this->getParameter('adapter_files'), $filename);
$fullfilename = $this->getParameter('adapter_files');
$fullfilename .= '/' . $filename;
$excelObj = $this->get('phpexcel')->createPHPExcelObject($fullfilename);
$log = '';
$iterator = $excelObj->getWorksheetIterator();
$activeSheetIndex = -1;
$i = 0;
foreach ($iterator as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// e.g. 10
$highestColumn = $worksheet->getHighestColumn();
// e.g 'F'
$highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);
$log .= "Feuille : '" . $worksheetTitle . "' trouvée contenant " . $highestRow . ' lignes et ' . $highestColumnIndex . ' colonnes avec comme plus grand index ' . $highestColumn . ' <br>';
if (\trim($worksheetTitle) == 'Sage') {
$activeSheetIndex = $i;
}
$i++;
}
if ($activeSheetIndex == -1) {
$log .= "Aucune Feuille de Titre 'Sage' trouvée tentative d'import depuis le première Feuille<br>";
$activeSheetIndex = 0;
}
$excelObj->setActiveSheetIndex($activeSheetIndex);
$worksheet = $excelObj->getActiveSheet();
$highestRow = $worksheet->getHighestRow();
$lineRead = 0;
$companyNaturesNew = 0;
$lineUnprocessed = 0;
$lineError = 0;
for ($row = 1; $row <= $highestRow; $row++) {
$lineRead++;
$label = \trim(\strval($worksheet->getCellByColumnAndRow(0, $row)->getValue()));
$color = \trim(\strval($worksheet->getCellByColumnAndRow(1, $row)->getValue()));
if ($label != '') {
$companyNature = $em->getRepository('AcfDataBundle:CompanyNature')->findOneBy(array('company' => $company, 'label' => $label));
if (null == $companyNature) {
$companyNaturesNew++;
$companyNature = new CompanyNature();
$companyNature->setCompany($company);
$companyNature->setLabel($label);
$companyNature->setColor($color);
$em->persist($companyNature);
} else {
$lineUnprocessed++;
$log .= "la Nature d'Achat " . $lineRead . ' existe déjà<br>';
}
} else {
$lineError++;
$log .= 'la ligne ' . $lineRead . ' contient des erreurs<br>';
}
}
$em->flush();
$log .= $lineRead . ' lignes lues<br>';
$log .= $companyNaturesNew . " nouvelles Natures d'Achat<br>";
$log .= $lineUnprocessed . " Natures d'Achat déjà dans la base<br>";
$log .= $lineError . ' lignes contenant des erreurs<br>';
$this->flashMsgSession('log', $log);
$this->flashMsgSession('success', $this->translate('CompanyNature.import.success'));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('CompanyNature.import.failure'));
}
} elseif (isset($reqData['DocNewForm'])) {
$this->gvars['tabActive'] = 8;
$this->getSession()->set('tabActive', 8);
$docNewForm->handleRequest($request);
if ($docNewForm->isValid()) {
$docFiles = $docNewForm['fileName']->getData();
$docs = array();
$docDir = $this->getParameter('kernel.root_dir') . '/../web/res/docs';
$docNames = '';
foreach ($docFiles as $docFile) {
$originalName = $docFile->getClientOriginalName();
$fileName = sha1(uniqid(mt_rand(), true)) . '.' . strtolower($docFile->getClientOriginalExtension());
$mimeType = $docFile->getMimeType();
$docFile->move($docDir, $fileName);
$size = filesize($docDir . '/' . $fileName);
$md5 = md5_file($docDir . '/' . $fileName);
$doc = new Doc();
$doc->setCompany($company);
$doc->setFileName($fileName);
$doc->setOriginalName($originalName);
$doc->setSize($size);
$doc->setMimeType($mimeType);
$doc->setMd5($md5);
$doc->setDescription($docNewForm['description']->getData());
$em->persist($doc);
$docNames .= $doc->getOriginalName() . ' ';
$docs[] = $doc;
}
$em->flush();
$this->flashMsgSession('success', $this->translate('Doc.add.success', array('%doc%' => $docNames)));
$from = $this->getParameter('mail_from');
$fromName = $this->getParameter('mail_from_name');
$subject = $this->translate('_mail.newdocsCloud.subject', array(), 'messages');
$acfCloudRole = $em->getRepository('AcfDataBundle:Role')->findOneBy(array('name' => 'ROLE_CLIENT1'));
$users = array();
foreach ($company->getUsers() as $user) {
if ($user->hasRole($acfCloudRole)) {
$users[] = $user;
}
}
if (\count($users) != 0) {
foreach ($users as $user) {
$mvars = array();
$mvars['company'] = $company;
$mvars['docs'] = $docs;
$message = \Swift_Message::newInstance();
$message->setFrom($from, $fromName);
$message->addTo($user->getEmail(), $user->getFullname());
$message->setSubject($subject);
$mvars['logo'] = $message->embed(\Swift_Image::fromPath($this->getParameter('kernel.root_dir') . '/../web/bundles/acfres/images/logo_acf.jpg'));
$message->setBody($this->renderView('AcfAdminBundle:Doc:sendmail.html.twig', $mvars), 'text/html');
$this->sendmail($message);
}
}
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Doc.add.failure'));
}
} elseif (isset($reqData['PilotNewForm'])) {
$this->gvars['tabActive'] = 9;
$this->getSession()->set('tabActive', 9);
$pilotNewForm->handleRequest($request);
if ($pilotNewForm->isValid()) {
$em->persist($pilot);
$em->flush();
$this->flashMsgSession('success', $this->translate('Pilot.add.success', array('%pilot%' => $pilot->getMission())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Pilot.add.failure'));
}
} elseif (isset($reqData['CompanyUserNewForm'])) {
$this->gvars['tabActive'] = 10;
$this->getSession()->set('tabActive', 10);
$companyUserNewForm->handleRequest($request);
if ($companyUserNewForm->isValid()) {
$user = $companyUser->getUser();
$hasClientRole = false;
foreach ($user->getUserRoles() as $role) {
if ($role->getName() == 'ROLE_CLIENT1') {
$hasClientRole = true;
}
}
if (!$hasClientRole) {
$roleClient = $em->getRepository('AcfDataBundle:Role')->findOneBy(array('name' => 'ROLE_CLIENT1'));
if (null == $roleClient) {
$roleClient = new Role();
$roleClient->setName('ROLE_CLIENT1');
}
$user->addUserRole($roleClient);
$em->persist($user);
}
$em->persist($companyUser);
$em->flush();
$this->flashMsgSession('success', $this->translate('CompanyUser.add.success', array('%company%' => $companyUser->getCompany()->getCorporateName(), '%user%' => $companyUser->getUser()->getFullName())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('CompanyUser.add.failure'));
}
} elseif (isset($reqData['CompanyAdminNewForm'])) {
$this->gvars['tabActive'] = 11;
$this->getSession()->set('tabActive', 11);
$companyAdminNewForm->handleRequest($request);
if ($companyAdminNewForm->isValid()) {
$user = $companyAdmin->getUser();
$hasClientRole = false;
foreach ($user->getUserRoles() as $role) {
if ($role->getName() == 'ROLE_ADMIN') {
$hasClientRole = true;
}
}
if (!$hasClientRole) {
$roleAdmin = $em->getRepository('AcfDataBundle:Role')->findOneBy(array('name' => 'ROLE_ADMIN'));
if (null == $roleAdmin) {
$roleAdmin = new Role();
$roleAdmin->setName('ROLE_ADMIN');
}
$user->addUserRole($roleAdmin);
$em->persist($user);
}
$em->persist($companyAdmin);
$em->flush();
$this->flashMsgSession('success', $this->translate('CompanyAdmin.add.success', array('%company%' => $companyAdmin->getCompany()->getCorporateName(), '%user%' => $companyAdmin->getUser()->getFullName())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('CompanyAdmin.add.failure'));
}
} elseif (isset($reqData['CompanyLabelNewForm'])) {
$this->gvars['tabActive'] = 21;
$this->getSession()->set('tabActive', 21);
$this->gvars['stabActive'] = 1;
$this->getSession()->set('stabActive', 1);
$companyLabelNewForm->handleRequest($request);
if ($companyLabelNewForm->isValid()) {
$em->persist($companyLabel);
$em->flush();
$this->flashMsgSession('success', $this->translate('CompanyLabel.add.success', array('%companyLabel%' => $companyLabel->getName())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('CompanyLabel.add.failure'));
}
} elseif (isset($reqData['CompanyLabelImportForm'])) {
$this->gvars['tabActive'] = 21;
$this->getSession()->set('tabActive', 21);
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$companyLabelImportForm->handleRequest($request);
if ($companyLabelImportForm->isValid()) {
ini_set('memory_limit', '4096M');
ini_set('max_execution_time', '0');
$extension = $companyLabelImportForm['excel']->getData()->guessExtension();
if ($extension == 'zip') {
$extension = 'xlsx';
}
$filename = uniqid() . '.' . $extension;
$companyLabelImportForm['excel']->getData()->move($this->getParameter('adapter_files'), $filename);
$fullfilename = $this->getParameter('adapter_files');
$fullfilename .= '/' . $filename;
$excelObj = $this->get('phpexcel')->createPHPExcelObject($fullfilename);
$log = '';
$iterator = $excelObj->getWorksheetIterator();
$activeSheetIndex = -1;
$i = 0;
foreach ($iterator as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// e.g. 10
$highestColumn = $worksheet->getHighestColumn();
// e.g 'F'
$highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);
$log .= "Feuille : '" . $worksheetTitle . "' trouvée contenant " . $highestRow . ' lignes et ' . $highestColumnIndex . ' colonnes avec comme plus grand index ' . $highestColumn . ' <br>';
if (\trim($worksheetTitle) == 'Sage') {
$activeSheetIndex = $i;
}
$i++;
}
if ($activeSheetIndex == -1) {
$log .= "Aucune Feuille de Titre 'Sage' trouvée tentative d'import depuis le première Feuille<br>";
$activeSheetIndex = 0;
}
$excelObj->setActiveSheetIndex($activeSheetIndex);
$worksheet = $excelObj->getActiveSheet();
$highestRow = $worksheet->getHighestRow();
$lineRead = 1;
$companyLabelsNew = 0;
$lineUnprocessed = 0;
$lineError = 0;
for ($row = 2; $row <= $highestRow; $row++) {
$lineRead++;
$name = \trim(\strval($worksheet->getCellByColumnAndRow(0, $row)->getValue()));
$abrev = \trim(\strval($worksheet->getCellByColumnAndRow(1, $row)->getValue()));
if ($abrev != '' && $name != '') {
$companyLabel = $em->getRepository('AcfDataBundle:CompanyLabel')->findOneBy(array('company' => $company, 'abrev' => $abrev));
if (null == $companyLabel) {
$companyLabelsNew++;
$companyLabel = new CompanyLabel();
$companyLabel->setCompany($company);
$companyLabel->setAbrev($abrev);
$companyLabel->setName($name);
$em->persist($companyLabel);
} else {
$lineUnprocessed++;
$log .= 'le Code Journal à la ligne ' . $lineRead . ' existe déjà<br>';
}
} else {
$lineError++;
$log .= 'la ligne ' . $lineRead . ' contient des erreurs<br>';
}
}
$em->flush();
$log .= $lineRead . ' lignes lues<br>';
$log .= $companyLabelsNew . ' nouveaux Journaux<br>';
$log .= $lineUnprocessed . ' Journaux déjà dans la base<br>';
$log .= $lineError . ' lignes contenant des erreurs<br>';
$this->flashMsgSession('log', $log);
$this->flashMsgSession('success', $this->translate('CompanyLabel.import.success'));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('CompanyLabel.import.failure'));
}
} elseif (isset($reqData['CustomerNewForm'])) {
$this->gvars['tabActive'] = 22;
$this->getSession()->set('tabActive', 22);
$this->gvars['stabActive'] = 1;
$this->getSession()->set('stabActive', 1);
$customerNewForm->handleRequest($request);
if ($customerNewForm->isValid()) {
$em->persist($customer);
$em->flush();
$this->flashMsgSession('success', $this->translate('Customer.add.success', array('%customer%' => $customer->getLabel())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Customer.add.failure'));
}
} elseif (isset($reqData['CustomerImportForm'])) {
$this->gvars['tabActive'] = 22;
$this->getSession()->set('tabActive', 22);
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$customerImportForm->handleRequest($request);
if ($customerImportForm->isValid()) {
ini_set('memory_limit', '4096M');
ini_set('max_execution_time', '0');
$extension = $customerImportForm['excel']->getData()->guessExtension();
if ($extension == 'zip') {
$extension = 'xlsx';
}
$filename = uniqid() . '.' . $extension;
$customerImportForm['excel']->getData()->move($this->getParameter('adapter_files'), $filename);
$fullfilename = $this->getParameter('adapter_files');
$fullfilename .= '/' . $filename;
$excelObj = $this->get('phpexcel')->createPHPExcelObject($fullfilename);
$log = '';
$iterator = $excelObj->getWorksheetIterator();
$activeSheetIndex = -1;
$i = 0;
foreach ($iterator as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// e.g. 10
$highestColumn = $worksheet->getHighestColumn();
// e.g 'F'
$highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);
$log .= "Feuille : '" . $worksheetTitle . "' trouvée contenant " . $highestRow . ' lignes et ' . $highestColumnIndex . ' colonnes avec comme plus grand index ' . $highestColumn . ' <br>';
if (\trim($worksheetTitle) == 'Sage') {
$activeSheetIndex = $i;
}
$i++;
}
if ($activeSheetIndex == -1) {
$log .= "Aucune Feuille de Titre 'Sage' trouvée tentative d'import depuis la première Feuille<br>";
$activeSheetIndex = 0;
}
$excelObj->setActiveSheetIndex($activeSheetIndex);
$customersConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'customersPrefix'));
if (null == $customersConstStr) {
$customersConstStr = new ConstantStr();
$customersConstStr->setName('customersPrefix');
$customersConstStr->setValue('411');
$em->persist($customersConstStr);
$em->flush();
}
$customersPrefix = $customersConstStr->getValue();
$customersPrefixNum = \intval($customersPrefix) * 1000000000;
$worksheet = $excelObj->getActiveSheet();
$highestRow = $worksheet->getHighestRow();
$lineRead = 1;
$customersNew = 0;
$lineUnprocessed = 0;
$lineError = 0;
for ($row = 2; $row <= $highestRow; $row++) {
$lineRead++;
$xlsLabel = \trim(\strval($worksheet->getCellByColumnAndRow(0, $row)->getValue()));
$xlsNumber = \trim(\strval($worksheet->getCellByColumnAndRow(1, $row)->getValue()));
$xlsMatricule = \trim(\strval($worksheet->getCellByColumnAndRow(2, $row)->getValue()));
$xlsAddress = \trim(\strval($worksheet->getCellByColumnAndRow(4, $row)->getValue()));
$xlsRc = \trim(\strval($worksheet->getCellByColumnAndRow(5, $row)->getValue()));
if ($xlsNumber != '' && \is_numeric($xlsNumber)) {
$xlsNumber = \intval($xlsNumber) - $customersPrefixNum;
}
if ($xlsNumber != '' && $xlsNumber > 0 && $xlsLabel != '') {
$customer1 = $em->getRepository('AcfDataBundle:Customer')->findOneBy(array('company' => $company, 'number' => $xlsNumber));
$customer2 = $em->getRepository('AcfDataBundle:Customer')->findOneBy(array('company' => $company, 'label' => $xlsLabel));
if (null == $customer1 && null == $customer2) {
$customersNew++;
$customer = new Customer();
$customer->setCompany($company);
$customer->setLabel($xlsLabel);
$customer->setNumber($xlsNumber);
$customer->setFisc($xlsMatricule);
$customer->setCin($xlsMatricule);
$customer->setAddress($xlsAddress);
$customer->setCommercialRegister($xlsRc);
$em->persist($customer);
} else {
$lineUnprocessed++;
$log .= 'le Client à la ligne ' . $lineRead . ' existe déjà<br>';
}
} else {
$lineError++;
$log .= 'la ligne ' . $lineRead . ' contient des erreurs (COL A : ' . $xlsLabel . ', COL B: ' . $xlsNumber . ')<br>';
}
}
$em->flush();
$log .= $lineRead . ' lignes lues<br>';
$log .= $customersNew . ' nouveaux Clients<br>';
$log .= $lineUnprocessed . ' Clients déjà dans la base<br>';
$log .= $lineError . ' lignes contenant des erreurs<br>';
$this->flashMsgSession('log', $log);
$this->flashMsgSession('success', $this->translate('Customer.import.success'));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Customer.import.failure'));
}
} elseif (isset($reqData['SupplierNewForm'])) {
$this->gvars['tabActive'] = 23;
$this->getSession()->set('tabActive', 23);
$this->gvars['stabActive'] = 1;
$this->getSession()->set('stabActive', 1);
$supplierNewForm->handleRequest($request);
if ($supplierNewForm->isValid()) {
$em->persist($supplier);
$em->flush();
$this->flashMsgSession('success', $this->translate('Supplier.add.success', array('%supplier%' => $supplier->getLabel())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Supplier.add.failure'));
}
} elseif (isset($reqData['SupplierImportForm'])) {
$this->gvars['tabActive'] = 23;
$this->getSession()->set('tabActive', 23);
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$supplierImportForm->handleRequest($request);
if ($supplierImportForm->isValid()) {
ini_set('memory_limit', '4096M');
ini_set('max_execution_time', '0');
$extension = $supplierImportForm['excel']->getData()->guessExtension();
if ($extension == 'zip') {
$extension = 'xlsx';
}
$filename = uniqid() . '.' . $extension;
$supplierImportForm['excel']->getData()->move($this->getParameter('adapter_files'), $filename);
$fullfilename = $this->getParameter('adapter_files');
$fullfilename .= '/' . $filename;
$excelObj = $this->get('phpexcel')->createPHPExcelObject($fullfilename);
$log = '';
$iterator = $excelObj->getWorksheetIterator();
$activeSheetIndex = -1;
$i = 0;
foreach ($iterator as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// e.g. 10
$highestColumn = $worksheet->getHighestColumn();
// e.g 'F'
$highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);
$log .= "Feuille : '" . $worksheetTitle . "' trouvée contenant " . $highestRow . ' lignes et ' . $highestColumnIndex . ' colonnes avec comme plus grand index ' . $highestColumn . ' <br>';
if (\trim($worksheetTitle) == 'Sage') {
$activeSheetIndex = $i;
}
$i++;
}
if ($activeSheetIndex == -1) {
$log .= "Aucune Feuille de Titre 'Sage' trouvée tentative d'import depuis le première Feuille<br>";
$activeSheetIndex = 0;
}
$excelObj->setActiveSheetIndex($activeSheetIndex);
$suppliersConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'suppliersPrefix'));
if (null == $suppliersConstStr) {
$suppliersConstStr = new ConstantStr();
$suppliersConstStr->setName('suppliersPrefix');
$suppliersConstStr->setValue('401');
$em->persist($suppliersConstStr);
$em->flush();
}
$suppliersPrefix = $suppliersConstStr->getValue();
$suppliersPrefixNum = \intval($suppliersPrefix) * 1000000000;
$worksheet = $excelObj->getActiveSheet();
$highestRow = $worksheet->getHighestRow();
$lineRead = 1;
$suppliersNew = 0;
$lineUnprocessed = 0;
$lineError = 0;
for ($row = 2; $row <= $highestRow; $row++) {
$lineRead++;
$xlsLabel = \trim(\strval($worksheet->getCellByColumnAndRow(0, $row)->getValue()));
$xlsNumber = \trim(\strval($worksheet->getCellByColumnAndRow(1, $row)->getValue()));
$xlsMatricule = \trim(\strval($worksheet->getCellByColumnAndRow(2, $row)->getValue()));
$xlsAddress = \trim(\strval($worksheet->getCellByColumnAndRow(3, $row)->getValue()));
$xlsRc = \trim(\strval($worksheet->getCellByColumnAndRow(4, $row)->getValue()));
if ($xlsNumber != '' && \is_numeric($xlsNumber)) {
$xlsNumber = \intval($xlsNumber) - $suppliersPrefixNum;
}
if ($xlsNumber != '' && $xlsNumber > 0 && $xlsLabel != '') {
$supplier1 = $em->getRepository('AcfDataBundle:Supplier')->findOneBy(array('company' => $company, 'number' => $xlsNumber));
$supplier2 = $em->getRepository('AcfDataBundle:Supplier')->findOneBy(array('company' => $company, 'label' => $xlsLabel));
if (null == $supplier1 && null == $supplier2) {
$suppliersNew++;
$supplier = new Supplier();
$supplier->setCompany($company);
$supplier->setLabel($xlsLabel);
$supplier->setNumber($xlsNumber);
$supplier->setFisc($xlsMatricule);
$supplier->setCin($xlsMatricule);
$supplier->setAddress($xlsAddress);
$supplier->setCommercialRegister($xlsRc);
$em->persist($supplier);
} else {
$lineUnprocessed++;
$log .= 'le Fournisseur à la ligne ' . $lineRead . ' existe déjà<br>';
}
} else {
$lineError++;
$log .= 'la ligne ' . $lineRead . ' contient des erreurs (COL A : ' . $xlsLabel . ', COL B: ' . $xlsNumber . ')<br>';
}
}
$em->flush();
$log .= $lineRead . ' lignes lues<br>';
$log .= $suppliersNew . ' nouveaux Fournisseurs<br>';
$log .= $lineUnprocessed . ' Fournisseurs déjà dans la base<br>';
$log .= $lineError . ' lignes contenant des erreurs<br>';
$this->flashMsgSession('log', $log);
$this->flashMsgSession('success', $this->translate('Supplier.import.success'));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Supplier.import.failure'));
}
} elseif (isset($reqData['BankNewForm'])) {
$this->gvars['tabActive'] = 24;
$this->getSession()->set('tabActive', 24);
$this->gvars['stabActive'] = 1;
$this->getSession()->set('stabActive', 1);
$bankNewForm->handleRequest($request);
if ($bankNewForm->isValid()) {
$em->persist($bank);
$em->flush();
$this->flashMsgSession('success', $this->translate('Bank.add.success', array('%bank%' => $bank->getLabel())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Bank.add.failure'));
}
} elseif (isset($reqData['BankImportForm'])) {
$this->gvars['tabActive'] = 24;
$this->getSession()->set('tabActive', 24);
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$bankImportForm->handleRequest($request);
if ($bankImportForm->isValid()) {
ini_set('memory_limit', '4096M');
ini_set('max_execution_time', '0');
$extension = $bankImportForm['excel']->getData()->guessExtension();
if ($extension == 'zip') {
$extension = 'xlsx';
}
$filename = uniqid() . '.' . $extension;
$bankImportForm['excel']->getData()->move($this->getParameter('adapter_files'), $filename);
$fullfilename = $this->getParameter('adapter_files');
$fullfilename .= '/' . $filename;
$excelObj = $this->get('phpexcel')->createPHPExcelObject($fullfilename);
$log = '';
$iterator = $excelObj->getWorksheetIterator();
$activeSheetIndex = -1;
$i = 0;
foreach ($iterator as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// e.g. 10
$highestColumn = $worksheet->getHighestColumn();
// e.g 'F'
$highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);
$log .= "Feuille : '" . $worksheetTitle . "' trouvée contenant " . $highestRow . ' lignes et ' . $highestColumnIndex . ' colonnes avec comme plus grand index ' . $highestColumn . ' <br>';
if (\trim($worksheetTitle) == 'Sage') {
$activeSheetIndex = $i;
}
$i++;
}
if ($activeSheetIndex == -1) {
$log .= "Aucune Feuille de Titre 'Sage' trouvée tentative d'import depuis le première Feuille<br>";
$activeSheetIndex = 0;
}
$excelObj->setActiveSheetIndex($activeSheetIndex);
$banksConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'banksPrefix'));
if (null == $banksConstStr) {
$banksConstStr = new ConstantStr();
$banksConstStr->setName('banksPrefix');
$banksConstStr->setValue('532');
$em->persist($banksConstStr);
$em->flush();
}
$banksPrefix = $banksConstStr->getValue();
$banksPrefixNum = \intval($banksPrefix) * 1000000000;
$worksheet = $excelObj->getActiveSheet();
$highestRow = $worksheet->getHighestRow();
$lineRead = 1;
$banksNew = 0;
$lineUnprocessed = 0;
$lineError = 0;
for ($row = 2; $row <= $highestRow; $row++) {
$lineRead++;
$label = \trim(\strval($worksheet->getCellByColumnAndRow(0, $row)->getValue()));
$number = \trim(\strval($worksheet->getCellByColumnAndRow(1, $row)->getValue()));
$agence = \trim(\strval($worksheet->getCellByColumnAndRow(2, $row)->getValue()));
$rib = \trim(\strval($worksheet->getCellByColumnAndRow(3, $row)->getValue()));
$contact = \trim(\strval($worksheet->getCellByColumnAndRow(4, $row)->getValue()));
$tel = \trim(\strval($worksheet->getCellByColumnAndRow(5, $row)->getValue()));
$fax = \trim(\strval($worksheet->getCellByColumnAndRow(6, $row)->getValue()));
$email = \trim(\strval($worksheet->getCellByColumnAndRow(7, $row)->getValue()));
if ($number != '' && \is_numeric($number)) {
$number = \intval($number) - $banksPrefixNum;
}
if ($number != '' && $number > 0 && $label != '') {
$bank = $em->getRepository('AcfDataBundle:Bank')->findOneBy(array('company' => $company, 'number' => $number));
$bank1 = $em->getRepository('AcfDataBundle:Bank')->findOneBy(array('company' => $company, 'label' => $label));
if (null == $bank && null == $bank1) {
$banksNew++;
$bank = new Bank();
$bank->setCompany($company);
$bank->setLabel($label);
$bank->setNumber($number);
$bank->setAgency($agence);
$bank->setRib($rib);
$bank->setContact($contact);
$bank->setTel($tel);
$bank->setFax($fax);
$bank->setEmail($email);
$em->persist($bank);
} else {
$lineUnprocessed++;
$log .= 'la Banque à la ligne ' . $lineRead . ' existe déjà<br>';
}
} else {
$lineError++;
$log .= 'la ligne ' . $lineRead . ' contient des erreurs<br>';
}
}
$em->flush();
$log .= $lineRead . ' lignes lues<br>';
$log .= $banksNew . ' nouveaux Banques<br>';
$log .= $lineUnprocessed . ' Banques déjà dans la base<br>';
$log .= $lineError . ' lignes contenant des erreurs<br>';
$this->flashMsgSession('log', $log);
$this->flashMsgSession('success', $this->translate('Bank.import.success'));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Bank.import.failure'));
}
} elseif (isset($reqData['FundNewForm'])) {
$this->gvars['tabActive'] = 25;
$this->getSession()->set('tabActive', 25);
$this->gvars['stabActive'] = 1;
$this->getSession()->set('stabActive', 1);
$fundNewForm->handleRequest($request);
if ($fundNewForm->isValid()) {
$em->persist($fund);
$em->flush();
$this->flashMsgSession('success', $this->translate('Fund.add.success', array('%fund%' => $fund->getLabel())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Fund.add.failure'));
}
} elseif (isset($reqData['FundImportForm'])) {
$this->gvars['tabActive'] = 25;
$this->getSession()->set('tabActive', 25);
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$fundImportForm->handleRequest($request);
if ($fundImportForm->isValid()) {
ini_set('memory_limit', '4096M');
ini_set('max_execution_time', '0');
$extension = $fundImportForm['excel']->getData()->guessExtension();
if ($extension == 'zip') {
$extension = 'xlsx';
}
$filename = uniqid() . '.' . $extension;
$fundImportForm['excel']->getData()->move($this->getParameter('adapter_files'), $filename);
$fullfilename = $this->getParameter('adapter_files');
$fullfilename .= '/' . $filename;
$excelObj = $this->get('phpexcel')->createPHPExcelObject($fullfilename);
$log = '';
$iterator = $excelObj->getWorksheetIterator();
$activeSheetIndex = -1;
$i = 0;
foreach ($iterator as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// e.g. 10
$highestColumn = $worksheet->getHighestColumn();
// e.g 'F'
$highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);
$log .= "Feuille : '" . $worksheetTitle . "' trouvée contenant " . $highestRow . ' lignes et ' . $highestColumnIndex . ' colonnes avec comme plus grand index ' . $highestColumn . ' <br>';
if (\trim($worksheetTitle) == 'Sage') {
$activeSheetIndex = $i;
}
$i++;
}
if ($activeSheetIndex == -1) {
$log .= "Aucune Feuille de Titre 'Sage' trouvée tentative d'import depuis le première Feuille<br>";
$activeSheetIndex = 0;
}
$excelObj->setActiveSheetIndex($activeSheetIndex);
$fundsConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'fundsPrefix'));
if (null == $fundsConstStr) {
$fundsConstStr = new ConstantStr();
$fundsConstStr->setName('fundsPrefix');
$fundsConstStr->setValue('540');
$em->persist($fundsConstStr);
$em->flush();
}
$fundsPrefix = $fundsConstStr->getValue();
$fundsPrefixNum = \intval($fundsPrefix) * 1000000000;
$worksheet = $excelObj->getActiveSheet();
$highestRow = $worksheet->getHighestRow();
$lineRead = 1;
$fundsNew = 0;
$lineUnprocessed = 0;
$lineError = 0;
for ($row = 2; $row <= $highestRow; $row++) {
$lineRead++;
$label = \trim(\strval($worksheet->getCellByColumnAndRow(0, $row)->getValue()));
$number = \trim(\strval($worksheet->getCellByColumnAndRow(1, $row)->getValue()));
if ($number != '' && \is_numeric($number)) {
$number = \intval($number) - $fundsPrefixNum;
}
if ($number != '' && $number > 0 && $label != '') {
$fund = $em->getRepository('AcfDataBundle:Fund')->findOneBy(array('company' => $company, 'number' => $number));
$fund1 = $em->getRepository('AcfDataBundle:Fund')->findOneBy(array('company' => $company, 'label' => $label));
if (null == $fund && null == $fund1) {
$fundsNew++;
$fund = new Fund();
$fund->setCompany($company);
$fund->setLabel($label);
$fund->setNumber($number);
$em->persist($fund);
} else {
$lineUnprocessed++;
$log .= 'la Caisse à la ligne ' . $lineRead . ' existe déjà<br>';
}
} else {
$lineError++;
$log .= 'la ligne ' . $lineRead . ' contient des erreurs<br>';
}
}
$em->flush();
$log .= $lineRead . ' lignes lues<br>';
$log .= $fundsNew . ' nouvelles Caisses<br>';
$log .= $lineUnprocessed . ' Caisses déjà dans la base<br>';
$log .= $lineError . ' lignes contenant des erreurs<br>';
$this->flashMsgSession('log', $log);
$this->flashMsgSession('success', $this->translate('Fund.import.success'));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Fund.import.failure'));
}
} elseif (isset($reqData['WithholdingNewForm'])) {
$this->gvars['tabActive'] = 26;
$this->getSession()->set('tabActive', 26);
$this->gvars['stabActive'] = 1;
$this->getSession()->set('stabActive', 1);
$withholdingNewForm->handleRequest($request);
if ($withholdingNewForm->isValid()) {
$em->persist($withholding);
$em->flush();
$this->flashMsgSession('success', $this->translate('Withholding.add.success', array('%withholding%' => $withholding->getLabel())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Withholding.add.failure'));
}
} elseif (isset($reqData['WithholdingImportForm'])) {
$this->gvars['tabActive'] = 26;
$this->getSession()->set('tabActive', 26);
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$withholdingImportForm->handleRequest($request);
if ($withholdingImportForm->isValid()) {
ini_set('memory_limit', '4096M');
ini_set('max_execution_time', '0');
$extension = $withholdingImportForm['excel']->getData()->guessExtension();
if ($extension == 'zip') {
$extension = 'xlsx';
}
$filename = uniqid() . '.' . $extension;
$withholdingImportForm['excel']->getData()->move($this->getParameter('adapter_files'), $filename);
$fullfilename = $this->getParameter('adapter_files');
$fullfilename .= '/' . $filename;
$excelObj = $this->get('phpexcel')->createPHPExcelObject($fullfilename);
$log = '';
$iterator = $excelObj->getWorksheetIterator();
$activeSheetIndex = -1;
$i = 0;
foreach ($iterator as $worksheet) {
$worksheetTitle = $worksheet->getTitle();
$highestRow = $worksheet->getHighestRow();
// e.g. 10
$highestColumn = $worksheet->getHighestColumn();
// e.g 'F'
$highestColumnIndex = \PHPExcel_Cell::columnIndexFromString($highestColumn);
$log .= "Feuille : '" . $worksheetTitle . "' trouvée contenant " . $highestRow . ' lignes et ' . $highestColumnIndex . ' colonnes avec comme plus grand index ' . $highestColumn . ' <br>';
if (\trim($worksheetTitle) == 'Sage') {
$activeSheetIndex = $i;
}
$i++;
}
if ($activeSheetIndex == -1) {
$log .= "Aucune Feuille de Titre 'Sage' trouvée tentative d'import depuis le première Feuille<br>";
$activeSheetIndex = 0;
}
$excelObj->setActiveSheetIndex($activeSheetIndex);
$withholdingsConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'withholdingsPrefix'));
if (null == $withholdingsConstStr) {
$withholdingsConstStr = new ConstantStr();
$withholdingsConstStr->setName('withholdingsPrefix');
$withholdingsConstStr->setValue('432');
$em->persist($withholdingsConstStr);
$em->flush();
}
$withholdingsPrefix = $withholdingsConstStr->getValue();
$withholdingsPrefixNum = \intval($withholdingsPrefix) * 1000000000;
$worksheet = $excelObj->getActiveSheet();
$highestRow = $worksheet->getHighestRow();
$lineRead = 1;
$withholdingsNew = 0;
$lineUnprocessed = 0;
$lineError = 0;
for ($row = 2; $row <= $highestRow; $row++) {
$lineRead++;
$label = \trim(\strval($worksheet->getCellByColumnAndRow(0, $row)->getValue()));
$number = \trim(\strval($worksheet->getCellByColumnAndRow(1, $row)->getValue()));
$xlsValue = \trim(\strval($worksheet->getCellByColumnAndRow(2, $row)->getValue()));
if ($number != '' && \is_numeric($number)) {
$number = \intval($number) - $withholdingsPrefixNum;
}
if ($number != '' && $number > 0 && $label != '') {
$withholding1 = $em->getRepository('AcfDataBundle:Withholding')->findOneBy(array('company' => $company, 'number' => $number));
$withholding2 = $em->getRepository('AcfDataBundle:Withholding')->findOneBy(array('company' => $company, 'label' => $label));
if (null == $withholding1 && null == $withholding2) {
$withholdingsNew++;
$withholding = new Withholding();
$withholding->setCompany($company);
$withholding->setNumber($number);
$withholding->setLabel($label);
if ($this->endswith($xlsValue, '%')) {
$value = \intval(\substr($xlsValue, 0, -1));
} else {
$value = \intval($xlsValue);
}
$withholding->setValue($value);
$em->persist($withholding);
} else {
$lineUnprocessed++;
$log .= 'la Retenue à la ligne ' . $lineRead . ' existe déjà<br>';
}
} else {
$lineError++;
$log .= 'la ligne ' . $lineRead . ' contient des erreurs<br>';
}
}
$em->flush();
$log .= $lineRead . ' lignes lues<br>';
$log .= $withholdingsNew . ' nouvelles Retenues<br>';
$log .= $lineUnprocessed . ' Retenues déjà dans la base<br>';
$log .= $lineError . ' lignes contenant des erreurs<br>';
$this->flashMsgSession('log', $log);
$this->flashMsgSession('success', $this->translate('Withholding.import.success'));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Withholding.import.failure'));
}
} elseif (isset($reqData['MBSaleNewForm'])) {
$this->gvars['tabActive'] = 27;
$this->getSession()->set('tabActive', 27);
$mbsaleNewForm->handleRequest($request);
if ($mbsaleNewForm->isValid()) {
$mbsale->generateRef();
$em->persist($mbsale);
$em->flush();
$this->flashMsgSession('success', $this->translate('MBSale.add.success', array('%mbsale%' => $mbsale->getRef())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$this->gvars['stabActive'] = 1;
$this->getSession()->set('stabActive', 1);
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('MBSale.add.failure'));
}
} elseif (isset($reqData['MBSaleNewYearForm'])) {
$this->gvars['tabActive'] = 27;
$this->getSession()->set('tabActive', 27);
$mbsaleNewYearForm->handleRequest($request);
if ($mbsaleNewYearForm->isValid()) {
$year = $mbsaleNewYearForm['year']->getData();
foreach (MBSale::choiceMonthCallback() as $month) {
$mbsale = $em->getRepository('AcfDataBundle:MBSale')->findOneBy(array('company' => $company, 'year' => $year, 'month' => $month));
if (null == $mbsale) {
$mbsale = new MBSale();
$mbsale->setCompany($company);
$mbsale->setYear($year);
$mbsale->setMonth($month);
$mbsale->generateRef();
$em->persist($mbsale);
$this->flashMsgSession('success', $this->translate('MBSale.add.success', array('%mbsale%' => $mbsale->getRef())));
}
}
$em->flush();
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('MBSale.add.failure'));
}
} elseif (isset($reqData['MBPurchaseNewForm'])) {
$this->gvars['tabActive'] = 28;
$this->getSession()->set('tabActive', 28);
$mbpurchaseNewForm->handleRequest($request);
if ($mbpurchaseNewForm->isValid()) {
$mbpurchase->generateRef();
$em->persist($mbpurchase);
$em->flush();
$this->flashMsgSession('success', $this->translate('MBPurchase.add.success', array('%mbpurchase%' => $mbpurchase->getRef())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('MBPurchase.add.failure'));
}
} elseif (isset($reqData['MBPurchaseNewYearForm'])) {
$this->gvars['tabActive'] = 28;
$this->getSession()->set('tabActive', 28);
$mbpurchaseNewYearForm->handleRequest($request);
if ($mbpurchaseNewYearForm->isValid()) {
$year = $mbpurchaseNewYearForm['year']->getData();
foreach (MBPurchase::choiceMonthCallback() as $month) {
$mbpurchase = $em->getRepository('AcfDataBundle:MBPurchase')->findOneBy(array('company' => $company, 'year' => $year, 'month' => $month));
if (null == $mbpurchase) {
$mbpurchase = new MBPurchase();
$mbpurchase->setCompany($company);
$mbpurchase->setYear($year);
$mbpurchase->setMonth($month);
$mbpurchase->generateRef();
$em->persist($mbpurchase);
$this->flashMsgSession('success', $this->translate('MBPurchase.add.success', array('%mbpurchase%' => $mbpurchase->getRef())));
}
}
$em->flush();
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('MBPurchase.add.failure'));
}
} elseif (isset($reqData['DocgroupcomptableNewForm'])) {
$this->gvars['tabActive'] = 29;
$this->getSession()->set('tabActive', 29);
$docgroupcomptableNewForm->handleRequest($request);
if ($docgroupcomptableNewForm->isValid()) {
$dgtoclone = null;
$oldDocgroupcomptables = null;
if (null != $docgroupcomptableNewForm['clone']->getData()) {
$dgtoclone = $docgroupcomptableNewForm['clone']->getData();
$oldDocgroupcomptables = $em->getRepository('AcfDataBundle:Docgroupcomptable')->getAllChilds($dgtoclone);
}
$em->persist($docgroupcomptable);
$em->flush();
if (null != $dgtoclone && null != $oldDocgroupcomptables && \count($oldDocgroupcomptables) != 0) {
$docgroupcomptablesCloneArray = array();
foreach ($oldDocgroupcomptables as $oldDocgroupcomptable) {
$ndocgroupcomptable = new Docgroupcomptable();
$ndocgroupcomptable->setCompany($company);
$ndocgroupcomptable->setLabel($oldDocgroupcomptable->getLabel());
$ndocgroupcomptable->setOtherInfos($oldDocgroupcomptable->getOtherInfos());
if (null != $oldDocgroupcomptable->getParent() && $oldDocgroupcomptable->getParent()->getId() != $dgtoclone->getId()) {
$parentId = $oldDocgroupcomptable->getParent()->getId();
$ndocgroupcomptable->setParent($docgroupcomptablesCloneArray[$parentId]);
} else {
$ndocgroupcomptable->setParent($docgroupcomptable);
}
$docgroupcomptablesCloneArray[$oldDocgroupcomptable->getId()] = $ndocgroupcomptable;
$em->persist($ndocgroupcomptable);
}
}
$em->flush();
$this->flashMsgSession('success', $this->translate('Docgroupcomptable.add.success', array('%docgroupcomptable%' => $docgroupcomptable->getLabel())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Docgroupcomptable.add.failure'));
}
} elseif (isset($reqData['DocgroupbankNewForm'])) {
$this->gvars['tabActive'] = 30;
$this->getSession()->set('tabActive', 30);
$docgroupbankNewForm->handleRequest($request);
if ($docgroupbankNewForm->isValid()) {
$dgtoclone = null;
$oldDocgroupbanks = null;
if (null != $docgroupbankNewForm['clone']->getData()) {
$dgtoclone = $docgroupbankNewForm['clone']->getData();
$oldDocgroupbanks = $em->getRepository('AcfDataBundle:Docgroupbank')->getAllChilds($dgtoclone);
}
$em->persist($docgroupbank);
$em->flush();
if (null != $dgtoclone && null != $oldDocgroupbanks && \count($oldDocgroupbanks) != 0) {
$docgroupbanksCloneArray = array();
foreach ($oldDocgroupbanks as $oldDocgroupbank) {
$ndocgroupbank = new Docgroupbank();
$ndocgroupbank->setCompany($company);
$ndocgroupbank->setLabel($oldDocgroupbank->getLabel());
$ndocgroupbank->setOtherInfos($oldDocgroupbank->getOtherInfos());
if (null != $oldDocgroupbank->getParent() && $oldDocgroupbank->getParent()->getId() != $dgtoclone->getId()) {
$parentId = $oldDocgroupbank->getParent()->getId();
$ndocgroupbank->setParent($docgroupbanksCloneArray[$parentId]);
} else {
$ndocgroupbank->setParent($docgroupbank);
}
$docgroupbanksCloneArray[$oldDocgroupbank->getId()] = $ndocgroupbank;
$em->persist($ndocgroupbank);
}
}
$em->flush();
$this->flashMsgSession('success', $this->translate('Docgroupbank.add.success', array('%docgroupbank%' => $docgroupbank->getLabel())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Docgroupbank.add.failure'));
}
} elseif (isset($reqData['DocgroupNewForm'])) {
$this->gvars['tabActive'] = 41;
$this->getSession()->set('tabActive', 41);
$docgroupNewForm->handleRequest($request);
if ($docgroupNewForm->isValid()) {
$dgtoclone = null;
$oldDocgroups = null;
if (null != $docgroupNewForm['clone']->getData()) {
$dgtoclone = $docgroupNewForm['clone']->getData();
$oldDocgroups = $em->getRepository('AcfDataBundle:Docgroup')->getAllChilds($dgtoclone);
}
$em->persist($docgroup);
$em->flush();
if (null != $dgtoclone && null != $oldDocgroups && \count($oldDocgroups) != 0) {
$docgroupsCloneArray = array();
foreach ($oldDocgroups as $oldDocgroup) {
$ndocgroup = new Docgroup();
$ndocgroup->setCompany($company);
$ndocgroup->setLabel($oldDocgroup->getLabel());
$ndocgroup->setOtherInfos($oldDocgroup->getOtherInfos());
if (null != $oldDocgroup->getParent() && $oldDocgroup->getParent()->getId() != $dgtoclone->getId()) {
$parentId = $oldDocgroup->getParent()->getId();
$ndocgroup->setParent($docgroupsCloneArray[$parentId]);
} else {
$ndocgroup->setParent($docgroup);
}
$docgroupsCloneArray[$oldDocgroup->getId()] = $ndocgroup;
$em->persist($ndocgroup);
}
}
$em->flush();
$this->flashMsgSession('success', $this->translate('Docgroup.add.success', array('%docgroup%' => $docgroup->getLabel())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Docgroup.add.failure'));
}
} elseif (isset($reqData['ShareholderNewForm'])) {
$this->gvars['tabActive'] = 42;
$this->getSession()->set('tabActive', 42);
$shareholderNewForm->handleRequest($request);
if ($shareholderNewForm->isValid()) {
$em->persist($shareholder);
$em->flush();
$this->flashMsgSession('success', $this->translate('Shareholder.add.success', array('%shareholder%' => $shareholder->getName())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Shareholder.add.failure'));
}
} elseif (isset($reqData['DocgroupfiscalNewForm'])) {
$this->gvars['tabActive'] = 51;
$this->getSession()->set('tabActive', 51);
$docgroupfiscalNewForm->handleRequest($request);
if ($docgroupfiscalNewForm->isValid()) {
$dgtoclone = null;
$oldDocgroupfiscals = null;
if (null != $docgroupfiscalNewForm['clone']->getData()) {
$dgtoclone = $docgroupfiscalNewForm['clone']->getData();
$oldDocgroupfiscals = $em->getRepository('AcfDataBundle:Docgroupfiscal')->getAllChilds($dgtoclone);
}
$em->persist($docgroupfiscal);
$em->flush();
if (null != $dgtoclone && null != $oldDocgroupfiscals && \count($oldDocgroupfiscals) != 0) {
$docgroupfiscalsCloneArray = array();
foreach ($oldDocgroupfiscals as $oldDocgroupfiscal) {
$ndocgroupfiscal = new Docgroupfiscal();
$ndocgroupfiscal->setCompany($company);
$ndocgroupfiscal->setLabel($oldDocgroupfiscal->getLabel());
$ndocgroupfiscal->setOtherInfos($oldDocgroupfiscal->getOtherInfos());
if (null != $oldDocgroupfiscal->getParent() && $oldDocgroupfiscal->getParent()->getId() != $dgtoclone->getId()) {
$parentId = $oldDocgroupfiscal->getParent()->getId();
$ndocgroupfiscal->setParent($docgroupfiscalsCloneArray[$parentId]);
} else {
$ndocgroupfiscal->setParent($docgroupfiscal);
}
$docgroupfiscalsCloneArray[$oldDocgroupfiscal->getId()] = $ndocgroupfiscal;
$em->persist($ndocgroupfiscal);
}
}
$em->flush();
$this->flashMsgSession('success', $this->translate('Docgroupfiscal.add.success', array('%docgroupfiscal%' => $docgroupfiscal->getLabel())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Docgroupfiscal.add.failure'));
}
} elseif (isset($reqData['DocgrouppersoNewForm'])) {
$this->gvars['tabActive'] = 61;
$this->getSession()->set('tabActive', 61);
$docgrouppersoNewForm->handleRequest($request);
if ($docgrouppersoNewForm->isValid()) {
$dgtoclone = null;
$oldDocgrouppersos = null;
if (null != $docgrouppersoNewForm['clone']->getData()) {
$dgtoclone = $docgrouppersoNewForm['clone']->getData();
$oldDocgrouppersos = $em->getRepository('AcfDataBundle:Docgroupperso')->getAllChilds($dgtoclone);
}
$em->persist($docgroupperso);
$em->flush();
if (null != $dgtoclone && null != $oldDocgrouppersos && \count($oldDocgrouppersos) != 0) {
$docgrouppersosCloneArray = array();
foreach ($oldDocgrouppersos as $oldDocgroupperso) {
$ndocgroupperso = new Docgroupperso();
$ndocgroupperso->setCompany($company);
$ndocgroupperso->setLabel($oldDocgroupperso->getLabel());
$ndocgroupperso->setOtherInfos($oldDocgroupperso->getOtherInfos());
if (null != $oldDocgroupperso->getParent() && $oldDocgroupperso->getParent()->getId() != $dgtoclone->getId()) {
$parentId = $oldDocgroupperso->getParent()->getId();
$ndocgroupperso->setParent($docgrouppersosCloneArray[$parentId]);
} else {
$ndocgroupperso->setParent($docgroupperso);
}
$docgrouppersosCloneArray[$oldDocgroupperso->getId()] = $ndocgroupperso;
$em->persist($ndocgroupperso);
}
}
$em->flush();
$this->flashMsgSession('success', $this->translate('Docgroupperso.add.success', array('%docgroupperso%' => $docgroupperso->getLabel())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Docgroupperso.add.failure'));
}
} elseif (isset($reqData['DocgroupsystNewForm'])) {
$this->gvars['tabActive'] = 71;
$this->getSession()->set('tabActive', 71);
$docgroupsystNewForm->handleRequest($request);
if ($docgroupsystNewForm->isValid()) {
$dgtoclone = null;
$oldDocgroupsysts = null;
if (null != $docgroupsystNewForm['clone']->getData()) {
$dgtoclone = $docgroupsystNewForm['clone']->getData();
$oldDocgroupsysts = $em->getRepository('AcfDataBundle:Docgroupsyst')->getAllChilds($dgtoclone);
}
$em->persist($docgroupsyst);
$em->flush();
if (null != $dgtoclone && null != $oldDocgroupsysts && \count($oldDocgroupsysts) != 0) {
$docgroupsystsCloneArray = array();
foreach ($oldDocgroupsysts as $oldDocgroupsyst) {
$ndocgroupsyst = new Docgroupsyst();
$ndocgroupsyst->setCompany($company);
$ndocgroupsyst->setLabel($oldDocgroupsyst->getLabel());
$ndocgroupsyst->setOtherInfos($oldDocgroupsyst->getOtherInfos());
if (null != $oldDocgroupsyst->getParent() && $oldDocgroupsyst->getParent()->getId() != $dgtoclone->getId()) {
$parentId = $oldDocgroupsyst->getParent()->getId();
$ndocgroupsyst->setParent($docgroupsystsCloneArray[$parentId]);
} else {
$ndocgroupsyst->setParent($docgroupsyst);
}
$docgroupsystsCloneArray[$oldDocgroupsyst->getId()] = $ndocgroupsyst;
$em->persist($ndocgroupsyst);
}
}
$em->flush();
$this->flashMsgSession('success', $this->translate('Docgroupsyst.add.success', array('%docgroupsyst%' => $docgroupsyst->getLabel())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Docgroupsyst.add.failure'));
}
} elseif (isset($reqData['DocgroupauditNewForm'])) {
$this->gvars['tabActive'] = 81;
$this->getSession()->set('tabActive', 81);
$docgroupauditNewForm->handleRequest($request);
if ($docgroupauditNewForm->isValid()) {
$dgtoclone = null;
$oldDocgroupaudits = null;
if (null != $docgroupauditNewForm['clone']->getData()) {
$dgtoclone = $docgroupauditNewForm['clone']->getData();
$oldDocgroupaudits = $em->getRepository('AcfDataBundle:Docgroupaudit')->getAllChilds($dgtoclone);
}
$em->persist($docgroupaudit);
$em->flush();
if (null != $dgtoclone && null != $oldDocgroupaudits && \count($oldDocgroupaudits) != 0) {
$docgroupauditsCloneArray = array();
foreach ($oldDocgroupaudits as $oldDocgroupaudit) {
$ndocgroupaudit = new Docgroupaudit();
$ndocgroupaudit->setCompany($company);
$ndocgroupaudit->setLabel($oldDocgroupaudit->getLabel());
$ndocgroupaudit->setOtherInfos($oldDocgroupaudit->getOtherInfos());
if (null != $oldDocgroupaudit->getParent() && $oldDocgroupaudit->getParent()->getId() != $dgtoclone->getId()) {
$parentId = $oldDocgroupaudit->getParent()->getId();
$ndocgroupaudit->setParent($docgroupauditsCloneArray[$parentId]);
} else {
$ndocgroupaudit->setParent($docgroupaudit);
}
$docgroupauditsCloneArray[$oldDocgroupaudit->getId()] = $ndocgroupaudit;
$em->persist($ndocgroupaudit);
}
}
$em->flush();
$this->flashMsgSession('success', $this->translate('Docgroupaudit.add.success', array('%docgroupaudit%' => $docgroupaudit->getLabel())));
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
return $this->redirect($urlFrom);
} else {
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('Docgroupaudit.add.failure'));
}
} elseif (isset($reqData['MPayeNewForm'])) {
$this->gvars['tabActive'] = 101;
$this->getSession()->set('tabActive', 101);
$mpayeNewForm->handleRequest($request);
if ($mpayeNewForm->isValid()) {
$mpaye->generateRef();
$em->persist($mpaye);
$em->flush();
$this->flashMsgSession('success', $this->translate('MPaye.add.success', array('%mpaye%' => $mpaye->getRef())));
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('MPaye.add.failure'));
}
} elseif (isset($reqData['MPayeNewYearForm'])) {
$this->gvars['tabActive'] = 101;
$this->getSession()->set('tabActive', 101);
$mpayeNewYearForm->handleRequest($request);
if ($mpayeNewYearForm->isValid()) {
$year = $mpayeNewYearForm['year']->getData();
foreach (MPaye::choiceMonthCallback() as $month) {
$mpaye = $em->getRepository('AcfDataBundle:MPaye')->findOneBy(array('company' => $company, 'year' => $year, 'month' => $month));
if (null == $mpaye) {
$mpaye = new MPaye();
$mpaye->setCompany($company);
$mpaye->setYear($year);
$mpaye->setMonth($month);
$mpaye->generateRef();
$em->persist($mpaye);
$this->flashMsgSession('success', $this->translate('MPaye.add.success', array('%mpaye%' => $mpaye->getRef())));
}
}
$em->flush();
$this->gvars['stabActive'] = 3;
$this->getSession()->set('stabActive', 3);
return $this->redirect($urlFrom);
} else {
$this->gvars['stabActive'] = 2;
$this->getSession()->set('stabActive', 2);
$em->refresh($company);
$this->flashMsgSession('error', $this->translate('MPaye.add.failure'));
}
}
$sector = new Sector();
$sectorNewForm = $this->createForm(SectorNewTForm::class, $sector);
$this->gvars['sector'] = $sector;
$this->gvars['SectorNewForm'] = $sectorNewForm->createView();
$this->gvars['company'] = $company;
$this->gvars['stock'] = $stock;
$this->gvars['address'] = $address;
$this->gvars['phone'] = $phone;
$this->gvars['companyFrame'] = $companyFrame;
$this->gvars['companyNature'] = $companyNature;
$this->gvars['doc'] = $doc;
$this->gvars['pilot'] = $pilot;
$this->gvars['companyUser'] = $companyUser;
$this->gvars['companyAdmin'] = $companyAdmin;
$this->gvars['companyLabel'] = $companyLabel;
$this->gvars['customer'] = $customer;
$this->gvars['supplier'] = $supplier;
$this->gvars['bank'] = $bank;
$this->gvars['fund'] = $fund;
$this->gvars['withholding'] = $withholding;
$this->gvars['docgroupcomptable'] = $docgroupcomptable;
$this->gvars['shareholder'] = $withholding;
$this->gvars['docgroup'] = $docgroup;
$this->gvars['docgroupfiscal'] = $docgroupfiscal;
$this->gvars['docgroupperso'] = $docgroupperso;
$this->gvars['docgroupsyst'] = $docgroupsyst;
$this->gvars['docgroupaudit'] = $docgroupaudit;
$this->gvars['docgroupbank'] = $docgroupbank;
$this->gvars['docgroupcomptables'] = $em->getRepository('AcfDataBundle:Docgroupcomptable')->getRoots($company);
$this->gvars['docgroups'] = $em->getRepository('AcfDataBundle:Docgroup')->getRoots($company);
$this->gvars['docgroupfiscals'] = $em->getRepository('AcfDataBundle:Docgroupfiscal')->getRoots($company);
$this->gvars['docgrouppersos'] = $em->getRepository('AcfDataBundle:Docgroupperso')->getRoots($company);
$this->gvars['docgroupsysts'] = $em->getRepository('AcfDataBundle:Docgroupsyst')->getRoots($company);
$this->gvars['docgroupbanks'] = $em->getRepository('AcfDataBundle:Docgroupbank')->getRoots($company);
$this->gvars['docgroupaudits'] = $em->getRepository('AcfDataBundle:Docgroupaudit')->getRoots($company);
$this->gvars['CompanyUpdateTypeForm'] = $companyUpdateTypeForm->createView();
$this->gvars['CompanyUpdateCorporateNameForm'] = $companyUpdateCorporateNameForm->createView();
$this->gvars['CompanyUpdateFiscForm'] = $companyUpdateFiscForm->createView();
$this->gvars['CompanyUpdateTribunalForm'] = $companyUpdateTribunalForm->createView();
$this->gvars['CompanyUpdatePhysicaltypeForm'] = $companyUpdatePhysicaltypeForm->createView();
$this->gvars['CompanyUpdateCnssForm'] = $companyUpdateCnssForm->createView();
$this->gvars['CompanyUpdateCnssBureauForm'] = $companyUpdateCnssBureauForm->createView();
$this->gvars['CompanyUpdateSectorsForm'] = $companyUpdateSectorsForm->createView();
$this->gvars['CompanyUpdatePhoneForm'] = $companyUpdatePhoneForm->createView();
$this->gvars['CompanyUpdateMobileForm'] = $companyUpdateMobileForm->createView();
$this->gvars['CompanyUpdateFaxForm'] = $companyUpdateFaxForm->createView();
$this->gvars['CompanyUpdateEmailForm'] = $companyUpdateEmailForm->createView();
$this->gvars['CompanyUpdateAdrForm'] = $companyUpdateAdrForm->createView();
$this->gvars['CompanyUpdateOtherInfosForm'] = $companyUpdateOtherInfosForm->createView();
$this->gvars['CompanyUpdateActionvnForm'] = $companyUpdateActionvnForm->createView();
$this->gvars['CompanyUpdateRefForm'] = $companyUpdateRefForm->createView();
$this->gvars['StockNewForm'] = $stockNewForm->createView();
$this->gvars['AddressNewForm'] = $addressNewForm->createView();
$this->gvars['PhoneNewForm'] = $phoneNewForm->createView();
$this->gvars['CompanyFrameNewForm'] = $companyFrameNewForm->createView();
$this->gvars['CompanyNatureNewForm'] = $companyNatureNewForm->createView();
$this->gvars['CompanyNatureImportForm'] = $companyNatureImportForm->createView();
$this->gvars['DocNewForm'] = $docNewForm->createView();
$this->gvars['PilotNewForm'] = $pilotNewForm->createView();
$this->gvars['CompanyUserNewForm'] = $companyUserNewForm->createView();
$this->gvars['CompanyAdminNewForm'] = $companyAdminNewForm->createView();
$this->gvars['CompanyLabelNewForm'] = $companyLabelNewForm->createView();
$this->gvars['CompanyLabelImportForm'] = $companyLabelImportForm->createView();
$this->gvars['CustomerNewForm'] = $customerNewForm->createView();
$this->gvars['CustomerImportForm'] = $customerImportForm->createView();
$this->gvars['SupplierNewForm'] = $supplierNewForm->createView();
$this->gvars['SupplierImportForm'] = $supplierImportForm->createView();
$this->gvars['BankNewForm'] = $bankNewForm->createView();
$this->gvars['BankImportForm'] = $bankImportForm->createView();
$this->gvars['FundNewForm'] = $fundNewForm->createView();
$this->gvars['FundImportForm'] = $fundImportForm->createView();
$this->gvars['WithholdingNewForm'] = $withholdingNewForm->createView();
$this->gvars['WithholdingImportForm'] = $withholdingImportForm->createView();
$this->gvars['MBSaleNewForm'] = $mbsaleNewForm->createView();
$this->gvars['MBPurchaseNewForm'] = $mbpurchaseNewForm->createView();
$this->gvars['MBSaleNewYearForm'] = $mbsaleNewYearForm->createView();
$this->gvars['MBPurchaseNewYearForm'] = $mbpurchaseNewYearForm->createView();
$this->gvars['MPayeNewForm'] = $mpayeNewForm->createView();
$this->gvars['MPayeNewYearForm'] = $mpayeNewYearForm->createView();
$this->gvars['DocgroupcomptableNewForm'] = $docgroupcomptableNewForm->createView();
$this->gvars['DocgroupNewForm'] = $docgroupNewForm->createView();
$this->gvars['ShareholderNewForm'] = $shareholderNewForm->createView();
$this->gvars['DocgroupfiscalNewForm'] = $docgroupfiscalNewForm->createView();
$this->gvars['DocgrouppersoNewForm'] = $docgrouppersoNewForm->createView();
$this->gvars['DocgroupsystNewForm'] = $docgroupsystNewForm->createView();
$this->gvars['DocgroupauditNewForm'] = $docgroupauditNewForm->createView();
$this->gvars['DocgroupbankNewForm'] = $docgroupbankNewForm->createView();
$mbsaleYears = $em->getRepository('AcfDataBundle:MBSale')->getAllYearByCompany($company);
$mbpurchaseYears = $em->getRepository('AcfDataBundle:MBPurchase')->getAllYearByCompany($company);
$mpayeYears = $em->getRepository('AcfDataBundle:MPaye')->getAllYearByCompany($company);
$this->gvars['mbsaleYears'] = $mbsaleYears;
$this->gvars['mbpurchaseYears'] = $mbpurchaseYears;
$this->gvars['mpayeYears'] = $mpayeYears;
$customersConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'customersPrefix'));
if (null == $customersConstStr) {
$customersConstStr = new ConstantStr();
$customersConstStr->setName('customersPrefix');
$customersConstStr->setValue('411');
$em->persist($customersConstStr);
$em->flush();
}
$customersPrefix = $customersConstStr->getValue();
$this->gvars['customersPrefix'] = $customersPrefix;
$suppliersConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'suppliersPrefix'));
if (null == $suppliersConstStr) {
$suppliersConstStr = new ConstantStr();
$suppliersConstStr->setName('suppliersPrefix');
$suppliersConstStr->setValue('401');
$em->persist($suppliersConstStr);
$em->flush();
}
$suppliersPrefix = $suppliersConstStr->getValue();
$this->gvars['suppliersPrefix'] = $suppliersPrefix;
$banksConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'banksPrefix'));
if (null == $banksConstStr) {
$banksConstStr = new ConstantStr();
$banksConstStr->setName('banksPrefix');
$banksConstStr->setValue('532');
$em->persist($banksConstStr);
$em->flush();
}
$banksPrefix = $banksConstStr->getValue();
$this->gvars['banksPrefix'] = $banksPrefix;
$fundsConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'fundsPrefix'));
if (null == $fundsConstStr) {
$fundsConstStr = new ConstantStr();
$fundsConstStr->setName('fundsPrefix');
$fundsConstStr->setValue('540');
$em->persist($fundsConstStr);
$em->flush();
}
$fundsPrefix = $fundsConstStr->getValue();
$this->gvars['fundsPrefix'] = $fundsPrefix;
$withholdingsConstStr = $em->getRepository('AcfDataBundle:ConstantStr')->findOneBy(array('name' => 'withholdingsPrefix'));
if (null == $withholdingsConstStr) {
$withholdingsConstStr = new ConstantStr();
$withholdingsConstStr->setName('withholdingsPrefix');
$withholdingsConstStr->setValue('432');
$em->persist($withholdingsConstStr);
$em->flush();
}
$withholdingsPrefix = $withholdingsConstStr->getValue();
$this->gvars['withholdingsPrefix'] = $withholdingsPrefix;
$this->gvars['pagetitle'] = $this->translate('pagetitle.company.edit', array('%company%' => $company->getCorporateName()));
$this->gvars['pagetitle_txt'] = $this->translate('pagetitle.company.edit.txt', array('%company%' => $company->getCorporateName()));
return $this->renderResponse('AcfAdminBundle:Company:edit.html.twig', $this->gvars);
}
} catch (\Exception $e) {
$logger = $this->getLogger();
$logger->addCritical($e->getLine() . ' ' . $e->getMessage() . ' ' . $e->getTraceAsString());
}
return $this->redirect($urlFrom);
}