public static function getNotDeleted($code)
{
switch ($code) {
case 'commodity':
$rows = Commodity::model()->findAllByAttributes(array('is_deleted' => 0));
break;
case 'consumable':
$commodity = Commodity::model()->findByPk($_GET['commodityId']);
$rows = $commodity['name']::model()->findAllByAttributes(array('is_deleted' => 0));
break;
case 'category':
$rows = Category::model()->findAllByAttributes(array('is_deleted' => 0));
break;
}
$items = [];
foreach ($rows as $r) {
$items[] = $r['id'];
}
return $items;
}
echo CHtml::link('<i class="icon-trash"></i>', '#', array('class' => 'btn-warning btn buttonDesign', 'title' => 'Delete', 'submit' => array('delete', 'id' => $model->id), 'confirm' => 'Are you sure you want to delete this item?'));
echo "<br/>";
?>
</h1>
<?php
$this->widget('ext.DetailView4Col', array('htmlOptions' => array('class' => 'table table-striped table-condensed table-hover'), 'data' => $model, 'attributes' => array('id', 'name', 'category_id', array('name' => 'location.name', 'label' => 'Location'), array('name' => 'user.name', 'label' => 'Technical Incharge'), array('name' => 'status.status', 'label' => 'Status'), array('name' => 'manufacturer.name', 'label' => 'Manufacturer'), array('name' => 'printertype.name', 'label' => 'Printer Type'), array('name' => 'managementtype.name', 'label' => 'Management Type'), 'memory', 'initial_page_counter', 'current_counter_of_pages', 'serial_number', 'documentFileName', 'imageFileName', 'enable_financial', 'available_on_loan', 'link_to')));
?>
<?php
$link = Link::model()->findByAttributes(array('commodity2_id' => $model->commodity_id));
echo "<table class='table table-bordered'>";
if (count($link) == 0) {
echo "<tr style='background:#F7819F;color:white'><td>No Commodity Linked to {$model->name}</td></tr>";
} else {
$commodity = Commodity::model()->findByAttributes(array('id' => $link['commodity1_id']));
$commodityItems = $commodity['name']::model()->findAllByAttributes(array('link_to' => $model->id));
if (count($commodityItems) != 0) {
echo "<tr style='background:#F5A9A9;'><th colspan='4' style='text-align:center'>Linked " . $commodity['name'] . " Allocate History</th></tr>";
foreach ($commodityItems as $c) {
$cartridgeName = $c['name'];
$fullallocates = Allocate::model()->findAll("commodity_id =:commodity_id AND cons_id=:cons_id", array('commodity_id' => 12, 'cons_id' => $c['id']));
$allocates = Allocate::model()->findAll("commodity_id =:commodity_id AND cons_id=:cons_id AND given_by IS NOT NULL", array('commodity_id' => 12, 'cons_id' => $c['id']));
$total = count($fullallocates);
$allocated = count($allocates);
echo "<tr style='background:#F6E3CE'><th colspan='4'>{$cartridgeName} <code>{$allocated} / {$total} allocated</code></th></tr>";
if (count($allocates) != 0) {
echo "<tr><th>Date Out</th><th>Allocated By</th><th>Allocated To</th></tr>";
foreach ($allocates as $a) {
echo "<tr>";
$date_out = $a['date_out'];
$beau_model = Beautician::model();
$query = "select * from tbl_beautician";
$beau_info = $beau_model->findAllBySql($query);
//构建dropDownList的option用的数组
$beau_options = array();
foreach ($beau_info as $_beau_v) {
if ($_beau_v->beau_valid != 1) {
continue;
}
$beau_options["{$_beau_v->pk_beau_id}"] = "{$_beau_v->beau_realname}";
}
//商品名称及时间数据准备
$ord_item_model = Order_Item::model();
$ord_item_info = $ord_item_model->findByPk($aptm_info->aptm_ord_item_id);
if (isset($ord_item_info)) {
$comm_model = Commodity::model();
$comm_info = $comm_model->findByPk($ord_item_info->ord_item_comm_id);
$comm_serv_model = Commodity_Service::model();
$comm_serv_info = $comm_serv_model->findByPk($ord_item_info->ord_item_comm_id);
}
?>
<?php
$form = $this->beginWidget('CActiveForm');
?>
<table border="1" width="100%" class="table_a">
<tr bgcolor="#add8e6">
<td>
<?php
echo $form->label($aptm_info, 'pk_aptm_id');
?>
</td>
<div class="container">
<button type="button" class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="brand" href="<?php
echo Yii::app()->homeUrl;
?>
">
<?php
echo "AM " . Yii::app()->user->getState("org_name");
?>
</a>
<?php
$allCommodities = Commodity::model()->findAllByAttributes(array('is_deleted' => 0));
foreach ($allCommodities as $commodity) {
$commodityName = lcfirst($commodity['name']);
$notDeletedCategories = MyUtility::getNotDeleted('category');
$categories = CommodityCategory::model()->findAllByAttributes(array('commodity_id' => $commodity['id'], 'category_id' => $notDeletedCategories));
foreach ($categories as $cat) {
//$categoryRow = Category::model()->findByAttributes(array('id'=>$cat['category_id']));
$categoryList[] = array('label' => '<i class="icon-info-sign"></i> ' . $cat['path'], 'url' => array("/{$commodityName}/admin", 'category_id' => $cat['path']));
}
$categoryList[] = array('label' => '<i class="icon-info-sign"></i> Show All', 'url' => array('/' . $commodity['name'] . '/admin'));
$items[] = array('url' => array('/' . $commodity['name'] . '/admin'), 'label' => ' <i class="icon-info-sign"></i> ' . $commodity['name'], 'items' => $categoryList);
$categoryList = array();
}
$items[] = array('label' => '<i class="icon-info-sign"></i> files', 'url' => array("/fm/entry/index/form/16", 'category_id' => $cat['path']));
?>
<div class="container">
<button type="button" class="btn btn-navbar" data-toggle="collapse" data-target=".nav-collapse">
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="brand" href="<?php
echo Yii::app()->homeUrl;
?>
">
<?php
echo CHtml::encode(Yii::app()->name . ' ' . Yii::app()->user->getState("org_name"));
?>
</a>
<?php
$allCommodities = Commodity::model()->findAll();
foreach ($allCommodities as $commodity) {
$items[] = array('label' => '<i class="icon-info-sign"></i> ' . $commodity['name'], 'url' => array('/' . $commodity['name'] . '/admin'));
}
?>
<div class="nav-collapse collapse">
<?php
$this->widget('zii.widgets.CMenu', array('items' => array(array('label' => '<i class="icon-home"></i> Home', 'url' => array('/site/index')), array('label' => '<i class="icon-info-sign"></i> About', 'url' => array('/site/page', 'view' => 'about')), array('label' => '<i class="icon-envelope"></i> Contact', 'url' => array('/site/contact')), array('label' => '<b class="icon-inbox"></b> Commodities <b class="caret"></b>', 'url' => '#', 'linkOptions' => array('class' => 'dropdown-toggle', 'data-toggle' => 'dropdown'), 'itemOptions' => array('class' => 'dropdown'), 'items' => $items), array('label' => '<b class="icon-inbox"></b> Administration <b class="caret"></b>', 'url' => '#', 'linkOptions' => array('class' => 'dropdown-toggle', 'data-toggle' => 'dropdown'), 'itemOptions' => array('class' => 'dropdown'), 'items' => array(array('label' => '<i class="icon-map-marker"></i> Location', 'url' => array('/location/tree')), array('label' => '<i class="icon-user"></i> Suppliers', 'url' => array('/supplier/admin')), array('label' => '<i class="icon-user"></i> Manufacturers', 'url' => array('/manufacturer/admin')), array('label' => '<i class="icon-folder-close"></i> Consumables', 'url' => array('/consumable/admin')), array('label' => '<i class="icon-folder-close"></i> Commodities', 'url' => array('/commodity/admin')), array('label' => '<i class="icon-folder-close"></i> Categories', 'url' => array('/category/admin')))), array('label' => '<i class="icon-folder-close"></i> Manage <b class="caret"></b>', 'url' => '#', 'linkOptions' => array('class' => 'dropdown-toggle', 'data-toggle' => 'dropdown'), 'itemOptions' => array('class' => 'dropdown'), 'items' => array(array('label' => '<i class="icon-user"></i> Users', 'url' => array('/user/admin')), array('label' => '<i class="icon-user"></i> Groups', 'url' => array('/group/admin')), array('label' => '<i class="icon-user"></i> Usergroups', 'url' => array('/usergroup/admin')), array('label' => '<i class="icon-tasks"></i> Blocked Items', 'url' => array('/blockeditem/admin')), array('label' => '<i class="icon-tasks"></i> Statuses', 'url' => array('/status/admin')), array('label' => '<i class="icon-tasks"></i> Currencies', 'url' => array('/currency/admin')), array('label' => '<i class="icon-folder-close"></i> Consumable Types', 'url' => array('/consumabletype/admin')), array('label' => '<i class="icon-folder-close"></i> Supplier Types', 'url' => array('/suppliertype/admin')), array('label' => '<i class="icon-folder-close"></i> Management Types', 'url' => array('/managementtype/admin')))), array('label' => '<i class="icon-user"></i> Login', 'url' => array('/site/login'), 'visible' => Yii::app()->user->isGuest), array('label' => '<i class="icon-user"></i> Logout (' . Yii::app()->user->name . ')', 'url' => array('/site/logout'), 'visible' => !Yii::app()->user->isGuest)), 'encodeLabel' => false, 'htmlOptions' => array('class' => 'nav pull-left'), 'submenuHtmlOptions' => array('class' => 'dropdown-menu')));
?>
</div>
</div>
</div>
</div><!-- mainmenu -->
<div class="container">
<html>
<style>
.buttonDesign{
margin-left : 2px;
margin-right : 2px;
}
</style>
</html>
<?php
/* @var $this BlockeditemController */
/* @var $model Blockeditem */
$commodity = Commodity::model()->findByPk($_GET['commodityId']);
$commodityName = $commodity['name'];
$this->breadcrumbs = array(ucfirst($commodityName) => array("{$commodityName}/admin"), 'Manage' => array("{$commodityName}/admin"), 'Blocked Items');
Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$('#blockeditem-grid').yiiGridView('update', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n");
?>
<h1>Manage <span style="color:#B40431">Blockeditems</span></h1>
<?php
$this->widget('application.extensions.print.printWidget', array('cssFile' => 'print.css', 'printedElement' => '#blockeditem-grid', 'htmlOptions' => array()));
?>
<?php
echo CHtml::link('<i class="icon-file"></i> <b>PDF</b>', 'generatePdf', array('class' => 'btn btn-danger buttonDesign', 'style' => 'height:16px;', 'title' => 'Save as PDF'));
echo CHtml::link('<i class="icon-file"></i> <b>CSV</b>', '#csv', array('class' => 'btn-success btn buttonDesign', 'style' => 'height:16px;', 'title' => 'Save as CSV'));
?>
<?php
$gridWidget = $this->widget('bootstrap.widgets.TbGridView', array('id' => 'blockeditem-grid', 'dataProvider' => $model->search(), 'filter' => $model, 'columns' => array('item_name', array('name' => 'userby.name', 'header' => 'Blocked By'), array('name' => 'blocked_on', 'header' => 'Blocked On', 'value' => 'Yii::app()->dateFormatter->format(Yii::app()->locale->getDateFormat("long"),
CDateTimeParser::parse($data->blocked_on, "yyyy-mm-dd"))'), array('name' => 'blocked_from', 'header' => 'Blocked From', 'value' => 'Yii::app()->dateFormatter->format(Yii::app()->locale->getDateFormat("long"),
CDateTimeParser::parse($data->blocked_from, "yyyy-mm-dd"))'), array('name' => 'blocked_to', 'header' => 'Blocked To', 'value' => 'Yii::app()->dateFormatter->format(Yii::app()->locale->getDateFormat("long"),
/**
* 订单商品添加
*/
public function actionAddOrderItem($ord_id, $item_id)
{
$comm_model = Commodity::model();
if ($item_id != 0) {
//已经选择了item
$ord_item_model = new Order_Item();
//为了这个奇葩的id（要用ord_id来算，还要从0开始计数）
$ord_item_model->pk_ord_itm_id = ($ord_id - 80000000) * 1000;
$query = 'select * from tbl_order_item where pk_ord_itm_ord_id = ' . $ord_id;
$ord_item_info = $ord_item_model->findAllBySql($query);
$ord_item_model->pk_ord_itm_id += count($ord_item_info);
$ord_item_model->pk_ord_itm_ord_id = $ord_id;
$ord_item_model->ord_item_comm_id = $item_id;
$ord_item_model->ord_item_num = 1;
$comm_info = $comm_model->findByPk($item_id);
if ($comm_info) {
$ord_item_model->ord_item_price = $comm_info->comm_price;
}
if ($ord_item_model->save()) {
$this->redirect("./index.php?r=order/detail&id={$ord_id}");
} else {
//var_dump($user_info->getErrors());
//var_dump($customer_info->getErrors());
echo "<script>alert('出错啦003！');</script>";
}
}
$comm_info = $comm_model->findAll();
$this->renderPartial('addOrderItem', array('ord_id' => $ord_id, 'comm_info' => $comm_info));
}
margin-left : 2px;
margin-right : 2px;
}
</style>
</html>
<?php
/* @var $this MonitorController */
/* @var $model Monitor */
$this->breadcrumbs = array('Printers' => array('admin'), 'Manage');
Yii::app()->clientScript->registerScript('search', "\n\$('.search-button').click(function(){\n\t\$('.search-form').toggle();\n\treturn false;\n});\n\$('.search-form form').submit(function(){\n\t\$('#monitor-grid').yiiGridView('update', {\n\t\tdata: \$(this).serialize()\n\t});\n\treturn false;\n});\n");
?>
<h1>Manage <span style="color:#B40431">Printers</span></h1>
<?php
$commodityId = Commodity::model()->find('name =:name', array('name' => $this->id));
echo CHtml::link('<i class="icon-ban-circle"></i>', Yii::app()->homeUrl . '/blockeditem/admin?commodityId=' . $commodityId['id'], array('class' => 'btn-danger btn buttonDesign', 'title' => 'View Blocked ' . ucfirst($this->id)));
echo CHtml::link('<i class="icon-plus"></i>', array('create', 'commodity_id' => $commodityId['id']), array('class' => 'btn-warning btn buttonDesign', 'title' => 'Add ' . ucfirst($this->id)));
echo CHtml::link('<i class="icon-barcode"></i>', Yii::app()->homeUrl . '/printers/admin2', array('class' => 'btn-warning btn buttonDesign', 'title' => 'Get Barcode'));
$this->widget('application.extensions.print.printWidget', array('cssFile' => 'print.css', 'printedElement' => '#printers-grid', 'htmlOptions' => array()));
echo CHtml::link('<i class="icon-file"></i> <b>PDF</b>', 'generatePdf', array('class' => 'btn btn-danger buttonDesign', 'style' => 'height:16px;', 'title' => 'Save as PDF'));
echo CHtml::link('<i class="icon-file"></i> <b>CSV</b>', '#csv', array('class' => 'btn-success btn buttonDesign', 'style' => 'height:16px;', 'title' => 'Save as CSV'));
?>
<?php
echo "<br/><br/>";
/** Flash Messages with allocated ID's**/
foreach (Yii::app()->user->getFlashes() as $key => $message) {
echo '<div height:15px><span class="flash-' . $key . ' myFlash">' . $message . "</span></div>";
}
Yii::app()->clientScript->registerScript('myHideEffect', '$(".flash-success").animate({opacity: 1.0}, 4000).fadeOut("fast");', CClientScript::POS_READY);
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model = new Blockeditem();
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
if (isset($_POST['Blockeditem'])) {
$model->commodity_id = $_POST['Blockeditem']['commodity_id'];
$model->item_id = $_POST['Blockeditem']['item_id'];
$model->blocked_by = $_POST['Blockeditem']['blocked_by'];
$model->blocked_on = $_POST['Blockeditem']['blocked_on'];
$model->blocked_from = $_POST['Blockeditem']['blocked_from'];
$model->blocked_to = $_POST['Blockeditem']['blocked_to'];
$commo = Commodity::model()->findByPk($model->commodity_id);
$item = $commo['name']::model()->findByPk($model->item_id);
$model->item_name = $item['name'];
//$model->attributes=$_POST['Blockeditem'];
if ($model->validate()) {
/** Single Line **/
if (isset($_POST['Blockeditem']['block_group'])) {
$grps = $_POST['Blockeditem']['block_group'];
$model->flag = 'G';
foreach ($grps as $grp) {
$singlemodel = new Blockeditem();
$singlemodel->attributes = $model->attributes;
$singlemodel->blocked_for = $grp;
$commo = Commodity::model()->findByPk($model->commodity_id);
$item = $commo['name']::model()->findByPk($model->item_id);
$singlemodel->item_name = $item['name'];
$singlemodel->save();
}
}
if (isset($_POST['Blockeditem']['block_user'])) {
//echo "<script>djsahdja</script>";die;
$users = $_POST['Blockeditem']['block_user'];
$model->flag = 'U';
foreach ($users as $user) {
$singlemodel = new Blockeditem();
$singlemodel->attributes = $model->attributes;
$singlemodel->blocked_for = $user;
$commo = Commodity::model()->findByPk($model->commodity_id);
$item = $commo['name']::model()->findByPk($model->item_id);
$singlemodel->item_name = $item['name'];
$singlemodel->save();
}
}
if (!isset($_POST['Blockeditem']['block_group']) && !isset($_POST['Blockeditem']['block_user'])) {
$model->flag = 'A';
$model->save();
}
$commo = Commodity::model()->findByPk($model->commodity_id);
$commodityName = $commo['name'];
$cons = $commodityName::model()->findByPk($model->item_id);
$cons->status_id = 4;
$cons->update();
Yii::app()->request->redirect("http://localhost/asset_management/index.php/{$commodityName}/admin");
}
}
$this->render('create', array('model' => $model));
}
<b><?php
echo CHtml::encode($data->getAttributeLabel('END_DATE'));
?>
:</b>
<?php
echo CHtml::encode($data->END_DATE);
?>
<br />
<b><?php
echo CHtml::encode($data->getAttributeLabel('TYPE_ID'));
?>
:</b>
<?php
if ($data->TYPE_ID) {
echo CHtml::encode(Commodity::model()->FindByPk($data->TYPE_ID)->name);
}
?>
<br />
<b><?php
echo CHtml::encode($data->getAttributeLabel('CREATED_BY'));
?>
:</b>
<?php
echo CHtml::encode($data->CREATED_BY);
?>
<br />
<b><?php
echo CHtml::encode($data->getAttributeLabel('LAST_MODIFIED_BY'));
/**
* 销售一览
* @throws CException
*/
public function actionShowSale()
{
//通过模型来实现数据表信息查询
//产生模型对象
$commodity_model = Commodity::model();
$query = 'select * from tbl_commodity';
//判断Filter是否被用户选择了
if (isset($_POST["comm_kind"])) {
if ($_POST['comm_kind'] != 9999) {
$query = $query . " where comm_kind=" . $_POST["comm_kind"];
}
}
$commodity_info = $commodity_model->findAllBySql($query);
//传递到视图
$this->renderPartial('showSale', array('commodity_info' => $commodity_info));
}
function aptm_infomation($appointment)
{
$order_item_model = Order_Item::model();
$comm_service_model = Commodity_Service::model();
$order_model = Order::model();
$commodity_model = Commodity::model();
$view_order_count_model = View_Order_Count::model();
$aptm_infomation = array();
//开始时间
$start_time = date("H:i", strtotime($appointment->aptm_time));
$aptm_infomation[0] = $start_time;
//终了时间
$query = 'select * from tbl_order_item where pk_ord_itm_id=' . $appointment->aptm_ord_item_id;
$order_item_info = $order_item_model->findBySql($query);
$duration = 30;
if (isset($order_item_info)) {
$query = 'select * from tbl_commodity_service where pk_serv_id=' . $order_item_info->ord_item_comm_id;
$comm_service_info = $comm_service_model->findBySql($query);
if (isset($comm_service_info)) {
$duration += $comm_service_info->serv_duration;
}
}
$end_time = date("H:i", strtotime("{$start_time} + {$duration} minute"));
$aptm_infomation[1] = $end_time;
//预约单号
// $aptm_infomation[2] = $appointment->pk_aptm_id;
//订单号
if (isset($order_item_info)) {
$aptm_infomation[2] = $order_item_info->pk_ord_itm_ord_id;
}
//客户姓名
$aptm_infomation[3] = $appointment->aptm_cust_name;
//客户编号
$cust_id = 0;
if (isset($order_item_info)) {
$query = 'select * from tbl_order where pk_ord_id=' . $order_item_info->pk_ord_itm_ord_id;
$order_info = $order_model->findBySql($query);
if (isset($order_info)) {
$cust_id = $order_info->ord_cust_id;
}
}
$aptm_infomation[4] = $cust_id;
//预约项目
$aptm_name = '未知';
if (isset($comm_service_info)) {
$query = 'select * from tbl_commodity where pk_comm_id=' . $comm_service_info->pk_serv_id;
$commodity_info = $commodity_model->findBySql($query);
if (isset($commodity_info)) {
$aptm_name = $commodity_info->comm_name;
}
}
$aptm_infomation[5] = $aptm_name;
//地址
$aptm_infomation[6] = $appointment->aptm_cust_addr;
//联系方式
$aptm_infomation[7] = $appointment->aptm_cust_tel;
//刷卡金额
$price = 0;
if (isset($order_info)) {
$query = 'select * from view_order_count where pk_ord_id = ' . $order_info->pk_ord_id;
$view_order_count_info = $view_order_count_model->findBySql($query);
// echo '<pre>';
// print_r($view_order_count_info);
// echo '</pre>';
if (isset($view_order_count_info)) {
$price = $view_order_count_info->total;
}
$price -= $order_info->ord_paid_money;
}
$aptm_infomation[8] = $price;
return $aptm_infomation;
}
/**
* 按照选定的日期和美疗师来显示预约（包括普通预约和1元预约），用以计算金额
* @throws CException
*/
public function actionSelectAptmByDay()
{
define('APTM_ID', 0);
define('COMM_NAME', 1);
define('CUST_NAME', 2);
define('PRICE', 3);
if (isset($_POST['beau_id']) && $_POST['beau_id'] != 0 && isset($_POST['from_date_year']) && isset($_POST['from_date_month']) && isset($_POST['from_date_day']) && isset($_POST['to_date_year']) && isset($_POST['to_date_month']) && isset($_POST['to_date_day'])) {
//整理日期
$from_date = $_POST['from_date_year'] . '-' . $_POST['from_date_month'] . '-' . $_POST['from_date_day'];
$to_date = $_POST['to_date_year'] . '-' . $_POST['to_date_month'] . '-' . $_POST['to_date_day'];
$from_date = date("Y-m-d H:i:s", strtotime("{$from_date}"));
$to_date = date('Y-m-d H:i:s', strtotime("{$to_date} +1 day"));
if ($from_date > $to_date) {
echo "<script>alert('起始日期应该早于或等于终了日期！');</script>";
}
//TODO:金额信息较复杂，应该需要再建一张表来计算，需要讨论
//传递形式：
/*
xxxx-xx-xx
------------------------------------------
|aptmid|aaaa |
|项目名 |aaaa |
|客户名 |bbbb |
|金额： |111 |
------------------------------------------
xxxx-xx-xx
------------------------------------------
|aptmid|aaaa |
|项目名 |aaaa |
|客户名 |bbbb |
|金额： |111 |
------------------------------------------
|aptmid|aaaa |
|项目名 |aaaa |
|客户名 |bbbb |
|金额： |111 |
------------------------------------------
*/
//定义数组
$day_count = $this->countDays($from_date, $to_date);
$aptm_info_by_day = array($day_count);
//查询普通预约
//（从tbl_appointment的预约日期入手,包括关联的tbl_order_item,tbl_commodity以获取客户名，项目名等信息）
$aptm_model = Aptm::model();
$query = 'select * from tbl_appointment where aptm_beau_id = ' . $_POST['beau_id'] . ' and aptm_time >= "' . $from_date . '"' . ' and aptm_time < "' . $to_date . '"';
$aptm_info = $aptm_model->findAllBySql($query);
if (isset($aptm_info)) {
for ($cnt_day = 0; $cnt_day < $day_count; $cnt_day++) {
$counter_by_day = 0;
foreach ($aptm_info as $_v_aptm_info) {
$day_selected = date('Y-m-d', strtotime("{$from_date}" . ' +' . $cnt_day . ' day'));
$day_compare = date('Y-m-d', strtotime($_v_aptm_info->aptm_time));
if ($day_selected == $day_compare) {
// $info_by_day[APTM_ID] = $_v_aptm_info->pk_aptm_id;
// $info_by_day[CUST_NAME] = $_v_aptm_info->aptm_cust_name;
// $info_by_day[COMM_NAME] = '未取得';
// $info_by_day[PRICE] = 0;
$info_by_day = new InfoByDay();
$info_by_day->aptm_id = $_v_aptm_info->pk_aptm_id;
$info_by_day->cust_name = $_v_aptm_info->aptm_cust_name;
//查询tbl_order_item表以取得commodity_id
$order_item_model = Order_Item::model();
$order_item_info = $order_item_model->findByPk($_v_aptm_info->aptm_ord_item_id);
if (isset($order_item_info)) {
$comm_model = Commodity::model();
$comm_info = $comm_model->findByPk($order_item_info->ord_item_comm_id);
if (isset($comm_info)) {
// $info_by_day[COMM_NAME] = $comm_info->comm_name;
$info_by_day->comm_name = $comm_info->comm_name;
}
//TODO:此处为暂定处理，在修改金额的时候需要修改！
// $info_by_day[PRICE] = $order_item_info->ord_item_price;
$info_by_day->price = $order_item_info->ord_item_price;
}
$aptm_info_by_day[$cnt_day][$counter_by_day] = $info_by_day;
$counter_by_day++;
}
}
}
}
//查询1元特殊预约
$contact_model = Contact::model();
$query = 'select * from tbl_contact where con_beau_id = ' . $_POST['beau_id'] . ' and con_time >="' . $from_date . '"' . ' and con_time <"' . $to_date . '"';
$contact_info = $contact_model->findAllBySql($query);
$contact_info_by_day = array($day_count);
if (isset($contact_info)) {
for ($cnt_day = 0; $cnt_day < $day_count; $cnt_day++) {
$counter_by_day = 0;
foreach ($contact_info as $_v_contact_info) {
// $info_by_day[APTM_ID] = $_v_contact_info->pk_contact_id;
// $info_by_day[CUST_NAME] = $_v_contact_info->con_name;
// $info_by_day[COMM_NAME] = '未取得';
// //TODO:此处为暂定处理，在修改金额的时候需要修改！
// $info_by_day[PRICE] = 0;
$info_by_day = new InfoByDay();
$info_by_day->aptm_id = $_v_contact_info->pk_contact_id;
$info_by_day->cust_name = $_v_contact_info->con_name;
//查询tbl_code表以获取COMM_NAME
$code_model = Code::model();
$query = 'select * from tbl_code where code_tbl_name="tbl_contact" and code_name="con_prefer" and code_value=' . $_v_contact_info->con_prefer;
$code_info = $code_model->findBySql($query);
if (isset($code_info)) {
// $info_by_day[COMM_NAME] = $code_info->code_meaning;
$info_by_day->comm_name = $code_info->code_meaning;
}
$contact_info_by_day[$cnt_day][$counter_by_day] = $info_by_day;
//TODO:此处的三维数组改为自定义类试试看
$counter_by_day++;
}
}
}
//获取美疗师姓名
$beau_model = Beautician::model();
$beau_info = $beau_model->findByPk($_POST['beau_id']);
$beau_name = '没名字';
if (isset($beau_info)) {
$beau_name = $beau_info->beau_realname;
}
// //转向列表显示页面
// $this->redirect('./index.php?r=aptm/showAptmByDay&beau_name='.$beau_name.
// 'from_date='.$from_date.
// 'to_date='.$to_date.
// 'day_count='.$day_count.
// 'aptm_info_by_day='.$aptm_info_by_day.
// 'contact_info_by_day='.$contact_info_by_day);
$this->actionShowAptmByDay($beau_name, $from_date, $to_date, $day_count, $aptm_info_by_day, $contact_info_by_day);
return;
}
//有东西没有选择的话，依旧描绘当前的选择视图
//TODO:需要将已经选择的内容回传给视图以便修改
$this->renderPartial('selectAptmByDay');
}
public function getInfo()
{
/* Items allocated*/
$commodity['consumable'] = Consumable::model()->findAll();
$commodity['monitor'] = Monitor::model()->findAll();
$commodity['printers'] = Printers::model()->findAll();
$commodity['devices'] = Devices::model()->findAll();
$dup = $commodity;
/* Items available on Loan*/
$availableOnLoan = 0;
$thresholdItems = 0;
$content = '';
foreach ($commodity as $key => $commo) {
foreach ($commo as $item) {
if ($item['available_on_loan'] == 1 || $item['available_on_loan'] == 'Yes') {
++$availableOnLoan;
}
if ($key == 'consumable') {
$commodity = Commodity::model()->findByAttributes(array('name' => $key));
$allocates = Allocate::model()->findAllByAttributes(array('commodity_id' => $commodity['id'], 'cons_id' => $item['id']));
if (count($allocates) < $item['threshold']) {
++$thresholdItems;
}
}
}
}
/** Allocated and unallocated **/
$countAllocated = 0;
$countUnAllocated = 0;
$commodity = $dup;
$unAllocated = Allocate::model()->findAllByAttributes(array('date_out' => NULL));
$allocated = Allocate::model()->findAll('date_out IS NOT NULL');
$countAllocated += count($allocated);
$countUnAllocated += count($unAllocated);
$content .= '<b style="color:red">' . $availableOnLoan . '</b> item available on loan<br/>';
$content .= '<b style="color:red">' . $thresholdItems . '</b> item below threshold<br/>';
$content .= '<b style="color:red">' . $countAllocated . '</b> item allocated<br/>';
$content .= '<b style="color:red">' . $countUnAllocated . '</b> item unallocated<br/>';
/* Items below threshold*/
return $content;
}
<?php
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('id' => 'transfer-cons-form', 'enableAjaxValidation' => false, 'htmlOptions' => array('enctype' => 'multipart/form-data')));
?>
<?php
$commodity = Commodity::model()->findByAttributes(array('id' => $_GET['commodity_id']));
$consumable = $commodity['name']::model()->findByAttributes(array('id' => $_GET['itemId']));
?>
<h3 style="color: #B40431"> <?php
echo $consumable['name'];
?>
</h3>
<?php
$temp = $_GET['commodity_id'];
$tempname = Commodity::model()->findByAttributes(array('id' => $temp));
//echo $tempname['name'];
?>
<?php
/*$consumable = $tempname['name']::model()->findByAttributes(array('id'=>$_GET['itemId']));?>
<h3 style="color: #B40431"> <?php echo $consumable['name']; */
?>
</h3>
<p class="help-block">Fields with <span class="required">*</span> are required.</p>
<?php
echo $form->errorSummary($model);
?>
echo $form->textField($model, 'FORM_NAME', array('size' => 60, 'maxlength' => 128, 'placeHolder' => 'Form Name'));
?>
</div>
</div>
</div>
</tr>
<tr>
<div class="row">
<div class="col-md-3 col-sm-6">
<div class="span2"><?php
echo $form->labelEx($model, 'TYPE_ID');
?>
</div>
<div class="span3"><?php
echo $form->dropDownList($model, 'TYPE_ID', CHtml::listData(Commodity::model()->findAll(), 'id', 'name'), array('empty' => '--- Select Commodity ---'));
?>
</div>
<code>Link it to a commodity.</code>
</div>
</div>
</tr>
</table>
<div class="row">
<?php
//echo $form->labelEx($model,'BEGIN_DATE');
?>
<?php
/*$this->widget('zii.widgets.jui.CJuiDatePicker', array(
'model' => $model,
/**
* 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 Commodity the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Commodity::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
<div class="span3"><?php
echo $form->textField($model, 'name', array('span' => 3, 'maxlength' => 50));
?>
</div>
</div>
</div>
</tr>
<tr>
<div class="row">
<div class="col-md-3 col-sm-6">
<div class="span2"><?php
echo $form->labelEx($model, 'commodity_id', array('class' => 'inline-labels'));
?>
</div>
<div class="span3"><?php
echo $form->dropDownList($model, 'commodity_id', CHtml::listData(Commodity::model()->findAll(), 'id', 'name'), array('span' => 2, 'prompt' => '---'));
?>
</div>
</div>
</div>
</tr>
</table>
<div style="text-align: center;">
<?php
echo '<br/>';
?>
<?php
echo TbHtml::submitButton($model->isNewRecord ? 'Submit' : 'Update', array('color' => TbHtml::BUTTON_COLOR_SUCCESS, 'size' => TbHtml::BUTTON_SIZE_DEFAULT));
?>
<?php
<html>
<style>
.buttonDesign{
margin-left : 2px;
margin-right : 2px;
}
</style>
</html>
<?php
/* @var $this AllocateController */
/* @var $model Allocate */
?>
<?php
$commodity = Commodity::model()->findByAttributes(array('id' => $_GET['commodity_id']));
$commodityName = $commodity['name'];
$row = $commodityName::model()->findByAttributes(array('id' => $model->cons_id));
$this->breadcrumbs = array(ucfirst($commodityName) => array("{$commodityName}/admin"), 'Manage' => array("{$commodityName}/admin"), 'Allocate');
?>
<h1>Allocate <span style="color:#B40431"><?php
echo $row['name'];
?>
</span></h1>
<?php
//echo CHtml::link('List All','http://localhost/asset_management/index.php/allocate/index',array('class'=>'btn-danger btn buttonDesign'));
//echo CHtml::link('View '.$model->name,array('view', 'id'=>$model->id),array('class'=>'btn-danger btn buttonDesign'));
//echo CHtml::link('Manage All','http://localhost/asset_management/index.php/allocate/admin',array('class'=>'btn-inverse btn buttonDesign'));
//echo "<br/><br/>";
?>
<?php
/* @var $this BlockeditemController */
/* @var $model Blockeditem */
?>
<?php
$commodity = Commodity::model()->findByPk($model->commodity_id);
$commodityName = $commodity['name'];
$this->breadcrumbs = array(ucfirst($commodityName) => array("{$commodityName}/admin"), 'Manage' => array("{$commodityName}/admin"), 'Blocked Items' => Yii::app()->request->urlReferrer, 'Update');
?>
<h1>Update Blockeditem</h1>
<?php
$this->renderPartial('_customUpdate', array('model' => $model));
