HTML页面:
<?php if($theMethod=='browsec1'){ ?>
<script type="text/javascript">
$(function(){
$('#orderDate').change(function(){
var user_name=$('#seller').val();
var date=$('#orderDate').val();
var table='c1';
ajax(user_name,date,table);
})
$('#seller').change(function(){
var user_name=$('#seller').val();
var date=$('#orderDate').val();
var table='c1';
ajax(user_name,date,table);
})
})
function ajax(user_name,date,table){
//alert(table);return;
var inputchange=$('#inputchange').val(); // '/crm/order-queryonedaypayment'
$.post(inputchange,{user_name:user_name,date:date,table:table},function(res){
if(res=='0'){
return false;
}
var re=$.parseJSON(res); //js转json对象
$('#payment').val(parseInt(re.payments)); //parseInt 转int类型
})
}
</script>
<?php }elseif($theMethod=='browsec2'){?>
<script type="text/javascript">
$(function(){
$('#orderDate').change(function(){
var user_name=$('#seller').val();
var date=$('#orderDate').val();
var table='c2';
ajax(user_name,date,table);
})
$('#seller').change(function(){
var user_name=$('#seller').val();
var date=$('#orderDate').val();
var table='c2';
ajax(user_name,date,table);
})
})
function ajax(user_name,date,table){
//alert(table);return;
var inputchange=$('#inputchange').val();
$.post(inputchange,{user_name:user_name,date:date,table:table},function(res){
if(res=='0'){
return false;
}
var re=$.parseJSON(res); //js转json对象
$('#payment').val(parseInt(re.payments)); //parseInt 转int类型
})
}
</script>
<?php }elseif($theMethod=='browsec3'){?>
<script type="text/javascript">
$(function(){
$('#orderDate').change(function(){
var user_name=$('#seller').val();
var date=$('#orderDate').val();
var table='c3';
ajax(user_name,date,table);
})
$('#seller').change(function(){
var user_name=$('#seller').val();
var date=$('#orderDate').val();
var table='c3';
ajax(user_name,date,table);
})
})
function ajax(user_name,date,table){
//alert(table);return;
var inputchange=$('#inputchange').val();
$.post(inputchange,{user_name:user_name,date:date,table:table},function(res){
if(res=='0'){
return false;
}
var re=$.parseJSON(res); //js转json对象
$('#payment').val(parseInt(re.payments)); //parseInt 转int类型
})
}
</script>
<?php }?>
<input id='inputchange' type='hidden' value='<?php echo str_replace('.html','',helper::createLink('crm.order', 'queryonedaypayment', ""));?>'/>
<table class='table table-form'>
<tr>
<th class='w-70px'>接单人</th>
<td><?php echo html::select('seller', $sellers, '', "class='form-control' style='width:300px'");?></td>
</tr>
<tr>
<th class='w-60px'>选择日期</th>
<td><?php echo html::input('orderDate', '', "class='form-control form-date' style='width:300px'");?></td>
</tr>
<tr>
<th class='w-60px'>支付金额</th>
<td><?php echo html::input('payment', '', "class='form-control' style='width:300px;' disabled='true' ");?></td>
</tr>
</table>
control:模块
public function ajaxqueryonedaypayment($method)
{
if($method=='browsec1'){
$this->view->sellers = $this->loadModel('user')->getPairs('nodeleted,noforbidden,noclosed,working',FULLTIME_LOGO_SALE_DEPT);//LOGO客户经理
}
elseif($method=='browsec2'){
$sellers1 = $this->loadModel('user')->getPairs('nodeleted,noforbidden,noclosed,working',FULLTIME_DATA_SALE_DEPT);//DATA客户经理
$this->view->sellers = $sellers1;
}
elseif($method=='browsec3'){
$sellers1 = $this->loadModel('user')->getPairs('nodeleted,noforbidden,noclosed,working',FULLTIME_CAD_SALE_DEPT);//CAD客户经理
$this->view->sellers = $sellers1;
}
elseif($method=='browses1' || $method=='browses1tb' || $method=='browses1ys' || $method=='browses1pm'){
$sellers1 = $this->loadModel('user')->getPairs('nodeleted,noforbidden,noclosed,working',FULLTIME_SELF_SALE_DEPT);//平面客户经理[旧]
$this->view->sellers = $sellers1;
}
else return;
$this->view->title = '支付金额查询';
$this->view->theMethod = $method;
$this->display();
}
/**
* 查询每日订单支付金额模块
*
*/
public function queryonedaypayment(){
$this->order->queryonedaypay($_POST['user_name'],$_POST['date'],$_POST['table']);
}
model:方法
public function queryonedaypay($name,$date,$work){
if($name!="" && $date!=""){
$orderPay = $this->dao->select('p.*')->from($this->getTableByWork($work))->alias('o')
->leftjoin(TABLE_CRMORDERPAY)->alias('p')
->on("o.id=p.id")
->where('o.deleted')->eq('0')
->andWhere('o.seller')->eq($name)
->andWhere('p.payDate')->eq($date)
->andWhere('p.work')->eq($work)
->fetchAll();
$paySum=0;
foreach ($orderPay as $order){
$paySum+=$order->paysum;
}
$money['payments']=$paySum;//支付金额
$res=json_encode($money);
echo $res;
}else{
echo 0;
}
}
个人案例,不喜勿喷