function get_invoice($order_summary, $customer, $wysylka) { $payment_type = get_payment_type($order_summary); $is_gios_visible = false; $next_invoice_number = null; $total = $order_summary['value']; $invoice = null; if ($order_summary['gateway'] == 'COD' && has_ship($order_summary) || $wysylka == true) { $invoice = new FakturaWysylkowa($total, $customer->getIdentyfikator(), 'BRT', date('Y-m-d'), 'DZN', 'BPO', $is_gios_visible, $next_invoice_number, date('Y-m-d'), $customer); } else { $invoice = new Faktura($total, $customer->getIdentyfikator(), 'BRT', date('Y-m-d'), 'DZN', $payment_type, 'BPO', $is_gios_visible, $next_invoice_number, date('Y-m-d'), $customer); } if ($payment_type == 'PRZ') { $invoice->NumerKontaBankowego("11111111111111111111111111"); } return $invoice; }
<?php /**********************/ /* Smazání objednávky */ /**********************/ if ($_GET["smaz_objednavku"]) { unset($objednavka); @($objednavka = new Objednavka($_GET["smaz_objednavku"])); if (@$objednavka->smazZDatabaze()) { echo '<div style="color: #008000; border: 1px solid #008000; padding: 3px 3px 3px 6px;">Úspěšně smazáno.</div><p>'; } } /*********************/ /* Vytvoření faktury */ /*********************/ if ($_GET["vystavitFakturu"]) { $faktura = new Faktura(); if ($faktura->vytvorZObjednavky($_GET["vystavitFakturu"])) { echo '<div style="color: #008000; border: 1px solid #008000; padding: 3px 3px 3px 6px;">Faktura úspěšně vytvořena.</div><p>'; } else { echo '<div style="color: #008000; border: 1px solid #008000; padding: 3px 3px 3px 6px;">Při vytváření faktury došlo k chybě: <br>' . $faktura->getErrors() . '</div><p>'; } } ?> <?php /* Změna admin emailu */ if ($_POST["zmena_emailu"] and $_POST["email"]) { $email = $_POST["email"]; if (Mysql_query("UPDATE {$CONF['sqlPrefix']}nastaveni SET emailAdmin='{$email}' WHERE id=1")) {
$odkazyMesice .= '<a href="?m=faktury&rok=' . $rok . '&mesic=' . $value . '" style="font-weight: bold; text-decoration: none;">' . $nazvyMesicu[$value] . '</a> | '; } else { $odkazyMesice .= '<a href="?m=faktury&rok=' . $rok . '&mesic=' . $value . '">' . $nazvyMesicu[$value] . '</a> | '; } //strtotime($value."-01-01 00:00:00") } $odkazyMesice = str_replace("| &end;", "", $odkazyMesice . " &end;"); $odkazyMesice = str_replace("&end;", "", $odkazyMesice); echo "<center>" . $odkazyMesice . "</center>"; /********************/ /* Zobrazení faktur */ /********************/ $rok = $_GET["rok"] ? $_GET["rok"] : $roky[0]; $mesic = $_GET["mesic"] ? $_GET["mesic"] : $mesice[0]; $pocetDnu = @cal_days_in_month(CAL_GREGORIAN, $mesic, $rok); $dateMin = strtotime("{$rok}-{$mesic}-01 00:00:00"); $dateMax = strtotime("{$rok}-{$mesic}-{$pocetDnu} 23:59:59"); $dotaz = Mysql_query("SELECT * FROM {$CONF['sqlPrefix']}faktury WHERE (date>'{$dateMin}' AND date<'{$dateMax}' AND uzivatelJmeno!='') ORDER BY date DESC"); while ($radek = mysql_fetch_array($dotaz)) { unset($faktura); $faktura = new Faktura($radek["id"]); $tmplPom = new GlassTemplate("../templates/{$CONF['vzhled']}/faktura.html", "../templates/default/faktura.html"); echo $faktura->priradDoTmpl($tmplPom, "fakturaAdminMini", "../templates/{$CONF['vzhled']}/faktura.html"); echo $faktura->getErrors(); } ?> <?php include 'grafika_kon.inc';
public function actionRealizedProd() { $from = $_POST['from']; $to = $_POST['to']; $prodCount = array(); $prodSumm = array(); $model = Faktura::model()->with('realize')->findAll('date(realize_date) BETWEEN :from AND :to', array(':from' => $from, ':to' => $to)); foreach ($model as $value) { foreach ($value->getRelated('realize') as $val) { $prodCount[$val->prod_id] = $prodCount[$val->prod_id] + $val->count; $prodSumm[$val->prod_id] = $prodSumm[$val->prod_id] + $val->count * $val->price; } } $prodModel = Products::model()->findAll(array('order' => 'name')); $this->renderPartial('realizedProd', array('prodSumm' => $prodSumm, 'prodCount' => $prodCount, 'prodModel' => $prodModel)); }
public function actionToday() { $dates = date('Y-m-d'); $startProducts = array(); $inProducts = array(); $outProducts = array(); $inOutProducts = array(); $endProducts = array(); $prodModel = Products::model()->findAll(); //Приход $fakturaProd = Faktura::model()->with('realize.products')->findAll('date(realize_date) = :realize_date', array('realize_date' => $dates)); foreach ($fakturaProd as $value) { foreach ($value->getRelated('realize') as $key => $val) { $inProducts[$val->getRelated('products')->product_id] = $inProducts[$val->getRelated('products')->product_id] + $val->count; } } //Расход $Depfaktura = DepFaktura::model()->with('realizedProd')->findAll('date(real_date) = :real_date', array(':real_date' => $dates)); foreach ($Depfaktura as $value) { foreach ($value->getRelated('realizedProd') as $val) { $outProducts[$val->prod_id] = $outProducts[$val->prod_id] + $val->count; } } $expense = Expense::model()->with('order.products')->findAll('date(order_date) = :dates AND t.kind = :kind', array(':kind' => 1, ':dates' => $dates)); foreach ($expense as $value) { foreach ($value->getRelated('order') as $val) { $inOutProducts[$val->just_id] = $inOutProducts[$val->just_id] + $val->count; } } $curProd = Balance::model()->with('products')->findAll('b_date = :dates', array(':dates' => $dates), array('order' => 'products.name')); foreach ($curProd as $value) { $endProducts[$value->prod_id] = $endProducts[$value->prod_id] + $value->startCount + $inProducts[$value->prod_id] - $outProducts[$value->prod_id] - $inOutProducts[$value->prod_id]; } $this->render('today', array('prodModel' => $prodModel, 'model' => $curProd, 'inProducts' => $inProducts, 'outProducts' => $outProducts, 'inOutProducts' => $inOutProducts, 'endProducts' => $endProducts)); }
<?php $cnt = 1; $product = new Products(); $faktura = new Faktura(); ?> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <script src="<?php echo Yii::app()->request->baseUrl; ?> /js/jquery.table2excel.js" type="text/javascript"></script> <script src="/js/jquery.printPage.js"></script> <?php echo CHtml::link('<i class="fa fa-print"></i> Печать', array('/faktura/ajaxPrint?id=' . $id), array('class' => 'btn btnPrint')); ?> <button class="btn btn-success" id="export">Экспорт в excel</button><br><br> <table id="dataTable" class="table table-bordered"> <thead> <tr> <th></th> <th>Наименование</th> <th>Кол-во</th> <th>Цена</th> <th>Сумма</th> <?php foreach ($dep as $key => $val) { $sum[$key] = 0; ?> <th><?php
//zapsání do databáze $dbZbozi = implode(";", $zbozi); $dbCenySDph = implode(";", $cenySDph); $dbDph = implode(";", $dph); $dbMnozstvi = implode(";", $mnozstvi); Mysql_query("UPDATE {$CONF['sqlPrefix']}faktury SET zbozi='{$dbZbozi}', cenySDph='{$dbCenySDph}', dph='{$dbDph}', mnozstvi='{$dbMnozstvi}' WHERE id={$_GET['faktura']}") or die(mysql_error()); } else { //kontrola $kontrola = false; if (is_numeric($_POST["mnozstvi"][2])) { $kontrola = True; } foreach ($_POST["mnozstvi"] as $key => $value) { if (!is_numeric($value)) { $kontrola = False; } } //sestavení řetězce "mnozstvi" $mnozstvi = ";" . implode(";", $_POST["mnozstvi"]); //odeslání dotazu if ($kontrola) { Mysql_query("UPDATE {$CONF['sqlPrefix']}faktury SET mnozstvi='{$mnozstvi}' WHERE id={$_GET['faktura']}") or die(mysql_error()); } } } /* --Zobrazení faktury-- */ $faktura = new Faktura($_GET["faktura"]); //Echo $faktura->getHtmlFull(); $tmplPom = new GlassTemplate("../templates/{$CONF['vzhled']}/faktura.html", "../templates/default/faktura.html"); echo $faktura->priradDoTmpl($tmplPom, "fakturaAdminFull", "../templates/{$CONF['vzhled']}/faktura.html"); }
public function actionAjaxAllProd() { $halfstuff = new Halfstaff(); $from = $_POST['from']; $to = $_POST['to']; $allOutProd = array(); $products = array(); $prodCount = array(); $prodSumm = array(); $outProdSumm = array(); for ($i = 0; $i <= date('j', strtotime($to)) - date('j', strtotime($from)); $i++) { $dish = new Expense(); $outProduct = array(); $model = Expense::model()->with('order.dish.dishStruct')->findAll('date(t.order_date) = :dates', array(':dates' => date('Y-m-d', strtotime($from) + $i * 3600 * 24))); foreach ($model as $value) { foreach ($value->getRelated('order') as $val) { $curDish[$val->getRelated('dish')->dish_id] = $val->getRelated('dish')->name; $dishCount[$val->getRelated('dish')->dish_id] = $dishCount[$val->getRelated('dish')->dish_id] + $val->count; foreach ($val->getRelated('dish')->getRelated('dishStruct') as $vals) { $products[$vals->prod_id] = $products[$vals->prod_id] + $vals->amount / $val->getRelated('dish')->count * $val->count; } } } $model2 = Expense::model()->with('order.dish.halfstuff')->findAll('date(t.order_date) = :dates', array(':dates' => date('Y-m-d', strtotime($from) + $i * 3600 * 24))); foreach ($model2 as $value) { foreach ($value->getRelated('order') as $val) { $curDish[$val->getRelated('dish')->dish_id] = $val->getRelated('dish')->name; foreach ($val->getRelated('dish')->getRelated('halfstuff') as $vals) { $stuff[$val->getRelated('dish')->dish_id][$vals->halfstuff_id] = $stuff[$val->getRelated('dish')->dish_id][$vals->halfstuff_id] + $vals->amount / $val->getRelated('dish')->count * $val->count; } } } $model3 = Expense::model()->with('order.halfstuff.stuffStruct')->findAll('date(t.order_date) = :dates', array(':dates' => date('Y-m-d', strtotime($from) + $i * 3600 * 24))); foreach ($model3 as $value) { foreach ($value->getRelated('order') as $val) { $curStuff[$val->getRelated('halfstuff')->halfstuff_id] = $val->getRelated('halfstuff')->name; $stuffCount[$val->getRelated('halfstuff')->halfstuff_id] = $dishCount[$val->getRelated('halfstuff')->halfstuff_id] + $val->count; foreach ($val->getRelated('halfstuff')->getRelated('stuffStruct') as $vals) { if ($vals->types == 1) { $products[$vals->prod_id] = $products[$vals->prod_id] + $vals->amount / $val->getRelated('halfstuff')->count * $val->count; } elseif ($vals->types) { $stuff[$val->getRelated('halfstuff')->halfstuff_id][$vals->prod_id] = $stuff[$val->getRelated('halfstuff')->halfstuff_id][$vals->prod_id] + $vals->amount / $val->getRelated('halfstuff')->count * $val->count; } } } } $model6 = Faktura::model()->with('realize')->findAll('date(realize_date) = :dates', array(':dates' => date('Y-m-d', strtotime($from) + $i * 3600 * 24))); foreach ($model6 as $value) { foreach ($value->getRelated('realize') as $val) { $prodCount[$val->prod_id] = $prodCount[$val->prod_id] + $val->count; $prodSumm[$val->prod_id] = $prodSumm[$val->prod_id] + $val->count * $val->price; $outProdSumm[$val->prod_id] = $outProdSumm[$val->prod_id] + $products[$val->prod_id] * $val->price; } } /*foreach (Department::model()->findAll() as $val) { //echo date('Y-m-d',strtotime($from)+($i*3600*24))."<br>"; $outProduct = $halfstuff->sumArray($outProduct,$dish->getDishProd($val->department_id, date('Y-m-d',strtotime($from)+($i*3600*24)))); //$outDishStuff = $dish->getDishStuff($depId,$dates); } $allOutProd = $halfstuff->sumArray($allOutProd,$outProduct);*/ } $prodModel = Products::model()->findAll(array('order' => 'name')); $this->renderPartial('ajaxAllProd', array('prodCount' => $prodCount, 'prodSumm' => $prodSumm, 'prodModel' => $prodModel, 'products' => $products, 'outProdSumm' => $outProdSumm)); }
public function getRealized($id, $dates) { $dates = date('Y-m-d H:i:s', strtotime($dates) + 86400); $model = Faktura::model()->with('realize')->find(array('condition' => 't.realize_date < "' . $dates . '"' . ' AND realize.prod_id=' . $id, 'order' => 't.realize_date DESC')); if (!empty($model)) { foreach ($model->getRelated('realize') as $val) { $price = $val->price; } } else { $price = 0; } return $price; }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionTodayStorage() { $dates = date('Y:m:d'); $depId = $_POST['depId']; $Products = array(); /*$model = DepBalance::model()->with('products')->findAll('t.department_id = :depId AND t.type = :type',array(':depId'=>$depId,'type'=>1)); foreach ($model as $val) { $products[$val->prod_id] = $val->getRelated('products')->name; }*/ //$model = new Products(); //$products = $model->getProdName($depId); $storageModel = Storage::model()->findAll(); $balanceModel = Balance::model()->with('products')->findAll('b_date = :b_date', array(':b_date' => $dates)); if (!empty($balanceModel)) { foreach ($balanceModel as $val) { $products[$val->prod_id] = $val->getRelated('products')->name; $Products[$val->prod_id] = $Products[$val->prod_id] + $val->startCount; } } else { foreach ($storageModel as $val) { $Products[$val->prod_id] = $Products[$val->prod_id] + $val->curCount; } } $realizedProd = Faktura::model()->with('realize.products')->findAll('date(realize_date) = :realize_date', array('realize_date' => $dates)); foreach ($realizedProd as $value) { foreach ($value->getRelated('realize') as $val) { $Products[$val->prod_id] = $Products[$val->prod_id] + $val->count; } } $realizeStorageProd = DepFaktura::model()->with('realizedProd')->findAll('date(real_date) = :real_date AND fromDepId = :fromDepId', array(':real_date' => $dates, ':fromDepId' => 0)); foreach ($realizeStorageProd as $value) { foreach ($value->getRelated('realizedProd') as $val) { $Products[$val->prod_id] = $Products[$val->prod_id] - $val->count; } } $expBalance = Yii::app()->db->createCommand()->select('ord.just_id,ord.count')->from('expense ex')->join('orders ord', 'ord.expense_id = ex.expense_id')->where('date(ex.order_date) = :dates AND ex.kind = :kind ', array(':dates' => $dates, ':kind' => 1))->queryAll(); foreach ($expBalance as $val) { $Products[$val['just_id']] = $Products[$val['just_id']] - $val['count']; } $this->renderPartial('todayStorage', array('Products' => $Products, 'products' => $products, 'depId' => $depId)); }
<?php $cnt = 1; $product = new Products(); $faktura = new Faktura(); ?> <style> thead{ background-color:white; } </style> <table id="dataTable" class="table table-bordered"> <thead> <tr> <th></th> <th>Наименование</th> <th>Цена</th> <?php foreach ($dep as $val) { ?> <th><?php echo $val; ?> </th> <?php } ?> <th>Прочие</th> </tr> </thead> <tbody>
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Faktura the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Faktura::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }