/** * Form builder * * @param FormBuilderInterface $builder * @param array $options * * @return null */ public function buildForm(FormBuilderInterface $builder, array $options) { $this->sale = $options['sale']; if (null == $this->sale) { $builder->add('sale', EntityType::class, array('label' => 'SecondatVat.sale.label', 'class' => 'AcfDataBundle:Sale', 'query_builder' => function (SaleRepository $sr) { return $sr->createQueryBuilder('s')->orderBy('s.number', 'ASC'); }, 'choice_label' => 'number', 'multiple' => false, 'by_reference' => true, 'required' => true)); } else { $saleId = $this->sale->getId(); $builder->add('sale', EntityidType::class, array('label' => 'SecondatVat.sale.label', 'class' => 'AcfDataBundle:Sale', 'query_builder' => function (SaleRepository $sr) use($saleId) { return $sr->createQueryBuilder('s')->where('s.id = :id')->setParameter('id', $saleId)->orderBy('s.number', 'ASC'); }, 'choice_label' => 'id', 'multiple' => false, 'by_reference' => true, 'required' => true)); } $builder->add('vat', NumberType::class, array('label' => 'SecondaryVat.vat.label')); $builder->add('balanceTtc', NumberType::class, array('label' => 'SecondaryVat.balanceTtc.label')); $builder->add('balanceNet', NumberType::class, array('label' => 'SecondaryVat.balanceNet.label')); $builder->add('vatInfo', ChoiceType::class, array('label' => 'SecondaryVat.vatInfo.label', 'choices_as_values' => true, 'choices' => SecondaryVat::choiceVatInfo(), 'attr' => array('choice_label_trans' => true))); }
/** * Form builder * * @param FormBuilderInterface $builder * @param array $options */ public function buildForm(FormBuilderInterface $builder, array $options) { $builder->add('validated', ChoiceType::class, array('label' => 'Sale.validated.label', 'choices_as_values' => true, 'choices' => Sale::choiceValidated(), 'expanded' => true, 'attr' => array('choice_label_trans' => true))); }
/** * Form builder * * @param FormBuilderInterface $builder * @param array $options */ public function buildForm(FormBuilderInterface $builder, array $options) { $builder->add('paymentType', ChoiceType::class, array('label' => 'Sale.paymentType.label', 'choices_as_values' => true, 'choices' => Sale::choicePaymentType(), 'attr' => array('choice_label_trans' => true))); }
/** * * @param string $uid * * @return Response * */ public function editPostAction($uid) { $urlFrom = $this->getReferer(); if (null == $urlFrom || trim($urlFrom) == '') { $urlFrom = $this->generateUrl('_admin_company_list'); } $em = $this->getEntityManager(); try { $mbsale = $em->getRepository('AcfDataBundle:MBSale')->find($uid); if (null == $mbsale) { $this->flashMsgSession('warning', $this->translate('MBSale.edit.notfound')); } else { $traces = $em->getRepository('AcfDataBundle:Trace')->getAllByEntityId($mbsale->getId(), Trace::AE_MBSALE); $this->gvars['traces'] = array_reverse($traces); $mbsaleUpdateCountForm = $this->createForm(MBSaleUpdateCountTForm::class, $mbsale); $sale = new Sale(); $sale->setMonthlyBalance($mbsale); $saleNewForm = $this->createForm(SaleNewTForm::class, $sale, array('monthlybalance' => $mbsale)); $saleImportForm = $this->createForm(SaleImportTForm::class); $mbsaleUpdateDocsForm = $this->createForm(MBSaleUpdateDocsTForm::class, $mbsale, array('company' => $mbsale->getCompany())); $doc = new Doc(); $doc->setCompany($mbsale->getCompany()); $docNewForm = $this->createForm(DocNewTForm::class, $doc, array('company' => $mbsale->getCompany())); $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(); $cloneMBSale = clone $mbsale; if (isset($reqData['SaleImportForm'])) { $this->gvars['tabActive'] = 2; $this->getSession()->set('tabActive', 2); $this->gvars['stabActive'] = 1; $this->getSession()->set('stabActive', 1); $saleImportForm->handleRequest($request); if ($saleImportForm->isValid()) { ini_set('memory_limit', '4096M'); ini_set('max_execution_time', '0'); $extension = $saleImportForm['excel']->getData()->guessExtension(); if ($extension == 'zip') { $extension = 'xlsx'; } $filename = uniqid() . '.' . $extension; $saleImportForm['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); $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 = 0; $salesNew = 0; $lineUnprocessed = 0; $lineError = 0; $company = $mbsale->getCompany(); $accounts = $em->getRepository('AcfDataBundle:Account')->getAllByCompany($company); $customers = $em->getRepository('AcfDataBundle:Customer')->getAllByCompany($company); $withholdings = $em->getRepository('AcfDataBundle:Withholding')->getAllByCompany($company); $prevbill = null; $haspreverror = false; for ($row = 1; $row <= $highestRow; $row++) { $lineRead++; $dtActivation = \PHPExcel_Shared_Date::ExcelToPHPObject($worksheet->getCellByColumnAndRow(1, $row)->getValue()); $bill = \trim(\strval($worksheet->getCellByColumnAndRow(2, $row)->getValue())); $customerNum = \intval($worksheet->getCellByColumnAndRow(4, $row)->getValue()); $label = \trim(\strval($worksheet->getCellByColumnAndRow(5, $row)->getValue())); $vat = \floatval($worksheet->getCellByColumnAndRow(7, $row)->getValue()); $stamp = \floatval($worksheet->getCellByColumnAndRow(8, $row)->getValue()); $balanceTtc = \floatval($worksheet->getCellByColumnAndRow(9, $row)->getValue()); $vatInfo = \trim(\strval($worksheet->getCellByColumnAndRow(10, $row)->getValue())); $regime = \trim(\strval($worksheet->getCellByColumnAndRow(11, $row)->getValue())); $withholdingValue = \trim(\strval($worksheet->getCellByColumnAndRow(13, $row)->getValue() * 100)); $balanceNet = \floatval($worksheet->getCellByColumnAndRow(14, $row)->getValue()); $paymentType = \trim(\strval($worksheet->getCellByColumnAndRow(15, $row)->getValue())); $dtPayment = \PHPExcel_Shared_Date::ExcelToPHPObject($worksheet->getCellByColumnAndRow(16, $row)->getValue()); $accountLabel = \trim(\strval($worksheet->getCellByColumnAndRow(17, $row)->getValue())); $status = \trim(\strval($worksheet->getCellByColumnAndRow(18, $row)->getValue())); $otherInfos = \trim(\strval($worksheet->getCellByColumnAndRow(19, $row)->getValue())); if ($customerNum != '' && \is_numeric($customerNum)) { $customerNum = \intval($customerNum) - $customersPrefixNum; } $haserror = false; if (null == $dtActivation) { $haserror = true; $log .= 'ligne ' . $lineRead . ", erreur : Date d'activation<br>"; } if ($bill == '') { $haserror = true; $log .= 'ligne ' . $lineRead . ', erreur : Numéro Facture<br>'; } if ($customerNum == '' || $customerNum <= 0) { $haserror = true; $oldcustomnum = $worksheet->getCellByColumnAndRow(4, $row)->getValue(); $log .= 'ligne ' . $lineRead . ', erreur : Numéro Client (' . $oldcustomnum . ')<br>'; } else { $customer = null; $knownCustomer = false; foreach ($customers as $s) { if ($s->getNumber() == $customerNum) { $knownCustomer = true; $customer = $s; } } if ($knownCustomer == false) { $haserror = true; $log .= 'ligne ' . $lineRead . ', erreur : Client Inconnu<br>'; } } if ($label == '') { $haserror = true; $log .= 'ligne ' . $lineRead . ', erreur : Libélé<br>'; } if ($vat < 0) { $haserror = true; $log .= 'ligne ' . $lineRead . ', erreur : TVA<br>'; } if ($stamp < 0) { $haserror = true; $log .= 'ligne ' . $lineRead . ', erreur : Timbre<br>'; } if ($balanceTtc < 0) { $haserror = true; $log .= 'ligne ' . $lineRead . ', erreur : TTC<br>'; } if ($vatInfo == $this->translate('Transaction.vatInfo.0')) { $vatInfo = 0; } elseif ($vatInfo == $this->translate('Transaction.vatInfo.6')) { $vatInfo = 6; } elseif ($vatInfo == $this->translate('Transaction.vatInfo.12')) { $vatInfo = 12; } elseif ($vatInfo == $this->translate('Transaction.vatInfo.18')) { $vatInfo = 18; } else { $vatInfo = 0; $log .= 'ligne ' . $lineRead . ', erreur (ignorée) : TVA PR INFO inconnu => ' . $this->translate('Transaction.vatInfo.0') . '<br>'; } if ($regime == $this->translate('Sale.regime.0')) { $regime = 0; } elseif ($regime == $this->translate('Sale.regime.1')) { $regime = 1; } elseif ($regime == $this->translate('Sale.regime.2')) { $regime = 2; } elseif ($regime == $this->translate('Sale.regime.3')) { $regime = 3; } else { $regime = 0; $log .= 'ligne ' . $lineRead . ', erreur (ignorée) : Régime inconnu => ' . $this->translate('Sale.regime.0') . '<br>'; } $withholding = null; $knownWithholding = false; foreach ($withholdings as $w) { if ($w->getValue() == $withholdingValue || $w->getLabel() == $withholdingValue) { $knownWithholding = true; $withholding = $w; } } if ($knownWithholding == false) { $haserror = true; $log .= 'ligne ' . $lineRead . ', erreur : Retenue Inconnue ' . $withholdingValue . '<br>'; } if ($balanceNet < 0) { $haserror = true; $log .= 'ligne ' . $lineRead . ', erreur : Net à Encaisser<br>'; } if ($paymentType == $this->translate('Transaction.paymentType.0')) { $paymentType = 0; } elseif ($paymentType == $this->translate('Transaction.paymentType.1')) { $paymentType = 1; } elseif ($paymentType == $this->translate('Transaction.paymentType.2')) { $paymentType = 2; } elseif ($paymentType == $this->translate('Transaction.paymentType.3')) { $paymentType = 3; } elseif ($paymentType == $this->translate('Transaction.paymentType.4')) { $paymentType = 4; } else { $paymentType = 0; $log .= 'ligne ' . $lineRead . ", erreur (ignorée) : Type d'Encaissement inconnu => " . $this->translate('Transaction.paymentType.0') . '<br>'; } if (null == $dtPayment) { $haserror = true; $log .= 'ligne ' . $lineRead . ", erreur : Date d'Encaissement<br>"; } $account = null; $knownAccount = false; foreach ($accounts as $a) { if ($a->getLabel() == $accountLabel) { $knownAccount = true; $account = $a; } } if ($knownAccount == false) { $haserror = true; $log .= 'ligne ' . $lineRead . ', erreur : Banque/Caisse Inconnue<br>'; } if ($status == $this->translate('Transaction.transactionStatus.0')) { $status = 0; } elseif ($status == $this->translate('Transaction.transactionStatus.1')) { $status = 1; } elseif ($status == $this->translate('Transaction.transactionStatus.10')) { $status = 10; } else { $status = 0; $log .= 'ligne ' . $lineRead . ', erreur (ignorée) : Etat inconnu => ' . $this->translate('Transaction.transactionStatus.0') . '<br>'; } if ($haserror == false) { if ($bill != $prevbill) { $sale = $em->getRepository('AcfDataBundle:Sale')->findOneBy(array('monthlyBalance' => $mbsale, 'bill' => $bill)); if (null == $sale) { $salesNew++; $sale = new Sale(); $sale->setMonthlyBalance($mbsale); $sale->setNumber($mbsale->getCount()); $sale->setDtActivation($dtActivation); $sale->setBill($bill); $sale->setRelation($customer); $sale->setLabel($label); $sale->setVat($vat); $sale->setVatDevise($vat); $sale->setStamp($stamp); $sale->setStampDevise($stamp); $sale->setBalanceTtc($balanceTtc); $sale->setBalanceTtcDevise($balanceTtc); $sale->setVatInfo($vatInfo); $sale->setRegime($regime); $sale->setWithholding($withholding); $sale->setBalanceNet($balanceNet); $sale->setBalanceNetDevise($balanceNet); $sale->setPaymentType($paymentType); $sale->setDtPayment($dtPayment); $sale->setAccount($account); $sale->setTransactionStatus($status); $sale->setOtherInfos($otherInfos); $em->persist($sale); $mbsale->updateCount(); $em->persist($mbsale); $haspreverror = false; } else { $lineUnprocessed++; $log .= "l'Achat à la ligne " . $lineRead . ' existe déjà<br>'; $haspreverror = true; } } else { if ($haspreverror == false) { $secondaryVat = new SecondaryVat(); $secondaryVat->setSale($sale); $secondaryVat->setBalanceNet($balanceNet); $secondaryVat->setBalanceTtc($balanceTtc); $secondaryVat->setVat($vat); $secondaryVat->setVatInfo($vatInfo); $em->persist($secondaryVat); } else { $lineUnprocessed++; $log .= "l'Achat à la ligne " . $lineRead . ' existe déjà<br>'; $haspreverror = true; } } } else { $lineError++; $log .= 'la ligne ' . $lineRead . ' contient des erreurs<br>'; } $prevbill = $bill; } $em->flush(); $log .= $lineRead . ' lignes lues<br>'; $log .= $salesNew . ' nouvelles Ventes<br>'; $log .= $lineUnprocessed . ' Ventes déjà dans la base<br>'; $log .= $lineError . ' lignes contenant des erreurs<br>'; // */ $this->flashMsgSession('log', $log); $this->flashMsgSession('success', $this->translate('Sale.import.success')); $this->gvars['tabActive'] = 1; $this->getSession()->set('tabActive', 1); return $this->redirect($urlFrom); } else { $em->refresh($mbsale); $this->flashMsgSession('error', $this->translate('Sale.import.failure')); } } elseif (isset($reqData['SaleNewForm'])) { $this->gvars['tabActive'] = 2; $this->getSession()->set('tabActive', 2); $this->gvars['stabActive'] = 2; $this->getSession()->set('stabActive', 2); $saleNewForm->handleRequest($request); if ($saleNewForm->isValid()) { $sale->setNumber($mbsale->getCount()); if ($sale->getDevise() == 'TND') { $sale->setConversionRate(1); $sale->setVatDevise($sale->getVat()); $sale->setStampDevise($sale->getStamp()); $sale->setBalanceTtcDevise($sale->getBalanceTtc()); $sale->setBalanceNetDevise($sale->getBalanceNet()); } else { $sale->setVat($sale->getVatDevise() * $sale->getConversionRate()); $sale->setStamp($sale->getStampDevise() * $sale->getConversionRate()); $sale->setBalanceTtc($sale->getBalanceTtcDevise() * $sale->getConversionRate()); $sale->setBalanceNet($sale->getBalanceNetDevise() * $sale->getConversionRate()); } foreach ($saleNewForm->get('docs') as $docNewForm) { $docFile = $docNewForm['fileName']->getData(); $docDir = $this->getParameter('kernel.root_dir') . '/../web/res/docs'; $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 = $docNewForm->getData(); $doc->setCompany($mbsale->getCompany()); $doc->setFileName($fileName); $doc->setOriginalName($originalName); $doc->setSize($size); $doc->setMimeType($mimeType); $doc->setMd5($md5); $doc->setDescription($docNewForm['description']->getData()); $em->persist($doc); $sale->addDoc($doc); } $em->persist($sale); foreach ($saleNewForm->get('secondaryVats') as $secondaryVatNewForm) { $secondaryVat = $secondaryVatNewForm->getData(); $secondaryVat->setSale($sale); $sale->addSecondaryVat($secondaryVat); $em->persist($secondaryVat); $em->persist($sale); } $em->flush(); $mbsale->updateCount(); $em->persist($mbsale); $em->flush(); $this->flashMsgSession('success', $this->translate('Sale.add.success', array('%sale%' => $sale->getNumber()))); $this->gvars['tabActive'] = 1; $this->getSession()->set('tabActive', 1); $this->gvars['stabActive'] = 1; $this->getSession()->set('stabActive', 1); return $this->redirect($urlFrom); } else { $em->refresh($mbsale); $this->flashMsgSession('error', $this->translate('Sale.add.failure')); } } elseif (isset($reqData['MBSaleUpdateCountForm'])) { $this->gvars['tabActive'] = 3; $this->getSession()->set('tabActive', 3); $mbsaleUpdateCountForm->handleRequest($request); if ($mbsaleUpdateCountForm->isValid()) { $em->persist($mbsale); $em->flush(); $this->flashMsgSession('success', $this->translate('MBSale.edit.success', array('%mbsale%' => $mbsale->getRef()))); $this->traceEntity($cloneMBSale, $mbsale); return $this->redirect($urlFrom); } else { $em->refresh($mbsale); $this->flashMsgSession('error', $this->translate('MBSale.edit.failure', array('%mbsale%' => $mbsale->getRef()))); } } elseif (isset($reqData['DocNewForm'])) { $this->gvars['tabActive'] = 4; $this->getSession()->set('tabActive', 4); $this->gvars['stabActive'] = 1; $this->getSession()->set('stabActive', 1); $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($mbsale->getCompany()); $doc->setFileName($fileName); $doc->setOriginalName($originalName); $doc->setSize($size); $doc->setMimeType($mimeType); $doc->setMd5($md5); $doc->setDescription($docNewForm['description']->getData()); $em->persist($doc); $mbsale->addDoc($doc); $docNames .= $doc->getOriginalName() . ' '; $docs[] = $doc; } $em->persist($mbsale); $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'); $company = $mbsale->getCompany(); $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'] = 3; $this->getSession()->set('stabActive', 3); $this->traceEntity($cloneMBSale, $mbsale); return $this->redirect($urlFrom); } else { $em->refresh($mbsale); $this->flashMsgSession('error', $this->translate('Doc.add.failure')); } } elseif (isset($reqData['MBSaleUpdateDocsForm'])) { $this->gvars['tabActive'] = 4; $this->getSession()->set('tabActive', 4); $this->gvars['stabActive'] = 2; $this->getSession()->set('stabActive', 2); $mbsaleUpdateDocsForm->handleRequest($request); if ($mbsaleUpdateDocsForm->isValid()) { $em->persist($mbsale); $em->flush(); $this->flashMsgSession('success', $this->translate('MBSale.edit.success', array('%mbsale%' => $mbsale->getRef()))); $this->gvars['stabActive'] = 3; $this->getSession()->set('stabActive', 3); $this->traceEntity($cloneMBSale, $mbsale); return $this->redirect($urlFrom); } else { $em->refresh($mbsale); $this->flashMsgSession('error', $this->translate('MBSale.edit.failure', array('%mbsale%' => $mbsale->getRef()))); } } $this->gvars['mbsale'] = $mbsale; $this->gvars['sale'] = $sale; $this->gvars['doc'] = $doc; $this->gvars['SaleNewForm'] = $saleNewForm->createView(); $this->gvars['SaleImportForm'] = $saleImportForm->createView(); $this->gvars['MBSaleUpdateCountForm'] = $mbsaleUpdateCountForm->createView(); $this->gvars['MBSaleUpdateDocsForm'] = $mbsaleUpdateDocsForm->createView(); $this->gvars['DocNewForm'] = $docNewForm->createView(); $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; $this->gvars['pagetitle'] = $this->translate('pagetitle.mbsale.edit', array('%mbsale%' => $mbsale->getRef())); $this->gvars['pagetitle_txt'] = $this->translate('pagetitle.mbsale.edit.txt', array('%mbsale%' => $mbsale->getRef())); return $this->renderResponse('AcfAdminBundle:MBSale:edit.html.twig', $this->gvars); } } catch (\Exception $e) { $logger = $this->getLogger(); $logger->addCritical($e->getLine() . ' ' . $e->getMessage() . ' ' . $e->getTraceAsString()); } return $this->redirect($urlFrom); }
/** * Form builder * * @param FormBuilderInterface $builder * @param array $options */ public function buildForm(FormBuilderInterface $builder, array $options) { $builder->add('transactionStatus', ChoiceType::class, array('label' => 'Sale.transactionStatus.label', 'choices_as_values' => true, 'choices' => Sale::choiceTransactionStatus(), 'expanded' => true, 'attr' => array('choice_label_trans' => true))); $builder->add('dtPayment', DateType::class, array('label' => 'Sale.dtPayment.label', 'widget' => 'single_text', 'format' => 'yyyy-MM-dd')); }
/** * Form builder * * @param FormBuilderInterface $builder * @param array $options * * @return null */ public function buildForm(FormBuilderInterface $builder, array $options) { $this->mbsale = $options['monthlybalance']; if (null == $this->mbsale) { $builder->add('monthlyBalance', EntityType::class, array('label' => 'Sale.monthlyBalance.label', 'class' => 'AcfDataBundle:MBSale', 'query_builder' => function (MBSaleRepository $mbsr) { return $mbsr->createQueryBuilder('mbs')->orderBy('mbs.ref', 'ASC'); }, 'choice_label' => 'ref', 'multiple' => false, 'by_reference' => true, 'required' => true)); } else { $mbsaleId = $this->mbsale->getId(); $builder->add('monthlyBalance', EntityidType::class, array('label' => 'Sale.monthlyBalance.label', 'class' => 'AcfDataBundle:MBSale', 'query_builder' => function (MBSaleRepository $mbsr) use($mbsaleId) { return $mbsr->createQueryBuilder('mbs')->where('mbs.id = :id')->setParameter('id', $mbsaleId)->orderBy('mbs.ref', 'ASC'); }, 'choice_label' => 'id', 'multiple' => false, 'by_reference' => true, 'required' => true)); } $builder->add('dtActivation', DateType::class, array('label' => 'Sale.dtActivation.label', 'widget' => 'single_text', 'format' => 'yyyy-MM-dd')); $builder->add('bill', TextType::class, array('label' => 'Sale.bill.label')); if (null == $this->mbsale) { $builder->add('relation', EntityType::class, array('label' => 'Sale.relation.label', 'class' => 'AcfDataBundle:Customer', 'query_builder' => function (CustomerRepository $sr) { return $sr->createQueryBuilder('s')->orderBy('s.label', 'ASC'); }, 'choice_label' => 'label', 'multiple' => false, 'by_reference' => true, 'required' => true)); } else { $companyId = $this->mbsale->getCompany()->getId(); $builder->add('relation', EntityType::class, array('label' => 'Sale.relation.label', 'class' => 'AcfDataBundle:Customer', 'query_builder' => function (CustomerRepository $sr) use($companyId) { return $sr->createQueryBuilder('s')->join('s.company', 'c')->where('c.id = :cid')->setParameter('cid', $companyId)->orderBy('s.label', 'ASC'); }, 'choice_label' => 'label', 'multiple' => false, 'by_reference' => true, 'required' => true)); } $builder->add('label', TextType::class, array('label' => 'Sale.label.label')); $builder->add('devise', CurrencyType::class, array('label' => 'Sale.devise.label')); $builder->add('conversionRate', NumberType::class, array('label' => 'Sale.conversionRate.label')); $builder->add('vat', NumberType::class, array('label' => 'Sale.vat.label')); $builder->add('stamp', NumberType::class, array('label' => 'Sale.stamp.label')); $builder->add('balanceTtc', NumberType::class, array('label' => 'Sale.balanceTtc.label')); $builder->add('balanceNet', NumberType::class, array('label' => 'Sale.balanceNet.label')); $builder->add('vatDevise', NumberType::class, array('label' => 'Sale.vatDevise.label')); $builder->add('stampDevise', NumberType::class, array('label' => 'Sale.stampDevise.label')); $builder->add('balanceTtcDevise', NumberType::class, array('label' => 'Sale.balanceTtcDevise.label')); $builder->add('balanceNetDevise', NumberType::class, array('label' => 'Sale.balanceNetDevise.label')); $builder->add('vatInfo', ChoiceType::class, array('label' => 'Sale.vatInfo.label', 'choices_as_values' => true, 'choices' => Sale::choiceVatInfo(), 'attr' => array('choice_label_trans' => true))); $builder->add('regime', ChoiceType::class, array('label' => 'Sale.regime.label', 'choices_as_values' => true, 'choices' => Sale::choiceRegime(), 'attr' => array('choice_label_trans' => true))); if (null == $this->mbsale) { $builder->add('withholding', EntityType::class, array('label' => 'Sale.withholding.label', 'class' => 'AcfDataBundle:Withholding', 'query_builder' => function (WithholdingRepository $wr) { return $wr->createQueryBuilder('w')->orderBy('w.label', 'ASC'); }, 'choice_label' => 'label', 'multiple' => false, 'by_reference' => true, 'required' => true)); } else { $companyId = $this->mbsale->getCompany()->getId(); $builder->add('withholding', EntityType::class, array('label' => 'Sale.withholding.label', 'class' => 'AcfDataBundle:Withholding', 'query_builder' => function (WithholdingRepository $wr) use($companyId) { return $wr->createQueryBuilder('w')->join('w.company', 'c')->where('c.id = :cid')->setParameter('cid', $companyId)->orderBy('w.label', 'ASC'); }, 'choice_label' => 'label', 'multiple' => false, 'by_reference' => true, 'required' => true)); } $builder->add('paymentType', ChoiceType::class, array('label' => 'Sale.paymentType.label', 'choices_as_values' => true, 'choices' => Sale::choicePaymentType(), 'attr' => array('choice_label_trans' => true))); $builder->add('transactionStatus', ChoiceType::class, array('label' => 'Sale.transactionStatus.label', 'choices_as_values' => true, 'choices' => Sale::choiceTransactionStatus(), 'expanded' => true, 'attr' => array('choice_label_trans' => true))); $builder->add('dtPayment', DateType::class, array('label' => 'Sale.dtPayment.label', 'widget' => 'single_text', 'format' => 'yyyy-MM-dd')); if (null == $this->mbsale) { $builder->add('account', EntityType::class, array('label' => 'Sale.account.label', 'class' => 'AcfDataBundle:Account', 'query_builder' => function (AccountRepository $ar) { return $ar->createQueryBuilder('a')->orderBy('a.label', 'ASC'); }, 'choice_label' => 'label', 'multiple' => false, 'by_reference' => true, 'required' => true)); } else { $companyId = $this->mbsale->getCompany()->getId(); $builder->add('account', EntityType::class, array('label' => 'Sale.account.label', 'class' => 'AcfDataBundle:Account', 'query_builder' => function (AccountRepository $ar) use($companyId) { return $ar->createQueryBuilder('a')->join('a.company', 'c')->where('c.id = :cid')->setParameter('cid', $companyId)->orderBy('a.label', 'ASC'); }, 'choice_label' => 'label', 'multiple' => false, 'by_reference' => true, 'required' => true)); } $builder->add('docs', CollectionType::class, array('label' => 'Sale.docs.label', 'entry_type' => SaleDocTForm::class, 'allow_add' => true, 'allow_delete' => true, 'by_reference' => false, 'mapped' => false, 'constraints' => new Valid())); $builder->add('secondaryVats', CollectionType::class, array('label' => 'Sale.secondaryVats.label', 'entry_type' => SaleSecondaryVatTForm::class, 'allow_add' => true, 'allow_delete' => true, 'by_reference' => false, 'mapped' => false)); $builder->add('otherInfos', TextareaType::class, array('label' => 'Sale.otherInfos.label', 'required' => false)); $builder->add('validated', ChoiceType::class, array('label' => 'Sale.validated.label', 'choices_as_values' => true, 'choices' => Sale::choiceValidated(), 'expanded' => true, 'attr' => array('choice_label_trans' => true))); }
protected function traceEntity(Sale $cloneSale, Sale $sale) { $curUser = $this->getSecurityTokenStorage()->getToken()->getUser(); $trace = new Trace(); $trace->setActionId($sale->getId()); $trace->setActionType(Trace::AT_UPDATE); $trace->setUserId($curUser->getId()); $trace->setCompanyId($sale->getCompany()->getId()); $trace->setUserFullname($curUser->getFullName()); if (!$this->hasRole('ROLE_SUPERADMIN')) { if (!$this->hasRole('ROLE_ADMIN')) { $trace->setUserType(Trace::UT_CLIENT); } else { $trace->setUserType(Trace::UT_ADMIN); } } else { $trace->setUserType(Trace::UT_SUPERADMIN); } $tableBegin = ': <br><table class="table table-bordered table-condensed table-hover table-striped">'; $tableBegin .= '<thead><tr><th class="text-left">' . $this->translate('Entity.field') . '</th>'; $tableBegin .= '<th class="text-left">' . $this->translate('Entity.oldVal') . '</th>'; $tableBegin .= '<th class="text-left">' . $this->translate('Entity.newVal') . '</th></tr></thead><tbody>'; $tableEnd = '</tbody></table>'; $trace->setActionEntity(Trace::AE_SALE); $trace->setActionId2($sale->getMonthlyBalance()->getCompany()->getId()); $trace->setActionEntity2(Trace::AE_COMPANY); $trace->setActionId3($sale->getMonthlyBalance()->getId()); $trace->setActionEntity2(Trace::AE_MBSALE); $msg = ''; if ($cloneSale->getNumber() != $sale->getNumber()) { $msg .= '<tr><td>' . $this->translate('Sale.number.label') . '</td><td>'; if ($cloneSale->getNumber() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getNumberFormated(); } $msg .= '</td><td>'; if ($sale->getNumber() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getNumberFormated(); } $msg .= '</td></tr>'; } if ($cloneSale->getDtActivation() != $sale->getDtActivation()) { $msg .= '<tr><td>' . $this->translate('Sale.dtActivation.label') . '</td><td>'; if ($cloneSale->getDtActivation() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getDtActivation()->format('Y-m-d'); } $msg .= '</td><td>'; if ($sale->getDtActivation() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getDtActivation()->format('Y-m-d'); } $msg .= '</td></tr>'; } if ($cloneSale->getBill() != $sale->getBill()) { $msg .= '<tr><td>' . $this->translate('Sale.bill.label') . '</td><td>'; if ($cloneSale->getBill() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getBill(); } $msg .= '</td><td>'; if ($sale->getBill() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getBill(); } $msg .= '</td></tr>'; } if ($cloneSale->getRelation() != $sale->getRelation()) { $msg .= '<tr><td>' . $this->translate('Sale.relation.label') . '</td><td>'; if ($cloneSale->getRelation() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getRelation()->getLabel(); } $msg .= '</td><td>'; if ($sale->getRelation() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getRelation()->getLabel(); } $msg .= '</td></tr>'; } if ($cloneSale->getLabel() != $sale->getLabel()) { $msg .= '<tr><td>' . $this->translate('Sale.label.label') . '</td><td>'; if ($cloneSale->getLabel() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getLabel(); } $msg .= '</td><td>'; if ($sale->getLabel() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getLabel(); } $msg .= '</td></tr>'; } if ($cloneSale->getDevise() != $sale->getDevise()) { $msg .= '<tr><td>' . $this->translate('Sale.devise.label') . '</td><td>'; if ($cloneSale->getDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getDevise(); } $msg .= '</td><td>'; if ($sale->getDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getDevise(); } $msg .= '</td></tr>'; } if ($cloneSale->getConversionRate() != $sale->getConversionRate()) { $msg .= '<tr><td>' . $this->translate('Sale.conversionRate.label') . '</td><td>'; if ($cloneSale->getConversionRate() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getConversionRate(); } $msg .= '</td><td>'; if ($sale->getConversionRate() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getConversionRate(); } $msg .= '</td></tr>'; } if ($cloneSale->getVat() != $sale->getVat()) { $msg .= '<tr><td>' . $this->translate('Sale.vat.label') . '</td><td>'; if ($cloneSale->getVat() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getVat(); } $msg .= '</td><td>'; if ($sale->getVat() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getVat(); } $msg .= '</td></tr>'; } if ($cloneSale->getStamp() != $sale->getStamp()) { $msg .= '<tr><td>' . $this->translate('Sale.stamp.label') . '</td><td>'; if ($cloneSale->getStamp() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getStamp(); } $msg .= '</td><td>'; if ($sale->getStamp() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getStamp(); } $msg .= '</td></tr>'; } if ($cloneSale->getBalanceTtc() != $sale->getBalanceTtc()) { $msg .= '<tr><td>' . $this->translate('Sale.balanceTtc.label') . '</td><td>'; if ($cloneSale->getBalanceTtc() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getBalanceTtc(); } $msg .= '</td><td>'; if ($sale->getBalanceTtc() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getBalanceTtc(); } $msg .= '</td></tr>'; } if ($cloneSale->getBalanceNet() != $sale->getBalanceNet()) { $msg .= '<tr><td>' . $this->translate('Sale.balanceNet.label') . '</td><td>'; if ($cloneSale->getBalanceNet() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getBalanceNet(); } $msg .= '</td><td>'; if ($sale->getBalanceNet() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getBalanceNet(); } $msg .= '</td></tr>'; } if ($cloneSale->getVatDevise() != $sale->getVatDevise()) { $msg .= '<tr><td>' . $this->translate('Sale.vatDevise.label') . '</td><td>'; if ($cloneSale->getVatDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getVatDevise(); } $msg .= '</td><td>'; if ($sale->getVatDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getVatDevise(); } $msg .= '</td></tr>'; } if ($cloneSale->getStampDevise() != $sale->getStampDevise()) { $msg .= '<tr><td>' . $this->translate('Sale.stampDevise.label') . '</td><td>'; if ($cloneSale->getStampDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getStampDevise(); } $msg .= '</td><td>'; if ($sale->getStampDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getStampDevise(); } $msg .= '</td></tr>'; } if ($cloneSale->getBalanceTtcDevise() != $sale->getBalanceTtcDevise()) { $msg .= '<tr><td>' . $this->translate('Sale.balanceTtcDevise.label') . '</td><td>'; if ($cloneSale->getBalanceTtcDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getBalanceTtcDevise(); } $msg .= '</td><td>'; if ($sale->getBalanceTtcDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getBalanceTtcDevise(); } $msg .= '</td></tr>'; } if ($cloneSale->getBalanceNetDevise() != $sale->getBalanceNetDevise()) { $msg .= '<tr><td>' . $this->translate('Sale.balanceNetDevise.label') . '</td><td>'; if ($cloneSale->getBalanceNetDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getBalanceNetDevise(); } $msg .= '</td><td>'; if ($sale->getBalanceNetDevise() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getBalanceNetDevise(); } $msg .= '</td></tr>'; } if ($cloneSale->getVatInfo() != $sale->getVatInfo()) { $msg .= '<tr><td>' . $this->translate('Sale.vatInfo.label') . '</td><td>'; if ($cloneSale->getVatInfo() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Sale.vatInfo.' . $cloneSale->getVatInfo()); } $msg .= '</td><td>'; if ($sale->getVatInfo() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Sale.vatInfo.' . $sale->getVatInfo()); } $msg .= '</td></tr>'; } if ($cloneSale->getRegime() != $sale->getRegime()) { $msg .= '<tr><td>' . $this->translate('Sale.regime.label') . '</td><td>'; if ($cloneSale->getRegime() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Sale.regime.' . $cloneSale->getRegime()); } $msg .= '</td><td>'; if ($sale->getRegime() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Sale.regime.' . $sale->getRegime()); } $msg .= '</td></tr>'; } if ($cloneSale->getWithholding() != $sale->getWithholding()) { $msg .= '<tr><td>' . $this->translate('Sale.withholding.label') . '</td><td>'; if ($cloneSale->getWithholding() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getWithholding()->getLabel(); } $msg .= '</td><td>'; if ($sale->getWithholding() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getWithholding()->getLabel(); } $msg .= '</td></tr>'; } if ($cloneSale->getPaymentType() != $sale->getPaymentType()) { $msg .= '<tr><td>' . $this->translate('Sale.paymentType.label') . '</td><td>'; if ($cloneSale->getPaymentType() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Transaction.paymentType.' . $cloneSale->getPaymentType()); } $msg .= '</td><td>'; if ($sale->getPaymentType() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Transaction.paymentType.' . $sale->getPaymentType()); } $msg .= '</td></tr>'; } if ($cloneSale->getDtPayment() != $sale->getDtPayment()) { $msg .= '<tr><td>' . $this->translate('Sale.dtPayment.label') . '</td><td>'; if ($cloneSale->getDtPayment() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getDtPayment()->format('Y-m-d'); } $msg .= '</td><td>'; if ($sale->getDtPayment() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getDtActivation()->format('Y-m-d'); } $msg .= '</td></tr>'; } if ($cloneSale->getAccount() != $sale->getAccount()) { $msg .= '<tr><td>' . $this->translate('Sale.account.label') . '</td><td>'; if ($cloneSale->getAccount() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getAccount()->getLabel(); } $msg .= '</td><td>'; if ($sale->getAccount() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getAccount()->getLabel(); } $msg .= '</td></tr>'; } if ($cloneSale->getNature() != $sale->getNature()) { $msg .= '<tr><td>' . $this->translate('Sale.nature.label') . '</td><td>'; if ($cloneSale->getNature() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getNature()->getLabel(); } $msg .= '</td><td>'; if ($sale->getNature() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getNature()->getLabel(); } $msg .= '</td></tr>'; } if ($cloneSale->getTransactionStatus() != $sale->getTransactionStatus()) { $msg .= '<tr><td>' . $this->translate('Sale.transactionStatus.label') . '</td><td>'; if ($cloneSale->getTransactionStatus() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Transaction.transactionStatus.' . $cloneSale->getTransactionStatus()); } $msg .= '</td><td>'; if ($sale->getTransactionStatus() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Transaction.transactionStatus.' . $sale->getTransactionStatus()); } $msg .= '</td></tr>'; } if ($cloneSale->getValidated() != $sale->getValidated()) { $msg .= '<tr><td>' . $this->translate('Sale.validated.label') . '</td><td>'; if ($cloneSale->getValidated() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Transaction.validated.' . $cloneSale->getValidated()); } $msg .= '</td><td>'; if ($sale->getValidated() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $this->translate('Transaction.validated.' . $sale->getValidated()); } $msg .= '</td></tr>'; } if ($cloneSale->getOtherInfos() != $sale->getOtherInfos()) { $msg .= '<tr><td>' . $this->translate('Sale.otherInfos.label') . '</td><td>'; if ($cloneSale->getOtherInfos() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $cloneSale->getOtherInfos(); } $msg .= '</td><td>'; if ($sale->getOtherInfos() == null) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= $sale->getOtherInfos(); } $msg .= '</td></tr>'; } if (\count(\array_diff($sale->getDocs()->toArray(), $cloneSale->getDocs()->toArray())) != 0 || \count(\array_diff($cloneSale->getDocs()->toArray(), $sale->getDocs()->toArray())) != 0) { $msg .= '<tr><td>' . $this->translate('Sale.docs.label') . '</td><td>'; if (\count($cloneSale->getDocs()) == 0) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= '<ul>'; foreach ($cloneSale->getDocs() as $doc) { $msg .= '<li><a href="' . $this->generateUrl('_admin_doc_editGet', array('uid' => $doc->getId())) . '">' . $doc->getOriginalName() . '</a></li>'; } $msg .= '<ul>'; } $msg .= '</td><td>'; if (\count($sale->getDocs()) == 0) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= '<ul>'; foreach ($sale->getDocs() as $doc) { $msg .= '<li><a href="' . $this->generateUrl('_admin_doc_editGet', array('uid' => $doc->getId())) . '">' . $doc->getOriginalName() . '</a></li>'; } $msg .= '<ul>'; } $msg .= '</td></tr>'; } if (\count(\array_diff($sale->getSecondaryVats()->toArray(), $cloneSale->getSecondaryVats()->toArray())) != 0 || \count(\array_diff($cloneSale->getSecondaryVats()->toArray(), $sale->getSecondaryVats()->toArray())) != 0) { $msg .= '<tr><td>' . $this->translate('Sale.secondaryVats.label') . '</td><td>'; if (\count($cloneSale->getSecondaryVats()) == 0) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= '<ul>'; foreach ($cloneSale->getSecondaryVats() as $secondaryVat) { $msg .= '<li><a href="' . $this->generateUrl('_admin_secondaryVat_editGet', array('uid' => $secondaryVat->getId())) . '">' . $secondaryVat->getVat() . '</a></li>'; } $msg .= '<ul>'; } $msg .= '</td><td>'; if (\count($sale->getSecondaryVats()) == 0) { $msg .= '<span class="label label-warning">' . $this->translate('_NA') . '</span>'; } else { $msg .= '<ul>'; foreach ($sale->getSecondaryVats() as $secondaryVat) { $msg .= '<li><a href="' . $this->generateUrl('_admin_secondaryVat_editGet', array('uid' => $secondaryVat->getId())) . '">' . $secondaryVat->getVat() . '</a></li>'; } $msg .= '<ul>'; } $msg .= '</td></tr>'; } if ($msg != '') { $msg = $tableBegin . $msg . $tableEnd; $trace->setMsg($this->translate('Sale.traceEdit', array('%sale%' => $sale->getLabel(), '%mbsale%' => $sale->getMonthlyBalance()->getRef(), '%company%' => $sale->getCompany()->getCorporateName())) . $msg); $trace->setDtCrea(new \DateTime('now')); $em = $this->getEntityManager(); $em->persist($trace); $em->flush(); } }
/** * * @param string $uid * @return \Symfony\Component\HttpFoundation\RedirectResponse|\Symfony\Component\HttpFoundation\Response */ public function editPostAction($uid) { $urlFrom = $this->getReferer(); if (null == $urlFrom || trim($urlFrom) == '') { $urlFrom = $this->generateUrl('_client_homepage'); } $em = $this->getEntityManager(); try { $mbsale = $em->getRepository('AcfDataBundle:MBSale')->find($uid); if (null == $mbsale) { $this->flashMsgSession('warning', $this->translate('MBSale.edit.notfound')); } else { $sc = $this->getSecurityTokenStorage(); $user = $sc->getToken()->getUser(); $company = $mbsale->getCompany(); $companyUser = $em->getRepository('AcfDataBundle:CompanyUser')->findOneBy(array('company' => $company, 'user' => $user)); if (null == $companyUser || $companyUser->getEditSales() == CompanyUser::CANT) { $this->flashMsgSession('error', $this->translate('CompanyUser.accessForbidden')); return $this->redirect($this->generateUrl('_client_homepage')); } $this->gvars['companyUser'] = $companyUser; $this->gvars['menu_active'] = 'client' . $company->getId(); $sale = new Sale(); $sale->setMonthlyBalance($mbsale); $saleNewForm = $this->createForm(SaleNewTForm::class, $sale, array('monthlybalance' => $mbsale)); $mbsaleUpdateDocsForm = $this->createForm(MBSaleUpdateDocsTForm::class, $mbsale, array('company' => $mbsale->getCompany())); $doc = new Doc(); $doc->setCompany($mbsale->getCompany()); $docNewForm = $this->createForm(DocNewTForm::class, $doc, array('company' => $mbsale->getCompany())); $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(); $cloneMBSale = clone $mbsale; if (isset($reqData['SaleNewForm'])) { $this->gvars['tabActive'] = 2; $this->getSession()->set('tabActive', 2); $this->gvars['stabActive'] = 2; $this->getSession()->set('stabActive', 2); $saleNewForm->handleRequest($request); if ($saleNewForm->isValid()) { $sale->setNumber($mbsale->getCount()); if ($sale->getDevise() == 'TND') { $sale->setConversionRate(1); $sale->setVatDevise($sale->getVat()); $sale->setStampDevise($sale->getStamp()); $sale->setBalanceTtcDevise($sale->getBalanceTtc()); $sale->setBalanceNetDevise($sale->getBalanceNet()); } else { $sale->setVat($sale->getVatDevise() * $sale->getConversionRate()); $sale->setStamp($sale->getStampDevise() * $sale->getConversionRate()); $sale->setBalanceTtc($sale->getBalanceTtcDevise() * $sale->getConversionRate()); $sale->setBalanceNet($sale->getBalanceNetDevise() * $sale->getConversionRate()); } foreach ($saleNewForm->get('docs') as $docNewForm) { $docFile = $docNewForm['fileName']->getData(); $docDir = $this->getParameter('kernel.root_dir') . '/../web/res/docs'; $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 = $docNewForm->getData(); $doc->setCompany($mbsale->getCompany()); $doc->setFileName($fileName); $doc->setOriginalName($originalName); $doc->setSize($size); $doc->setMimeType($mimeType); $doc->setMd5($md5); $doc->setDescription($docNewForm['description']->getData()); $em->persist($doc); $sale->addDoc($doc); } $em->persist($sale); foreach ($saleNewForm->get('secondaryVats') as $secondaryVatNewForm) { $secondaryVat = $secondaryVatNewForm->getData(); $secondaryVat->setSale($sale); $sale->addSecondaryVat($secondaryVat); $em->persist($secondaryVat); $em->persist($sale); } $em->flush(); $mbsale->updateCount(); $em->persist($mbsale); $em->flush(); $this->flashMsgSession('success', $this->translate('Sale.add.success', array('%sale%' => $sale->getNumber()))); $this->gvars['tabActive'] = 1; $this->getSession()->set('tabActive', 1); $this->gvars['stabActive'] = 1; $this->getSession()->set('stabActive', 1); return $this->redirect($urlFrom); } else { $em->refresh($mbsale); $this->flashMsgSession('error', $this->translate('Sale.add.failure')); } } elseif (isset($reqData['DocNewForm'])) { $this->gvars['tabActive'] = 4; $this->getSession()->set('tabActive', 4); $this->gvars['stabActive'] = 1; $this->getSession()->set('stabActive', 1); $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($mbsale->getCompany()); $doc->setFileName($fileName); $doc->setOriginalName($originalName); $doc->setSize($size); $doc->setMimeType($mimeType); $doc->setMd5($md5); $doc->setDescription($docNewForm['description']->getData()); $em->persist($doc); $mbsale->addDoc($doc); $docs[] = $doc; $docNames .= $doc->getOriginalName() . ' '; } $em->persist($mbsale); $em->flush(); $this->flashMsgSession('success', $this->translate('Doc.add.success', array('%doc%' => $docNames))); $this->newDocNotifyAdmin($mbsale, $docs); $this->gvars['stabActive'] = 3; $this->getSession()->set('stabActive', 3); $this->traceEntity($cloneMBSale, $mbsale); return $this->redirect($urlFrom); } else { $em->refresh($mbsale); $this->flashMsgSession('error', $this->translate('Doc.add.failure')); } } elseif (isset($reqData['MBSaleUpdateDocsForm'])) { $this->gvars['tabActive'] = 4; $this->getSession()->set('tabActive', 4); $this->gvars['stabActive'] = 2; $this->getSession()->set('stabActive', 2); $mbsaleUpdateDocsForm->handleRequest($request); if ($mbsaleUpdateDocsForm->isValid()) { $em->persist($mbsale); $em->flush(); $this->flashMsgSession('success', $this->translate('MBSale.edit.success', array('%mbsale%' => $mbsale->getRef()))); $this->gvars['stabActive'] = 3; $this->getSession()->set('stabActive', 3); $this->traceEntity($cloneMBSale, $mbsale); return $this->redirect($urlFrom); } else { $em->refresh($mbsale); $this->flashMsgSession('error', $this->translate('MBSale.edit.failure', array('%mbsale%' => $mbsale->getRef()))); } } $this->gvars['mbsale'] = $mbsale; $this->gvars['sale'] = $sale; $this->gvars['doc'] = $doc; $this->gvars['SaleNewForm'] = $saleNewForm->createView(); $this->gvars['MBSaleUpdateDocsForm'] = $mbsaleUpdateDocsForm->createView(); $this->gvars['DocNewForm'] = $docNewForm->createView(); $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; $this->gvars['pagetitle'] = $this->translate('pagetitle.mbsale.edit', array('%mbsale%' => $mbsale->getRef())); $this->gvars['pagetitle_txt'] = $this->translate('pagetitle.mbsale.edit.txt', array('%mbsale%' => $mbsale->getRef())); return $this->renderResponse('AcfClientBundle:MBSale:edit.html.twig', $this->gvars); } } catch (\Exception $e) { $logger = $this->getLogger(); $logger->addCritical($e->getLine() . ' ' . $e->getMessage() . ' ' . $e->getTraceAsString()); } return $this->redirect($urlFrom); }