本例使用的是YII框架。
PHP端
public function actionForlistbox(){
$model= SpecInfo::model()->findAllByAttributes(array('spec_id'=>2));
$arr=array();
foreach($model as $item){
$arr[]=$item->attributes['group'];
}
$js= json_encode($arr);
echo $js;
}
前端：
<script type="text/javascript">
$(document).ready(function(){
var i=0;
var j=1;
$.ajax({
type:'post',
dataType:'json',
url:'./index.php?r=admin/TblGoods/forlistbox',
success:function(msg){
var arr=[];
$.each(msg,function(index,val){
arr[index]=val;
});
while(i<arr.length){
if((arr[j]-arr[i])>0){
$("#br"+j).after("<br/>");
}
i++;
j++;
}
$("#br"+i).after("<br/>");//最后那个复选框后面加一个BR，用户分隔后面的全选框。
}
});
});
</script>
完整代码：
tblGoodsController.php
<?php
class TblGoodsController extends Controller
{
/**
* @var string the default layout for the views. Defaults to '//layouts/column2', meaning
* using two-column layout. See 'protected/views/layouts/column2.php'.
*/
//每个控制器可以在这里单获设置布局文件By Ping 2014-2-20
public $layout='//layouts/houtai';
public $group=array();
/**
* @return array action filters
*/
public function filters()
{
return array(
'accessControl', // perform access control for CRUD operations
'postOnly + delete', // we only allow deletion via POST request
);
}
/**
* Specifies the access control rules.
* This method is used by the 'accessControl' filter.
* @return array access control rules
*/
public function accessRules()
{
return array(
array('allow', // allow all users to perform 'index' and 'view' actions
'actions'=>array('index','view'),
'users'=>array('*'),
),
array('allow', // allow authenticated user to perform 'create' and 'update' actions
'actions'=>array('create','update','forlistbox'),
'users'=>array('@'),
),
array('allow', // allow admin user to perform 'admin' and 'delete' actions
'actions'=>array('admin','delete'),
'users'=>array('admin','@'),
),
array('deny', // deny all users
'users'=>array('*'),
),
);
}
/**
* Displays a particular model.
* @param integer $id the ID of the model to be displayed
*/
public function actionView($id)
{
$this->render('view',array(
'model'=>$this->loadModel($id),
));
}
/**
* Creates a new model.
* If creation is successful, the browser will be redirected to the 'view' page.
*/
public function actionCreate()
{
$model=new TblGoods;
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
//使用下拉菜单，实现添加产品或修改产品时，可以从下拉列表选择产品类别:以下为第1步
//在Goods控制器下实例化category对象，并执行SQL语句，取得所有数据。
$category = TblCategory::model()->findAll();
//如果有URL传递过的来分类ID，则表示这页面是通过分类型表跳转过来的。
if(isset($_GET['cat_id'])){
//接收分类ID
$cat_id=$_GET['cat_id'];
//设置模型的默认分类
$model->cat_id=$cat_id;
}
if(isset($_POST['TblGoods']))
{
$model->attributes=$_POST['TblGoods'];
//yii checkBoxList 的高级使用
//将checkBoxList提交的数据，转换成字符串后再保存到数据库中。
//获取颜色数组后将数组转换成字符串，用豆号分隔。并保存到数据库中。
if(!empty($_POST['TblGoods']['goods_color'])){
$str_color= implode(',', $_POST['TblGoods']['goods_color']);
$model->goods_color=$str_color;
}
//获取颜色数组后将数组转换成字符串，用豆号分隔。并保存到数据库中。
if(!empty($_POST['TblGoods']['goods_size'])){
$str_size= implode(',', $_POST['TblGoods']['goods_size']);
$model->goods_size=$str_size;
}
//实现文件,图片的上传
$model->goods_small_pic= CUploadedFile::getInstance($model, goods_small_pic);
$model->goods_big_pic= CUploadedFile::getInstance($model, goods_big_pic);
if($model->goods_small_pic){
$newimg='goods_small_pic_'.time().'_'.rand(1,9999).".".$model->goods_small_pic->extensionName;
//$newimg="abc.jpg";
$model->goods_small_pic->saveAs('assets/uploads/tblgoods/'.$newimg);
$model->goods_small_pic='assets/uploads/tblgoods/'.$newimg;
}
if($model->goods_big_pic){
$newimg2='goods_big_pic_'.time().'_'.rand(1,9999).".".$model->goods_big_pic->extensionName;
//$newimg2="abcd.jpg";
$model->goods_big_pic->saveAs('assets/uploads/tblgoods/'.$newimg2);
$model->goods_big_pic='assets/uploads/tblgoods/'.$newimg2;
}
if($model->save())
//$this->redirect(array('view','id'=>$model->goods_id));
$this->redirect(array('admin'));
}
$this->render('create',array(
'model'=>$model,
//使用下拉菜单，实现添加产品或修改产品时，可以从下拉列表选择产品类别:以下为第2步
//在Goods控制器下create将上面得到的数组，分配到create这个VIEW页面。
'category'=>$category,
));
}
/**
* Updates a particular model.
* If update is successful, the browser will be redirected to the 'view' page.
* @param integer $id the ID of the model to be updated
*/
public function actionUpdate($id)
{
$model=$this->loadModel($id);
// Uncomment the following line if AJAX validation is needed
// $this->performAjaxValidation($model);
//yii checkBoxList 的高级使用
//如果数据库颜色存在颜色数据，先将数据读取出来，转换成数组后，再赋值给$model->goods_color
//这时候，在视图那边的checkBoxList将会显示从数据库中存在的值了。
if(!empty($model->goods_color)){
$color=$model->goods_color;
$arr_color= explode(',', $color);
$model->goods_color=$arr_color;
}
//如果数据库颜色存在尺寸数据，先将数据读取出来，转换成数组后，再赋值给$model->goods_size
//这时候，在视图那边的checkBoxList将会显示从数据库中存在的值了。
if(!empty($model->goods_size)){
$size=$model->goods_size;
$arr_size= explode(',', $size);
$model->goods_size=$arr_size;
}
//使用下拉菜单，实现添加产品或修改产品时，可以从下拉列表选择产品类别:以下为第1步
//在Goods控制器下实例化category对象，并执行SQL语句，取得所有数据。
$category = TblCategory::model()->findAll();
if(isset($_POST['TblGoods']))
{
$model->attributes=$_POST['TblGoods'];
//获取颜色数组后将数组转换成字符串，用豆号分隔。并保存到数据库中。
if(!empty($_POST['TblGoods']['goods_color'])){
$str_color= implode(',', $_POST['TblGoods']['goods_color']);
$model->goods_color=$str_color;
}
//获取颜色数组后将数组转换成字符串，用豆号分隔。并保存到数据库中。
if(!empty($_POST['TblGoods']['goods_size'])){
$str_size= implode(',', $_POST['TblGoods']['goods_size']);
$model->goods_size=$str_size;
}
//实现文件,图片的上传
$model->goods_small_pic= CUploadedFile::getInstance($model, goods_small_pic);
$model->goods_big_pic= CUploadedFile::getInstance($model, goods_big_pic);
if($model->goods_small_pic){
$newimg='goods_small_pic_'.time().'_'.rand(1,9999).".".$model->goods_small_pic->extensionName;
//$newimg="abc.jpg";
$model->goods_small_pic->saveAs('assets/uploads/tblgoods/'.$newimg);
$model->goods_small_pic='assets/uploads/tblgoods/'.$newimg;
}else{
$model->goods_small_pic=$_POST['temp_img1'];
}
if($model->goods_big_pic){
$newimg2='goods_big_pic_'.time().'_'.rand(1,9999).".".$model->goods_big_pic->extensionName;
//$newimg2="abcd.jpg";
$model->goods_big_pic->saveAs('assets/uploads/tblgoods/'.$newimg2);
$model->goods_big_pic='assets/uploads/tblgoods/'.$newimg2;
}else{
$model->goods_big_pic=$_POST['temp_img2'];
}
if($model->save())
//$this->redirect(array('view','id'=>$model->goods_id));
$this->redirect(array('admin','id'=>'$model->goods_id'));
}
$this->render('update',array(
'model'=>$model,
//使用下拉菜单，实现添加产品或修改产品时，可以从下拉列表选择产品类别:以下为第2步
//在Goods控制器下create将上面得到的数组，分配到create这个VIEW页面。
'category'=>$category
));
}
/**
* Deletes a particular model.
* If deletion is successful, the browser will be redirected to the 'admin' page.
* @param integer $id the ID of the model to be deleted
*/
public function actionDelete($id)
{
$this->loadModel($id)->delete();
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
if(!isset($_GET['ajax']))
$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
}
/**
* Lists all models.
*/
public function actionIndex()
{
$dataProvider=new CActiveDataProvider('TblGoods');
$this->render('index',array(
'dataProvider'=>$dataProvider,
));
}
/**
* Manages all models.
*/
public function actionAdmin()
{
$model=new TblGoods('search');
$model->unsetAttributes(); // clear any default values
if(isset($_GET['TblGoods']))
$model->attributes=$_GET['TblGoods'];
$this->render('admin',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 TblGoods the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model=TblGoods::model()->findByPk($id);
if($model===null)
throw new CHttpException(404,'The requested page does not exist.');
return $model;
}
public function actionForlistbox(){
$model= SpecInfo::model()->findAllByAttributes(array('spec_id'=>2));
$arr=array();
foreach($model as $item){
$arr[]=$item->attributes['group'];
}
$js= json_encode($arr);
echo $js;
}
/**
* Performs the AJAX validation.
* @param TblGoods $model the model to be validated
*/
protected function performAjaxValidation($model)
{
if(isset($_POST['ajax']) && $_POST['ajax']==='tbl-goods-form')
{
echo CActiveForm::validate($model);
Yii::app()->end();
}
}
}
_form.php
<?php
/* @var $this TblGoodsController */
/* @var $model TblGoods */
/* @var $form CActiveForm */
?>
<!--以下3个文件导入是用于thickbox JQuery弹出窗口的-->
<link href="<?php echo CSS_URL;?>thickbox.css" rel="stylesheet" type="text/css">
<script src="<?php echo JS_URL;?>jquery-1.1.3.1.pack.js" type="text/javascript"></script>
<script src="<?php echo JS_URL;?>thickbox-compressed.js" type="text/javascript"></script>
<div class="form">
<?php $form=$this->beginWidget('CActiveForm', array(
'id'=>'tbl-goods-form',
// Please note: When you enable ajax validation, make sure the corresponding
// controller action is handling ajax validation correctly.
// There is a call to performAjaxValidation() commented in generated controller code.
// See class documentation of CActiveForm for details on this.
'enableClientValidation' => true,
//'enableAjaxValidation'=>true,
//要实现图片的上传与修改，enctype这句话一定要加上去。
'htmlOptions'=>array('enctype'=>'multipart/form-data')
)); ?>
<p class="note">注：带 <span class="required">*</span> 号为必填项！</p>
<?php echo $form->errorSummary($model); ?>
<div class="row">
<?php echo $form->labelEx($model,'cat_id'); ?>
<!--
//使用下拉菜单，实现添加产品或修改产品时，可以从下拉列表选择产品类别:以下为第5步
//在_form这个VIEW页面中，使用CHtml::listDate方面，将分类信息语取出来。
//$model:这个表示goods的model对象
//cat_id:这个表示表单中提交出去的name
//$category:这个表示从Goods模型中关联到的Category的模型数据
//cat_id:这个表示下拉菜单使用的值
//cat_name:这个表示form中显示出来的名字，实际用到的其实是cat_id
-->
<?php echo $form->dropDownlist($model,'cat_id',CHtml::listData($category, 'cat_id', 'cat_name'));?>
<?php echo $form->error($model,'cat_id'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'goods_sn'); ?>
<?php echo $form->textField($model,'goods_sn',array('size'=>16,'maxlength'=>16)); ?>
<?php echo $form->error($model,'goods_sn'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'goods_name'); ?>
<?php echo $form->textField($model,'goods_name',array('size'=>32,'maxlength'=>32)); ?>
<?php echo $form->error($model,'goods_name'); ?>
</div>
<div class="row">
<?php //yii checkBoxList 的高级使用
//checkBoxList($model,'goods_color'...)中的goods_color如果被赋了一个数组，则checkBoxList将会显示默认值。
//示例：$model->goods_color=array(1,3);
//则checkBoxList对应的值将会打上勾
?>
<?php echo $form->labelEx($model,'goods_color'); ?><br/>
<?php
$listdata=CHtml::listData(SpecInfo::model()->findAllByAttributes(array('spec_id'=>2)),'spec_info_id','spec_info_name');
?>
<script type="text/javascript">
var k=1;
</script>
<?php echo $form->checkBoxList($model,'goods_color',
$listdata,
array(
'template'=>'{input} {label}',//复选框和文本的版式，这里可以加一些HTML标签
'separator'=>'
<script type="text/javascript">
var br="<img id=br"+window.k+" />";
document.write(br);
window.k++;
</script>',//分隔符，默认分隔符为<br/>，如果不想为<br/>，可以设置为 或其他，这里可以加一些HTML标签。
'checkAll'=>'全选',
'checkAllLast'=>true,
'labelOptions'=>array(
'style'=>'display:inline; margin-right:10px;'
)
)
);
?>
<?php echo $form->error($model,'goods_color'); ?>
</div>
<script type="text/javascript">
$(document).ready(function(){
var i=0;
var j=1;
$.ajax({
type:'post',
dataType:'json',
url:'./index.php?r=admin/TblGoods/forlistbox',
success:function(msg){
var arr=[];
$.each(msg,function(index,val){
arr[index]=val;
});
while(i<arr.length){
if((arr[j]-arr[i])>0){
$("#br"+j).after("<br/>");
}
i++;
j++;
}
$("#br"+i).after("<br/>");//最后那个复选框后面加一个BR，用户分隔后面的全选框。
}
});
});
</script>
<div class="row">
<?php echo $form->labelEx($model,'goods_size'); ?>
<?php echo $form->checkBoxList($model,'goods_size',
CHtml::listData(SpecInfo::model()->findAllByAttributes(array('spec_id'=>3)),'spec_info_id','spec_info_name'),
array(
'separator'=>'',
'labelOptions'=>array(
'style'=>'display:inline; margin-right:10px;'
)
)
);
?>
<?php echo $form->error($model,'goods_size'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'click_count'); ?>
<?php echo $form->textField($model,'click_count',array('size'=>8,'maxlength'=>8)); ?>
<?php echo $form->error($model,'click_count'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'brand_id'); ?>
<?php echo $form->textField($model,'brand_id',array('size'=>8,'maxlength'=>8)); ?>
<?php echo $form->error($model,'brand_id'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'goods_number'); ?>
<?php echo $form->textField($model,'goods_number',array('size'=>8,'maxlength'=>8)); ?>
<?php echo $form->error($model,'goods_number'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'market_price'); ?>
<?php echo $form->textField($model,'market_price',array('size'=>8,'maxlength'=>8)); ?>
<?php echo $form->error($model,'market_price'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'shop_price'); ?>
<?php echo $form->textField($model,'shop_price',array('size'=>8,'maxlength'=>8)); ?>
<?php echo $form->error($model,'shop_price'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'promote_price'); ?>
<?php echo $form->textField($model,'promote_price',array('size'=>8,'maxlength'=>8)); ?>
<?php echo $form->error($model,'promote_price'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'promote_start_date'); ?>
<?php echo $form->textField($model,'promote_start_date'); ?>
<?php echo $form->error($model,'promote_start_date'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'promote_end_date'); ?>
<?php echo $form->textField($model,'promote_end_date'); ?>
<?php echo $form->error($model,'promote_end_date'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'goods_desc'); ?><br/>
<?php //echo $form->textField($model,'goods_desc',array('size'=>60,'maxlength'=>255)); ?>
<?php
//这里是使用ckeditor来输入文本信息
//使用前，先解压ckeditor，然后复制到extensions
//调用时：application.extensions.ckeditor.CKEditor相当于application.extensions.ckeditor.CKEditor.php
$this->widget('application.extensions.ckeditor.CKEditor', array(
'model'=>$model,//$model表示数据表的model
'attribute'=>'goods_desc',//表示要操作的字段
'language'=>'zh-cn',
));
?>
<?php echo $form->error($model,'goods_desc'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'goods_small_pic'); ?>
<?php //echo $form->textField($model,'goods_small_pic',array('size'=>60,'maxlength'=>255)); ?>
<?php echo CHtml::activeFileField($model,'goods_small_pic'); ?>
<?php echo $form->error($model,'goods_small_pic'); ?><br/>
<!--预览图，并且设置一个隐藏域，用来暂存修改前的URL信息-->
<?php echo '<img src="'.$model->goods_small_pic.'" width="100px"/>'; ?>
<?php if(!$model->isNewRecord){?>
<input type="hidden" name="temp_img1" id="hiddenField" value="<?php echo $model->goods_small_pic;?>"/>
<?php }?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'goods_big_pic'); ?>
<?php //echo $form->textField($model,'goods_big_pic',array('size'=>60,'maxlength'=>255)); ?>
<?php echo CHtml::activeFileField($model,'goods_big_pic'); ?>
<?php echo $form->error($model,'goods_big_pic'); ?><br/>
<!--预览图，并且设置一个隐藏域，用来暂存修改前的URL信息-->
<?php echo '<img src="'.$model->goods_big_pic.'" width="100px"/>'; ?>
<?php if(!$model->isNewRecord){?>
<input type="hidden" name="temp_img2" id="hiddenField" value="<?php echo $model->goods_big_pic;?>"/>
<?php }?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'is_sale'); ?>
<?php echo $form->textField($model,'is_sale'); ?>
<?php echo $form->error($model,'is_sale'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'is_delete'); ?>
<?php echo $form->textField($model,'is_delete'); ?>
<?php echo $form->error($model,'is_delete'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'is_best'); ?>
<?php echo $form->textField($model,'is_best'); ?>
<?php echo $form->error($model,'is_best'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'is_new'); ?>
<?php echo $form->textField($model,'is_new'); ?>
<?php echo $form->error($model,'is_new'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'is_hot'); ?>
<?php echo $form->textField($model,'is_hot'); ?>
<?php echo $form->error($model,'is_hot'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'is_promote'); ?>
<?php echo $form->textField($model,'is_promote'); ?>
<?php echo $form->error($model,'is_promote'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'add_time'); ?>
<?php echo $form->textField($model,'add_time'); ?>
<?php echo $form->error($model,'add_time'); ?>
</div>
<div class="row">
<?php echo $form->labelEx($model,'shops_id'); ?>
<?php //echo $form->textField($model,'shops_id'); ?>
<?php echo $form->dropDownList($model,'shops_id', CHtml::listData(TblShops::model()->findAll(),'shops_id','shops_name')) ?>
<?php echo $form->error($model,'shops_id'); ?>
</div>
<div class="row buttons">
<?php echo CHtml::submitButton($model->isNewRecord ? 'Create' : 'Save'); ?>
</div>
<?php $this->endWidget(); ?>
</div><!-- form -->
872
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
