123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528 |
- <?php
- /**
- * kataoSupplierInvoice actions.
- *
- * @package www.katao.fr
- * @subpackage kataoSupplierInvoice
- * @author Your name here
- * @version SVN: $Id: actions.class.php 9301 2008-05-27 01:08:46Z dwhittle $
- */
- class kataoSupplierInvoiceActions extends wpActions {
- public function executeIndex() {
- $criteria = new Criteria();
- $criteria->addJoin(KataoSupplierInvoicePeer::KATAO_PERIOD_ID, KataoPeriodPeer::ID);
- $sort_method = $this->getCriteriaSortMethod();
- switch ($this->sort = $this->getRequestParameter('sort', 'date')) {
- case 'reference':
- $criteria->$sort_method(KataoSupplierInvoicePeer::REFERENCE);
- break;
- case 'status':
- $criteria->$sort_method(KataoSupplierInvoicePeer::STATUS);
- break;
- case 'supplier':
- $criteria->$sort_method(KataoSupplierInvoicePeer::SUPPLIER_NAME);
- break;
- case 'total':
- $criteria->$sort_method(KataoSupplierInvoicePeer::TOTAL_TVA);
- break;
- case 'period':
- $criteria->$sort_method(KataoPeriodPeer::NAME);
- break;
- default:
- $criteria->$sort_method(KataoSupplierInvoicePeer::INVOICE_DATE);
- }
- if ('' != $this->filter_status = $this->getUser()->getAttribute('katao_supplier_invoice_filter_status')) {
- $criteria->add(KataoSupplierInvoicePeer::STATUS, $this->filter_status);
- }
- if ('' != $this->filter_supplier = $this->getUser()->getAttribute('katao_supplier_invoice_filter_supplier')) {
- $criteria->add(KataoSupplierInvoicePeer::KATAO_SUPPLIER_ID, $this->filter_supplier);
- }
- if (!is_null(KataoPeriodPeer::getActivePeriod()) && '' != $this->filter_period = $this->getUser()->getAttribute('katao_supplier_invoice_filter_period', KataoPeriodPeer::getActivePeriod()->getId())) {
- $criteria->add(KataoSupplierInvoicePeer::KATAO_PERIOD_ID, $this->filter_period);
- }
- $pager = new sfPropelPager('KataoSupplierInvoice', sfConfig::get('app_pager'));
- $pager->setCriteria($criteria);
- $pager->setPage($this->getRequestParameter('page', 1));
- $pager->init();
- $this->pager = $pager;
- $this->katao_supplier_invoiceList = $pager->getResults();
- }
- public function executeFilter($request) {
- $this->getUser()->setAttribute('katao_supplier_invoice_filter_status', $request->getParameter('filter_status'));
- $this->getUser()->setAttribute('katao_supplier_invoice_filter_supplier', $request->getParameter('filter_supplier'));
- $this->getUser()->setAttribute('katao_supplier_invoice_filter_period', $request->getParameter('filter_period'));
- return $this->redirect('kataoSupplierInvoice/index');
- }
- public function executeFilterReset($request) {
- $this->getUser()->setAttribute('katao_supplier_invoice_filter_status', '');
- $this->getUser()->setAttribute('katao_supplier_invoice_filter_supplier', '');
- $this->getUser()->setAttribute('katao_supplier_invoice_filter_period', KataoPeriodPeer::getActivePeriod()->getId());
- return $this->redirect('kataoSupplierInvoice/index');
- }
- public function executeCreate($request) {
- $this->katao_supplier_invoice = new KataoSupplierInvoice();
- $this->katao_supplier_invoice_orders = array();
- $this->setTemplate('edit');
- }
- public function executeEdit($request) {
- $this->katao_supplier_invoice = KataoSupplierInvoicePeer::retrieveByPk($request->getParameter('id'));
- $this->redirectWithErrorUnless($this->katao_supplier_invoice, 'Facture #' . $request->getParameter('id') . ' inconnue.');
- }
- public function executeUpdate($request) {
- $this->katao_supplier_invoice = KataoSupplierInvoicePeer::retrieveByPk($request->getParameter('id'));
- if (is_null($this->katao_supplier_invoice)) {
- $this->katao_supplier_invoice = new KataoSupplierInvoice();
- }
- try {
- $con = Propel::getConnection();
- $con->begin();
- $this->katao_supplier_invoice->setKataoPeriodId($request->getParameter('period'));
- $this->katao_supplier_invoice->setKataoSupplierId($request->getParameter('supplier'));
- $this->katao_supplier_invoice->setReference($request->getParameter('reference'));
- list($d, $m, $y) = sfContext::getInstance()->getI18N()->getDateForCulture($request->getParameter('invoice_date'), 'fr');
- $this->katao_supplier_invoice->setInvoiceDate("$y-$m-$d");
- list($d, $m, $y) = sfContext::getInstance()->getI18N()->getDateForCulture($request->getParameter('due_date'), 'fr');
- $this->katao_supplier_invoice->setDueDate("$y-$m-$d");
- $this->katao_supplier_invoice->setComment($request->getParameter('comment'));
- if ($this->katao_supplier_invoice->isNew()) {
- // save supplier/katao data if new invoice
- $katao_supplier =/*(KataoSupplier)*/ $this->katao_supplier_invoice->getKataoSupplier();
- $this->katao_supplier_invoice->setSupplierName($katao_supplier->getName());
- $this->katao_supplier_invoice->setSupplierEmail($katao_supplier->getEmail());
- $this->katao_supplier_invoice->setSupplierAddress1($katao_supplier->getAddress1());
- $this->katao_supplier_invoice->setSupplierAddress2($katao_supplier->getAddress2());
- $this->katao_supplier_invoice->setSupplierZip($katao_supplier->getZip());
- $this->katao_supplier_invoice->setSupplierCity($katao_supplier->getCity());
- $this->katao_supplier_invoice->setKataoName(wpConfig::getName());
- $this->katao_supplier_invoice->setKataoAddress(wpConfig::getAddress());
- $this->katao_supplier_invoice->setKataoSiretNumber(wpConfig::getSiretNumber());
- $this->katao_supplier_invoice->setKataoRcsNumber(wpConfig::getRCSNumber());
- $this->katao_supplier_invoice->setKataoCapital(wpConfig::getCapital());
- }
- $tva_rates = array('0.2' => 1, '0.055' => 2, '0' => 0);
- $without_taxes_by_tva_rate = $request->getParameter('without_taxes_by_tva_rate[]');
- $discount_by_tva_rate = $request->getParameter('discount_by_tva_rate[]');
- $total_by_tva_rate = $request->getParameter('total_by_tva_rate[]');
- foreach ($tva_rates as $tva_rate_value => $tva_rate_const) {
- $setTauxBasesHt = sprintf('setTaux%dBasesHt', $tva_rate_const);
- $this->katao_supplier_invoice->$setTauxBasesHt(!empty($without_taxes_by_tva_rate[$tva_rate_const])?$without_taxes_by_tva_rate[$tva_rate_const]:0);
- $setTauxDiscountHt = sprintf('setTaux%dDiscountHt', $tva_rate_const);
- $this->katao_supplier_invoice->$setTauxDiscountHt(!empty($discount_by_tva_rate[$tva_rate_const])?$discount_by_tva_rate[$tva_rate_const]:0);
- $setTauxAmount = sprintf('setTaux%dAmount', $tva_rate_const);
- $this->katao_supplier_invoice->$setTauxAmount(!empty($total_by_tva_rate[$tva_rate_const])?$total_by_tva_rate[$tva_rate_const]:0);
- }
- $this->katao_supplier_invoice->setTotalHt($request->getParameter('without_taxes_total'));
- $this->katao_supplier_invoice->setTotalTva($request->getParameter('tva_total'));
- $this->katao_supplier_invoice->setFeesShippingHt($request->getParameter('fees_shipping_ht'));
- $this->katao_supplier_invoice->setFeesShippingRate($request->getParameter('fees_shipping_rate'));
- $this->katao_supplier_invoice->setFeesShippingTva($request->getParameter('fees_shipping_tva'));
- $this->katao_supplier_invoice->setFeesBillingHt($request->getParameter('fees_billing_ht'));
- $this->katao_supplier_invoice->setFeesBillingRate($request->getParameter('fees_billing_rate'));
- $this->katao_supplier_invoice->setFeesBillingTva($request->getParameter('fees_billing_tva'));
- $this->katao_supplier_invoice->save($con);
- if (!$this->katao_supplier_invoice->isNew()) {
- // delete existing relations between invoice and orders
- $criteria = new Criteria();
- $criteria->add(KataoSupplierInvoiceOrderPeer::KATAO_SUPPLIER_INVOICE_ID, $this->katao_supplier_invoice->getId());
- KataoSupplierInvoiceOrderPeer::doDelete($criteria, $con);
- // delete existing relations between invoice and products
- $criteria = new Criteria();
- $criteria->add(KataoSupplierInvoiceProductPeer::KATAO_SUPPLIER_INVOICE_ID, $this->katao_supplier_invoice->getId());
- KataoSupplierInvoiceProductPeer::doDelete($criteria, $con);
- }
- // save new relations between invoice and orders
- $orders = $request->getParameter('orders[]');
- if ($orders && is_array($orders) && 0 < count($orders)) {
- foreach ($orders as $katao_order_id) {
- $katao_supplier_invoice_order = new KataoSupplierInvoiceOrder();
- $katao_supplier_invoice_order->setKataoSupplierInvoice($this->katao_supplier_invoice);
- $katao_supplier_invoice_order->setKataoOrderId($katao_order_id);
- $katao_supplier_invoice_order->save($con);
- }
- }
- // save new relations between invoice and products
- // and update product price
- $product_quantity = $request->getParameter('product_quantity[]');
- $product_price_unit = $request->getParameter('product_price_unit[]');
- $product_price_total = $request->getParameter('product_price_total[]');
- foreach ($product_quantity as $katao_product_id => $quantity) {
- if (null != $katao_product = KataoProductPeer::retrieveByPK($katao_product_id, $con)) {
- $katao_supplier_invoice_product = new KataoSupplierInvoiceProduct();
- $katao_supplier_invoice_product->setKataoSupplierInvoice($this->katao_supplier_invoice);
- $katao_supplier_invoice_product->setKataoProductId($katao_product_id);
- $katao_supplier_invoice_product->setProductReference($katao_product->getReference());
- $katao_supplier_invoice_product->setProductName($katao_product->getName());
- $katao_supplier_invoice_product->setProductPriceEuro(!empty($product_price_unit[$katao_product_id])?$product_price_unit[$katao_product_id]:$katao_product->getUnitPriceEuro());
- $katao_supplier_invoice_product->setProductMargin($katao_product->getMargin());
- $katao_supplier_invoice_product->setProductTvaRate($katao_product->getTvaRate());
- $katao_supplier_invoice_product->setQuantity($quantity);
- $katao_supplier_invoice_product->setProductPriceTotal(!empty($product_price_total[$katao_product_id])?$product_price_total[$katao_product_id]:($quantity * $katao_product->getUnitPriceEuro() * (1 + $katao_product->getMargin()) * (1 + $katao_product->getTvaRate())));
- $katao_supplier_invoice_product->save($con);
- $katao_product->setUnitPriceEuro($katao_supplier_invoice_product->getProductPriceEuro());
- $katao_product->save($con);
- }
- }
- $con->commit();
- }
- catch (Exception $e) {
- $con->rollback();
- }
- wpFlashMessages::addConfirmation('Facture "' . $this->katao_supplier_invoice->getReference() . '" sauvée avec succès.');
- $this->redirect('kataoSupplierInvoice/index');
- }
- public function executePay($request) {
- $this->redirectWithErrorUnless($this->katao_supplier_invoice = KataoSupplierInvoicePeer::retrieveByPk($request->getParameter('id')), 'Facture #' . $request->getParameter('id') . ' inconnue.');
- $this->redirectWithErrorIf(KataoSupplierInvoice::STATUS_RECEIVED != $this->katao_supplier_invoice->getStatus());
- if ($request->isMethod('post')) {
- $this->katao_supplier_invoice->setStatus(KataoSupplierInvoice::STATUS_PAID);
- $this->katao_supplier_invoice->setPaymentAmountEuro($request->getParameter('payment_amount_euro'));
- $this->katao_supplier_invoice->setPaymentAmountSol($request->getParameter('payment_amount_sol'));
- list($d, $m, $y) = sfContext::getInstance()->getI18N()->getDateForCulture($request->getParameter('payment_date'), 'fr');
- $this->katao_supplier_invoice->setPaymentDate("$y-$m-$d");
- $this->katao_supplier_invoice->setPaymentMode($request->getParameter('payment_mode'));
- if (KataoSupplierInvoice::PAYMENT_MODE_CREDIT_CARD != $this->katao_supplier_invoice->getPaymentMode()) {
- $this->katao_supplier_invoice->setPaymentDetails($request->getParameter('payment_details'));
- }
- $this->katao_supplier_invoice->save();
- wpFlashMessages::addConfirmation('Facture fournisseur "' . $this->katao_supplier_invoice->getReference() . '" payée avec succès.');
- $this->redirect('kataoSupplierInvoice/index');
- }
- // $this->katao_supplier_invoice->initPaymentAmounts();
- }
- public function executeExportPdf($request) {
- $this->redirectWithErrorUnless($katao_supplier_invoice = KataoSupplierInvoicePeer::retrieveByPk($request->getParameter('id')), 'Facture #' . $request->getParameter('id') . ' inconnue.');
- $content = $katao_supplier_invoice->generatePDF();
- $response = $this->getResponse();
- $response->setContentType('application/pdf');
- $response->setHttpHeader('Content-disposition', 'attachment; filename="' . $katao_supplier_invoice->getReference() . '.pdf"');
- $response->setHttpHeader('Content-Length', strlen($content));
- $response->setHttpHeader('Pragma', 'public');
- $response->setHttpHeader('Cache-Control', 'must-revalidate, post-check=0, pre-check=0');
- $response->setHttpHeader('Expires', '0');
- $response->setContent($content);
- return sfView::NONE;
- }
- public function executeExportPDFAll($request) {
- $criteria = new Criteria();
- $criteria->addAscendingOrderByColumn(KataoSupplierInvoicePeer::ID);
- return $this->exportSupplierInvoicesToPDF(KataoSupplierInvoicePeer::doSelect($criteria));
- }
- public function executeExportPDFSelected($request) {
- if (!wpPersistenceManager::isEmpty('katao_supplier_invoice')) {
- $criteria = new Criteria();
- $criteria->add(KataoSupplierInvoicePeer::ID, array_keys(wpPersistenceManager::getSelectedItems('katao_supplier_invoice')), Criteria::IN);
- $criteria->addAscendingOrderByColumn(KataoSupplierInvoicePeer::ID);
- return $this->exportSupplierInvoicesToPDF(KataoSupplierInvoicePeer::doSelect($criteria));
- } else {
- wpFlashMessages::addWarning('Merci de sélectionner au moins une facture.');
- $this->redirect('kataoSupplierInvoice/index');
- }
- }
- protected function exportSupplierInvoicesToPDF($katao_supplier_invoices) {
- $file = tempnam('tmp', 'zip');
- $archive = new ZipArchive();
- $archive->open($file, ZipArchive::OVERWRITE);
- foreach ($katao_supplier_invoices as/*(KataoSupplierInvoice)*/ $katao_supplier_invoice) {
- $archive->addFromString($katao_supplier_invoice->getReference() . '.pdf', $katao_supplier_invoice->generatePDF());
- }
- $archive->close();
- $response = $this->getResponse();
- $response->setContentType('application/zip');
- $response->setHttpHeader('Content-disposition', 'attachment; filename="KATAO_Factures_Fournisseurs_' . date('Y-m-d') . '.zip"');
- $response->setHttpHeader('Content-Length', filesize($file));
- $response->setHttpHeader('Pragma', 'public');
- $response->setHttpHeader('Cache-Control', 'must-revalidate, post-check=0, pre-check=0');
- $response->setHttpHeader('Expires', '0');
- $response->setContent(file_get_contents($file));
- return sfView::NONE;
- }
- public function executeDelete($request) {
- $this->redirectWithErrorUnless($katao_supplier_invoice = KataoSupplierInvoicePeer::retrieveByPk($request->getParameter('id')), 'Facture #' . $request->getParameter('id') . ' inconnue.');
- $katao_supplier_invoice->delete();
- wpFlashMessages::addConfirmation('Facture "' . $katao_supplier_invoice->getReference() . '" supprimée avec succès.');
- $this->redirect('kataoSupplierInvoice/index');
- }
- public function executeDeleteMultiple($request) {
- if (!wpPersistenceManager::isEmpty('katao_supplier_invoice')) {
- $criteria = new Criteria();
- $criteria->add(KataoSupplierInvoicePeer::ID, array_keys(wpPersistenceManager::getSelectedItems('katao_supplier_invoice')), Criteria::IN);
- KataoSupplierInvoicePeer::doDelete($criteria);
- wpPersistenceManager::cleanSelection('katao_supplier_invoice');
- wpFlashMessages::addConfirmation('Les factures sélectionnées ont été supprimées avec succès.');
- } else {
- wpFlashMessages::addWarning('Merci de sélectionner au moins une facture.');
- }
- $this->redirect('kataoSupplierInvoice/index');
- }
- public function executeUpdateOrdersList($request) {
- $katao_supplier_invoice_orders = KataoSupplierInvoiceOrderPeer::getAllByKataoSupplierInvoiceId($request->getParameter('id'));
- $return = '';
- $katao_orders = KataoOrderPeer::getPossibleOrdersForSupplierInvoice($request->getParameter('period'), $request->getParameter('supplier'));
- if (0 < count($katao_orders)) {
- foreach ($katao_orders as/*(KataoOrder)*/ $katao_order) {
- $return .= sprintf('
- <div>
- <input type="checkbox" name="orders[]" value="%d" id="orders_%d" class="supplier-invoice-order" onclick="updateProductsList();"%s />
- <label for="orders_%d">%s <i>pour %s</i></label>
- </div>', $katao_order->getId(), $katao_order->getId(), !empty($katao_supplier_invoice_orders[$katao_order->getId()])?' checked="checked"':'', $katao_order->getId(), $katao_order->getNumber(), $katao_order->getKataoNode()->getCity());
- }
- } else {
- $return = '<i>Merci de choisir une période et un fournisseur</i>';
- }
- return $this->renderText($return);
- }
- public function executeUpdateProductsList($request) {
- $return = '<br /><i>Merci de sélectionner des commandes</i>';
- $tva_rates = array('0.2' => 1, '0.055' => 2, '0' => 0);
- $total_by_tva_rate = array('0.2' => 0, '0.055' => 0, '0' => 0);
- $discount_by_tva_rate = $total_by_tva_rate;
- $products = array();
- if (null != $katao_supplier_invoice = KataoSupplierInvoicePeer::retrieveByPK($request->getParameter('id'))) {
- foreach ($katao_supplier_invoice->getKataoSupplierInvoiceProducts() as/*(KataoSupplierInvoiceProduct)*/ $katao_supplier_invoice_product) {
- $quantity = $katao_supplier_invoice_product->getQuantity();
- $price = $katao_supplier_invoice_product->getProductPriceEuro();
- $sub_total = $katao_supplier_invoice_product->getProductPriceTotal();
- $total_by_tva_rate[(string)$katao_supplier_invoice_product->getProductTvaRate()] += $quantity * $price;
- $products[$katao_supplier_invoice_product->getKataoProductId()]['name'] = $katao_supplier_invoice_product->getProductName();
- $products[$katao_supplier_invoice_product->getKataoProductId()]['price'] = $price;
- $products[$katao_supplier_invoice_product->getKataoProductId()]['tva'] = $katao_supplier_invoice_product->getProductTvaRate();
- $products[$katao_supplier_invoice_product->getKataoProductId()]['quantity'] = $quantity;
- $products[$katao_supplier_invoice_product->getKataoProductId()]['sub_total'] = $sub_total;
- }
- $fees_shipping_ht = $katao_supplier_invoice->getFeesShippingHt();
- $fees_shipping_rate = $katao_supplier_invoice->getFeesShippingRate();
- $fees_shipping_tva = $katao_supplier_invoice->getFeesShippingTva();
- $fees_billing_ht = $katao_supplier_invoice->getFeesBillingHt();
- $fees_billing_rate = $katao_supplier_invoice->getFeesBillingRate();
- $fees_billing_tva = $katao_supplier_invoice->getFeesBillingTva();
- } else {
- if ('' != $orders = $request->getParameter('orders')) {
- $order_ids = explode(',', $orders);
- if (0 < count($order_ids)) {
- foreach (KataoOrderPeer::retrieveByPKs($order_ids) as/*(KataoOrder)*/ $katao_order) {
- foreach ($katao_order->getKataoOrderProducts() as/*(KataoOrderProduct)*/ $katao_order_product) {
- $quantity = $katao_order_product->getHasBeenDelivered()?$katao_order_product->getQuantityDelivered():$katao_order_product->getQuantity();
- $price = $katao_order_product->getProductPriceEuro();
- $sub_total = $quantity * $price;
- $total_by_tva_rate[(string)$katao_order_product->getProductTvaRate()] += $quantity * $katao_order_product->getProductPriceEuro();
- $products[$katao_order_product->getKataoProductId()]['name'] = $katao_order_product->getProductName();
- $products[$katao_order_product->getKataoProductId()]['price'] = $price;
- $products[$katao_order_product->getKataoProductId()]['tva'] = $katao_order_product->getProductTvaRate();
- if (!isset($products[$katao_order_product->getKataoProductId()]['quantity'])) {
- $products[$katao_order_product->getKataoProductId()]['quantity'] = 0;
- }
- $products[$katao_order_product->getKataoProductId()]['quantity'] += $quantity;
- if (!isset($products[$katao_order_product->getKataoProductId()]['sub_total'])) {
- $products[$katao_order_product->getKataoProductId()]['sub_total'] = 0;
- }
- $products[$katao_order_product->getKataoProductId()]['sub_total'] += $sub_total;
- }
- }
- }
- }
- $fees_shipping_ht = 0;
- $fees_shipping_rate = '0';
- $fees_shipping_tva = 0;
- $fees_billing_ht = 0;
- $fees_billing_rate = '0';
- $fees_billing_tva = 0;
- }
- $total = 0;
- if (0 < count($products)) {
- $return = '
- <table class="admin-sub-list">
- <tr>
- <th>Désignation</th>
- <th nowrap="nowrap" width="1%" style="text-align:center!important">Quantité</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">P.U. HT</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">Montant HT</th>
- <th nowrap="nowrap" width="1%" style="text-align:center!important">TVA</th>
- </tr>';
- foreach ($products as $product_id => $product_data) {
- $return .= '
- <tr>
- <td>' . $product_data['name'] . '</td>
- <td nowrap="nowrap" style="text-align:center!important"><input type="text" name="product_quantity[' . $product_id . ']" value="' . $product_data['quantity'] . '" id="product_quantity_' . $product_id . '" class="product-quantity-' . $tva_rates[(string)$product_data['tva']] . '" onchange="updateProductTotalPrice(' . $product_id . ');" style="width: 45px; text-align: center" /></td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="product_price_unit[' . $product_id . ']" value="' . round($product_data['price'], 2) . '" id="product_price_unit_' . $product_id . '" class="product-price-unit-' . $tva_rates[(string)$product_data['tva']] . '" onchange="updateProductTotalPrice(' . $product_id . ');" style="width: 45px; text-align: right" /> €</td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="product_price_total[' . $product_id . ']" value="' . round($product_data['sub_total'], 2) . '" id="product_price_total_' . $product_id . '" class="product-price-total-' . $tva_rates[(string)$product_data['tva']] . '" onchange="updateTotalPrices();" style="width: 60px; text-align: right" /> €</td>
- <td nowrap="nowrap" style="text-align:right!important">' . (100 * $product_data['tva']) . '%</td>
- </tr>';
- }
- $return .= '
- </table>
- <table border="0" cellpadding="0" cellspacing="0">
- <tr valign="top">
- <td>
- <u>TVA (montant, remises) :</u>
- <table class="admin-sub-list" style="width:1%!important">
- <tr>
- <th nowrap="nowrap" width="1%">Taux</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">Bases HT</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">Remises HT</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">Montant</th>
- </tr>';
- $with_taxes_total = 0;
- $without_taxes_total = 0;
- $tva_total = 0;
- foreach ($total_by_tva_rate as $tva_rate => $tva_rate_total) {
- $tva_rate_discount = !empty($discount_by_tva_rate[$tva_rate])?$discount_by_tva_rate[$tva_rate]:0;
- if (!is_null($katao_supplier_invoice)) {
- $getTauxBasesHt = sprintf('getTaux%dBasesHt', $tva_rates[(string)$tva_rate]);
- $tva_rate_total = $katao_supplier_invoice->$getTauxBasesHt();
- $getTauxDiscountHt = sprintf('getTaux%dDiscountHt', $tva_rates[(string)$tva_rate]);
- $tva_rate_discount = $katao_supplier_invoice->$getTauxDiscountHt();
- $getTauxAmount = sprintf('getTaux%dAmount', $tva_rates[(string)$tva_rate]);
- $total_by_tva_rate2 = $katao_supplier_invoice->$getTauxAmount();
- } else {
- $total_by_tva_rate2 = round($tva_rate_total * $tva_rate, 2);
- }
- $without_taxes_total += $tva_rate_total;
- $tva_total += round(($tva_rate_total - $tva_rate_discount) * $tva_rate, 2);
- $return .= '
- <tr>
- <td nowrap="nowrap" style="text-align:right!important">' . (100 * $tva_rate) . '%</td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="without_taxes_by_tva_rate[' . $tva_rates[(string)$tva_rate] . ']" value="' . $tva_rate_total . '" id="without_taxes_by_tva_rate_' . $tva_rates[(string)$tva_rate] . '" onchange="updateTotalPricesTTC();" style="width: 45px; text-align: right" /> €</td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="discount_by_tva_rate[' . $tva_rates[(string)$tva_rate] . ']" value="' . $tva_rate_discount . '" id="discount_by_tva_rate_' . $tva_rates[(string)$tva_rate] . '" onchange="updateTotalPricesTTC();" style="width: 45px; text-align: right" /> €</td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="total_by_tva_rate[' . $tva_rates[(string)$tva_rate] . ']" value="' . $total_by_tva_rate2 . '" id="total_by_tva_rate_' . $tva_rates[(string)$tva_rate] . '" onchange="updateTotalTVA();" style="width: 45px; text-align: right" /> €</td>
- </tr>';
- }
- if (!is_null($katao_supplier_invoice)) {
- $without_taxes_total = $katao_supplier_invoice->getTotalHt();
- $tva_total = $katao_supplier_invoice->getTotalTva();
- }
- $return .= '
- </table>
- </td>
- <td>
- <u>Frais divers :</u>
- <table class="admin-sub-list" style="width:1%!important">
- <tr>
- <th nowrap="nowrap" width="1%">Frais</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">HT</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">Taux</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">TVA</th>
- </tr>
- <tr>
- <td>Port</td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="fees_shipping_ht" id="fees_shipping_ht" value="' . $fees_shipping_ht . '" onchange="updateFeesTVA();" style="width: 45px; text-align: right" /> €</td>
- <td nowrap="nowrap" style="text-align:right!important"><select name="fees_shipping_rate" id="fees_shipping_rate" onchange="updateFeesTVA();">';
- foreach (array('0' => '0%', '0.055' => '5.5%', '0.2' => '20%') as $value => $label) {
- $return .= '<option value="' . $value . '"' . sprintf('%s', ($value == $fees_shipping_rate)?' selected="selected"':'') . '>' . $label . '</option>';
- }
- $return .= '</select></td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="fees_shipping_tva" id="fees_shipping_tva" value="' . $fees_shipping_tva . '" onchange="updateTotalTVA();" style="width: 45px; text-align: right" /> €</td>
- </tr>
- <tr>
- <td>Facturation</td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="fees_billing_ht" id="fees_billing_ht" value="' . $fees_billing_ht . '" onchange="updateFeesTVA();" style="width: 45px; text-align: right" /> €</td>
- <td nowrap="nowrap" style="text-align:right!important"><select name="fees_billing_rate" id="fees_billing_rate" onchange="updateFeesTVA();">';
- foreach (array('0' => '0%', '0.055' => '5.5%', '0.2' => '20%') as $value => $label) {
- $return .= '<option value="' . $value . '"' . sprintf('%s', ($value == $fees_billing_rate)?' selected="selected"':'') . '>' . $label . '</option>';
- }
- $return .= '</select></td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="fees_billing_tva" id="fees_billing_tva" value="' . $fees_billing_tva . '" onchange="updateTotalTVA();" style="width: 45px; text-align: right" /> €</td>
- </tr>
- </table>
- </td>
- <td>
- <u>Totaux :</u>
- <table class="admin-sub-list" style="width:1%!important">
- <tr>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">HT</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">TVA</th>
- <th nowrap="nowrap" width="1%" style="text-align:right!important">TTC</th>
- </tr>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="without_taxes_total" id="without_taxes_total" value="' . $without_taxes_total . '" onchange="updateTotalTTC();" style="width: 45px; text-align: right" /> €</td>
- <td nowrap="nowrap" style="text-align:right!important"><input type="text" name="tva_total" id="tva_total" value="' . $tva_total . '" onchange="updateTotalTTC();" style="width: 45px; text-align: right" /> €</td>
- <td><span id="ttc_total">' . ($without_taxes_total + $tva_total) . '</span> €</td>
- </tr>
- </table>
- </td>
- </tr>
- </table>';
- }
- return $this->renderText($return);
- }
- }
|