public function getNum($code) { switch ($code) { case 1: $rows = Commodity::model()->findAll(); $heading = 'commodity'; $count = count($rows); break; case 2: $rows = Category::model()->findAll(); $heading = 'category'; $count = count($rows); break; case 3: $rows = Supplier::model()->findAll(); $heading = 'supplier'; $count = count($rows); break; case 4: $rows = User::model()->findAll(); $heading = 'user'; $count = count($rows); break; case 5: $rows = Allocate::model()->findAll(); $heading = 'allocate'; $count = count($rows); break; } $content = '<b style="class:circle">' . $count . '</b><br/>'; $i = 2; if ($code != 5) { foreach ($rows as $r) { $content .= $r['name'] . '<br/>'; --$i; if ($i <= 0) { break; } } while ($i != 0) { $content .= '<br/>'; --$i; } $content .= '<p style="display:inline;text-align:right"><i><a href="http://localhost/asset_management/index.php/' . $heading . '/admin">View All</a></i></p><br/>'; } return $content; }
/** * 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 Supplier the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Supplier::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function undodeleteSupplier($supplier_id) { Supplier::model()->updateByPk((int) $supplier_id, array('status' => Yii::app()->params['active_status'])); }
<div class="span3"><?php echo $form->textField($model, 'inventory_no', array('span' => 2)); ?> </div> </div> </div> </tr> <tr> <div class="row"> <div class="col-md-3 col-sm-6"> <div class="span2"><?php echo $form->labelEx($model, 'supplier_id', array('class' => 'inline-labels')); ?> </div> <div class="span3"><?php echo $form->dropDownList($model, 'supplier_id', CHtml::listData(Supplier::model()->findAll(), 'id', 'name'), array('span' => 2, 'prompt' => '---')); ?> <?php echo TbHtml::button('+', array('color' => TbHtml::BUTTON_COLOR_SUCCESS, 'size' => TbHtml::BUTTON_SIZE_DEFAULT, 'onclick' => 'js:document.location.href="/asset_management/index.php/supplier/create"')); ?> </div> <div class="span2"><?php echo $form->labelEx($model, 'status_id', array('class' => 'inline-labels')); ?> </div> <div class="span3"><?php echo $form->dropDownList($model, 'status_id', CHtml::listData(Status::model()->findAll(), 'id', 'status'), array('span' => 2, 'prompt' => '---')); ?> <?php echo TbHtml::button('+', array('color' => TbHtml::BUTTON_COLOR_SUCCESS, 'size' => TbHtml::BUTTON_SIZE_DEFAULT, 'onclick' => 'js:document.location.href="/asset_management/index.php/status/create"')); ?>
<div class="form"> <?php $form = $this->beginWidget('application.widgets.SnapActiveForm', array('id' => 'supplier-item-form', 'enableAjaxValidation' => false, 'layout' => BsHtml::FORM_LAYOUT_HORIZONTAL, 'htmlOptions' => array('enctype' => 'multipart/form-data', 'class' => 'row'))); ?> <div class="col-lg-9 clearfix"> <?php echo $form->textFieldControlGroup($model, 'name', array('size' => 45, 'maxlength' => 45)); ?> <?php echo $form->dropDownListControlGroup($model, 'supplier_id', CHtml::listData(Supplier::model()->findAll(), 'id', 'name'), array('class' => 'chosen')); ?> <?php echo $form->dropDownListControlGroup($model, 'packing_station_id', CHtml::listData(PackingStation::model()->findAll(), 'id', 'name'), array('class' => 'chosen')); ?> <?php echo $form->textFieldControlGroup($model, 'value', array('size' => 7, 'maxlength' => 7)); ?> <?php echo $form->dropDownListControlGroup($model, 'unit', $model->getUnitList()); ?> <?php echo $form->dropDownListControlGroup($model, 'available_from', $model->getMonthList()); ?> <?php echo $form->dropDownListControlGroup($model, 'available_to', $model->getMonthList()); ?> <?php
private function reload($data = array()) { $this->layout = '//layouts/column_sale'; $model = new ReceivingItem(); $data['model'] = $model; $data = $this->sessionInfo($data); //echo $data['trans_header']; die(); //$data['n_item_expire']=ItemExpir::model()->count('item_id=:item_id and quantity>0',array('item_id'=>(int)$item_id)); $model->comment = $data['comment']; if ($data['supplier_id'] != null) { $supplier = Supplier::model()->findbyPk($data['supplier_id']); $data['supplier'] = $supplier; //$data['company_name'] = $supplier->company_name; //$data['full_name'] = $supplier->first_name . ' ' . $supplier->last_name; //$data['mobile_no'] = $supplier->mobile_no; } if (Yii::app()->request->isAjaxRequest) { $cs = Yii::app()->clientScript; $cs->scriptMap = array('jquery.js' => false, 'bootstrap.js' => false, 'jquery.min.js' => false, 'bootstrap.notify.js' => false, 'bootstrap.bootbox.min.js' => false, 'bootstrap.min.js' => false, 'jquery-ui.min.js' => false, 'EModalDlg.js' => false); Yii::app()->clientScript->scriptMap['jquery-ui.css'] = false; Yii::app()->clientScript->scriptMap['box.css'] = false; $this->renderPartial('admin', $data, false, true); } else { $this->render('admin', $data); } }
protected function sessionInfo($data = array()) { $model = new ReceivingPayment(); $data['model'] = $model; $data['supplier_id'] = Yii::app()->rpaymentCart->getSupplierId(); $data['employee_id'] = Yii::app()->session['employeeid']; if ($data['supplier_id'] !== null) { $account = AccountSupplier::model()->getAccountInfo($data['supplier_id']); $data['account'] = $account; $data['balance'] = $account->current_balance; $supplier = Supplier::model()->findbyPk($data['supplier_id']); $data['fullname'] = $supplier->company_name . ' [ ' . $supplier->first_name . ' ' . $supplier->last_name . ' ] '; $data['save_button'] = false; } else { $data['fullname'] = ''; $data['balance'] = 0; $data['save_button'] = true; } return $data; }
public function actionGeoCode() { define("MAPS_HOST", "maps.google.com"); //define("KEY", "AIzaSyAU7aJq2EcQYJV7BsjZg1lkhR2dYBTZxfU"); define("KEY", "AIzaSyDtX7h4kdxUSrWpqVz3uRYP2-gxDMXa6hM"); $delay = 0; $base_url = "http://" . MAPS_HOST . "/maps/geo?output=xml" . "&key=" . KEY; $Suppliers = Supplier::model()->findAll(); foreach ($Suppliers as $supplier) { $id = $supplier->id; $address = $supplier->address . ' ' . $supplier->address2 . ', ' . $supplier->suburb . ', ' . $supplier->state . ', ' . $supplier->postcode; $address = trim($address, ' ,'); if (!empty($address)) { $request_url = $base_url . "&q=" . urlencode($address . ', Australia'); $xml = simplexml_load_file($request_url) or die("url not loading"); $status = $xml->Response->Status->code; if (strcmp($status, "200") == 0) { // Successful geocode $geocode_pending = false; $coordinates = $xml->Response->Placemark->Point->coordinates; $coordinatesSplit = split(",", $coordinates); // Format: Longitude, Latitude, Altitude $lat = $coordinatesSplit[1]; $lng = $coordinatesSplit[0]; $supplier->lattitude = $lat; $supplier->longitude = $lng; $supplier->save(); } else { if (strcmp($status, "620") == 0) { // sent geocodes too fast $delay += 100000; } else { // failure to geocode $geocode_pending = false; echo "Address " . $address . ", Australia failed to geocoded. "; echo "Received status " . $status . "\n"; } } usleep($delay); } } }
$form = $this->beginWidget('CActiveForm', array('id' => 'purchinforec-form', 'enableAjaxValidation' => false)); $this->widget('ToolbarButton', array('isSave' => true, 'UrlSave' => 'purchinforec/write', 'isCancel' => true, 'UrlCancel' => 'purchinforec/cancelwrite')); echo $form->hiddenField($model, 'purchinforecid'); ?> <table> <tr> <td> <div class="row"> <?php echo $form->labelEx($model, 'addressbookid'); ?> <?php echo $form->hiddenField($model, 'addressbookid'); ?> <input type="text" name="addressbook_name" id="addressbook_name" readonly value="<?php echo Supplier::model()->findByPk($model->addressbookid) !== null ? Supplier::model()->findByPk($model->addressbookid)->fullname : ''; ?> "> <?php $this->beginWidget('zii.widgets.jui.CJuiDialog', array('id' => 'addressbook_dialog', 'options' => array('title' => Yii::t('app', 'Supplier'), 'width' => 'auto', 'autoOpen' => false, 'modal' => true))); $this->widget('zii.widgets.grid.CGridView', array('id' => 'addressbook-grid', 'dataProvider' => $supplier->Searchwstatus(), 'filter' => $supplier, 'template' => '{summary}{pager}<br>{items}{pager}{summary}', 'columns' => array(array('header' => '', 'type' => 'raw', 'value' => 'CHtml::Button("+", array("name" => "send_addressbook", "id" => "send_addressbook", "onClick" => "$(\\"#addressbook_dialog\\").dialog(\\"close\\"); $(\\"#addressbook_name\\").val(\\"$data->fullname\\"); $(\\"#Purchinforec_addressbookid\\").val(\\"$data->addressbookid\\");"))'), array('name' => 'addressbookid', 'visible' => false, 'value' => '$data->addressbookid', 'htmlOptions' => array('width' => '1%')), 'fullname', array('class' => 'CCheckBoxColumn', 'name' => 'recordstatus', 'selectableRows' => '0', 'header' => 'Record Status', 'checked' => '$data->recordstatus')))); $this->endWidget('zii.widgets.jui.CJuiDialog'); echo CHtml::Button('...', array('onclick' => '$("#addressbook_dialog").dialog("open"); return false;')); ?> <?php echo $form->error($model, 'addressbookid'); ?> </div>
/** * just an example * */ public static function Report($cid) { $m = InvoicePallet::model()->findByAttributes(array('id' => $cid)); $n = Supplier::model()->findByAttributes(array('number' => $m->supplier_no)); $i = Pallet::model()->findByAttributes(array('id' => $m->pid)); spl_autoload_unregister(array('YiiBase', 'autoload')); require_once Yii::getPathOfAlias('webroot') . '/assets/phpword/samples/Sample_Header.php'; spl_autoload_register(array('YiiBase', 'autoload')); $phpWord = new \PhpOffice\PhpWord\PhpWord(); $phpWord->setDefaultFontName('新宋体'); $phpWord->setDefaultFontSize(12); $phpWord->setDefaultParagraphStyle(array('align' => 'both', 'lineHeight' => '2')); $section = $phpWord->addSection(); $section->addText('开票通知', array('bold' => true, 'size' => 24), array('align' => 'center', 'space' => array('before' => 200, 'after' => 100))); $section->addText('注意:请收到立即开票!谢谢!', array('bold' => true, 'size' => 20), array('align' => 'center', 'space' => array('before' => 200, 'after' => 200))); $section->addText('TO:' . ' ' . $n->name . ' 传真:', null, array('align' => 'left')); $section->addText('公司名称:拓泓贸易(上海)有限公司', null, array('align' => 'left')); $section->addText('纳税人识别号:310112690186868', null, array('align' => 'left')); $section->addText('开票地址电话:上海市闵行区元江路5500号D1幢869室(021-54846073)', null, array('align' => 'left')); $section->addText('开户行及账号:上海浦东发展银行闵行支行 98280154740006293', null, array('align' => 'left')); $section->addTextBreak(1); $section->addText('开票资料如下:', array('bold' => true, 'size' => 16), array('align' => 'left')); $styleTable = array('borderSize' => 2, 'borderColor' => '686868', 'align' => 'center'); $styleFirstRow = array('borderBottomSize' => 18, 'borderBottomColor' => '0000FF', 'bgColor' => '66BBFF'); $styleCell = array('valign' => 'center', 'halign' => 'center'); $fontStyle = array('bold' => false, 'size' => 11, 'borderSize' => 2); $center = array('spaceBefore' => 10, 'spaceAfter' => 0, 'align' => 'center', 'valign' => 'center'); $phpWord->addTableStyle('table1', $styleTable, array('align' => 'center')); $table = $section->addTable('table1'); $table->addRow(); $table->addCell(1800)->addText('开票品名', $fontStyle, $center); $table->addCell(1000)->addText('型号', $fontStyle, $center); $table->addCell(800)->addText('数量', $fontStyle, $center); $table->addCell(800)->addText('单位', $fontStyle, $center); $table->addCell(1000)->addText('单价', $fontStyle, $center); $table->addCell(1800)->addText('总价', $fontStyle, $center); $table->addCell(2500)->addText('合同号', $fontStyle, $center); $table->addRow(); $table->addCell(1800)->addText($m->type, $fontStyle, $center); $table->addCell(1000)->addText($m->model, $fontStyle, $center); $table->addCell(800)->addText($m->num, $fontStyle, $center); $table->addCell(800)->addText($m->unit, $fontStyle, $center); $table->addCell(800)->addText($m->unit_price, $fontStyle, $center); $table->addCell(1800)->addText($m->unit_price * $m->num, $fontStyle, $center); $table->addCell(2500)->addText($i->purchase_contract_no, $fontStyle, $center); $table->addRow(); $table->addCell(1800)->addText('合计', $fontStyle, $center); $table->addCell(1000)->addText('', $fontStyle, $center); $table->addCell(800)->addText('', $fontStyle, $center); $table->addCell(800)->addText('', $fontStyle, $center); $table->addCell(800)->addText('', $fontStyle, $center); $table->addCell(1800)->addText('¥' . $m->unit_price * $m->num, $fontStyle, $center); $table->addCell(2500)->addText($i->purchase_contract_no, $fontStyle, $center); $section->addText('请开票后,全套发票寄至以下地址:', array('bold' => true, 'size' => 12), array('align' => 'left')); $section->addText('上海市闵行区曲吴路589号9号楼205', null, array('align' => 'left')); $section->addText('拓泓贸易(上海)有限公司', null, array('align' => 'left')); $section->addText('电话:021-54846073 13661561440', null, array('align' => 'left')); $section->addText('联系人:叶建伟', null, array('align' => 'left')); $section->addText('如有疑问,请今日联系!', null, array('align' => 'left')); $section->addText('日期:' . date('Y-m-d'), null, array('align' => 'left')); $fileName = "{$n->name}.doc"; // $fileName = iconv ( "utf-8", "gb2312", $fileName); // $fileName = mb_convert_encoding($fileName, "utf-8", "auto"); $absPath = Yii::getPathOfAlias('webroot'); $relPath = '/uploads/files/'; $file = $absPath . $relPath . $fileName; $fPath = $relPath . $fileName; $fName = '开票通知 - ' . date("Ymd"); $res = array('name' => $fName, 'url' => $fPath); write($phpWord, $file, $writers); return $res; }