PHP代码
<?php
namespace Admin\Controller;
use Think\Controller;
class GoodController extends Controller
{
public function release()
{
/*
* 开始新的操作
* */
$data=array();
$data['productname']=$_POST['productname'];
$data['introduction']=$_POST['introduction'];
$data['codenumber']=$_POST['codenumber'];
$data['Productunit']=I('post.Productunit');
$data['sku']=I('post.sku');
$data['province']=I('post.province');
$data['city']=I('post.city');
$data['town']=I('post.town');
$data['classification']=I('post.classification');
$data['Extendedclass']=I('post.Extendedclass');
$data['Commoditybrand']=I('post.Commoditybrand');
$data['Commoditybrand']=I('post.Commoditybrand');
$data['Shopprice']=I('post.Shopprice');
$data['Marketvalue']=I('post.Marketvalue');
$data['Capitalizedcost']=I('post.Capitalizedcost');
$data['Commission']=I('post.Commission');
$data['original_img']=I('post.original_img');
/*商品重量*/
$data['Commodityweight']=I('post.Commodityweight');
$data['mail']=I('post.mail');
/*库存数量*/
$data['Inventoryquantity']=I('post.Inventoryquantity');
/*赠送积分*/
$data['Giftpoints']=I('post.Giftpoints');
/*兑换积分*/
$data['exchange_integral']=I('post.exchange_integral');
/*商品关检词*/
$data['Keyword']=I('post.Keyword');
/*商品详情描述*/
$data['describe']=I('post.describe');
$commodity=M('commodity');
/*准备开启事物*/
$commodity->startTrans();
$result=$commodity->add($data);
if(!$result){
/*回滚事物*/
$commodity->rollback();
}else{
/*提交事物*/
$commodity->commit();
}
/*1导入thinkphp得我自带的auth类库
* 加锁操作。若果同个用户（判断同个用户名操作）同时加入同样的sku时，
* 那么如果存在时就加不上去（数量），如果不存在时（如果不存在时的数量不一样时）就insert上去
*
*/
$province = M('prvices')->where ( array('pid'=>1) )->select ();
$this->assign('province',$province);
$this->display();
}
public function getRegion(){
/*
* 接收市区
* */
$Region=M("prvices");
$map['pid']=$_REQUEST["pid"];
$map['type']=$_REQUEST["type"];
$list=$Region->where($map)->select();
echo json_encode($list);
}
public function sku()
{
$this->display();
}
}
html：
<tr>
<td>商品所在地</td>
<td>
<select name="addres" id="province"
<option value="0" selected>省份/直辖市</option>
<volist name="province" id="vo">
<option value="{$vo.id}" >{$vo.name}
</option>
</volist>
</select>
<select name="city" id="city"
<option value="0">市/县</option>
</select>
<select name="town" id="town">
<option value="0">镇/区</option>
</select>
</td>
</tr>
function loadRegion(sel,type_id,selName,url){
jQuery("#"+selName+" option").each(function(){
jQuery(this).remove();
});
jQuery("<option value=0>请选择</option>").appendTo(jQuery("#"+selName));
if(jQuery("#"+sel).val()==0){
return;
}
jQuery.getJSON(url,{pid:jQuery("#"+sel).val(),type:type_id},
function(data){
if(data){
jQuery.each(data,function(idx,item){
jQuery("<option value="+item.id+">"+item.name+"</option>").appendTo(jQuery("#"+selName));
});
}else{
jQuery("<option value='0'>请选择</option>").appendTo(jQuery("#"+selName));
}
}
);
}
