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;
}
