public static function getOrderlist($params)
{
$payment = $params['Payment'];
$BuyerName = $params['BuyerName'];
$Status = $params['Status'];
$EvaStatus = $params['EvaStatus'];
$OrderSN = $params['search_text'];
$starttime = $params['starttime'];
$endtime = $params['endtime'];
$pageSize = $params['pageSize'] ? $params['pageSize'] : 10;
$criteria = new CDbCriteria();
$criteria->order = "t.CreateTime desc";
$criteria->condition = "t.SellerID = {$params['OrganID']} and t.IsDelete=0";
//订单类型
if ($payment && in_array($payment, array(1, 2))) {
$criteria->addCondition("t.Payment = {$payment}", "AND");
}
//买家查询
if ($BuyerName) {
$BuyerName = EvaluateService::checkKey(urldecode($BuyerName));
$model = self::getOrgan(array('OrganName' => $BuyerName));
$idArr = array();
foreach ($model as $v) {
$idArr[] = $v->ID;
}
$criteria->addInCondition("t.BuyerID", $idArr);
}
//订单状态
if ($Status && in_array($Status, array(1, 2, 3, 5, 9, 10))) {
if ($Status == 5) {
$criteria->addCondition("t.Status = 3 and t.ReturnStatus!=0", "AND");
} else {
if ($Status == 3) {
$criteria->addCondition("t.Status = 3 and t.ReturnStatus=0", "AND");
} else {
$criteria->addCondition("t.Status = {$Status}", "AND");
}
}
} else {
if ($params['SendStatus']) {
$criteria->addCondition("t.Status in(1,2)", "AND");
}
}
//订单评价
if ($EvaStatus && $EvaStatus == 1) {
$criteria->addCondition("t.EvaStatus in(0,15) and t.Status=9", "AND");
} else {
if ($EvaStatus == 2) {
$criteria->addCondition("t.EvaStatus in(16,20) and t.Status=9", "AND");
}
}
//订单号
if ($OrderSN) {
$OrderSN = EvaluateService::checkKey(urldecode($OrderSN));
$criteria->addCondition("t.OrderSN like '%{$OrderSN}%'");
}
//下单时间
if ($starttime && $endtime) {
$criteria->addCondition("t.CreateTime > {$starttime} and t.CreateTime < {$endtime}+3600*24", 'AND');
} else {
if ($starttime) {
$criteria->addCondition("t.CreateTime > {$starttime}", 'AND');
} else {
if ($endtime) {
$criteria->addCondition("t.CreateTime < {$endtime}+3600*24", 'AND');
}
}
}
$data = new CActiveDataProvider('PapOrder', array('criteria' => $criteria, 'pagination' => array('pageSize' => $pageSize)));
$datas = $data->getData();
foreach ($datas as $vv) {
foreach ($vv->goodsinfo as $v) {
$v = self::getVersionGoods($v);
}
}
$data->setData($datas);
return $data;
}
public function actionEvaluateinfo()
{
$this->pageTitle = Yii::app()->name . '-' . "评价详情";
$this->render('evaluateinfo', array('info' => EvaluateService::idgetserviceeva()));
}
public function actionPapeva()
{
$evarr = array();
$evarr = EvaluateService::getevainfo(3);
$this->pageTitle = Yii::app()->name . '-' . "添加评价";
$OrderID = Yii::app()->request->getParam('order');
//订单ID 传递前台(input)
if ($OrderID) {
$Status = $_GET['Status'];
//订单状态
$BuyerID = $_GET['BuyerID'];
//买家ID
$EvaStatus = $_GET['EvaStatus'];
//评价状态
$this->render('papeva', array('OrderID' => $OrderID, 'Status' => $Status, 'EvaStatus' => $EvaStatus, 'BuyerID' => $BuyerID, 'evarr' => $evarr));
exit;
} else {
$Status = $_POST['Status'];
$BuyerID = $_POST['BuyerID'];
$OrderID = $_POST['evalOrderID'];
$EvaStatus = $_POST['EvaStatus'] ? $_POST['EvaStatus'] : null;
$OrganID = Commonmodel::getOrganID();
$Message = Yii::app()->request->getParam('Evaluations');
// var_dump($Message);die;
$evaID = Yii::app()->request->getParam('evaID');
if (isset($_POST)) {
$addsql = "insert into pap_evaluation_organ (Identity,OrganID,Recier,JudgeID,OrderID,Score,Message,CreateTime) values ";
$keytop = 1;
foreach ($evaID as $ekeys => $evalue) {
if ($keytop != 1) {
$addsql .= ",";
}
$addsql .= "(";
$addsql .= 3;
$addsql .= ",";
$addsql .= $OrganID;
$addsql .= ",";
$addsql .= $BuyerID;
$addsql .= ",";
$addsql .= $ekeys;
$addsql .= ",";
$addsql .= $OrderID;
$addsql .= ",";
$addsql .= $evalue;
$addsql .= ",'";
$addsql .= htmlspecialchars($Message);
$addsql .= "',";
$addsql .= time();
$addsql .= ")";
$keytop = 2;
// EvaluateService::addjudgerecord($ekeys, $evalue, $BuyerID, 3, $OrderID);
}
$bool = Yii::app()->papdb->createCommand($addsql)->execute();
if ($bool) {
//获取被评价机构分数
$organScore = "select Recier,Score,OrderID from pap_evaluation_organ where OrganID={$OrganID} and OrderID=" . $OrderID;
$bool2 = Yii::app()->papdb->createCommand($organScore)->queryAll();
$sum = 0;
foreach ($bool2 as $v) {
$sum += $v['Score'];
}
//获取被评价的机构信用等级
$organGrade = "select Grade from jpd_organ where ID=" . $bool2[0]['Recier'];
$bool3 = Yii::app()->jpdb->createCommand($organGrade)->queryRow();
//更新被评价的机构信用等级
$sum2 = $sum + $bool3['Grade'];
$Gradesum = "update jpd_organ set Grade = {$sum2} where ID=" . $bool2[0]['Recier'];
$bool4 = Yii::app()->jpdb->createCommand($Gradesum)->execute();
if ($Status == 9 && $EvaStatus == null) {
$EvaStatus = 16;
//如果该订单经销商先评价，把状态改为16
} else {
if ($Status == 9 && $EvaStatus == 15) {
$EvaStatus = 20;
//如果该订单之前服务店评价过一次，则经销商此时评价状态改为20
}
}
$bool2 = PapOrder::model()->updateByPK($OrderID, array('EvaStatus' => $EvaStatus));
$rs = array('success' => 1, 'errorMsg' => '评价成功');
} else {
$rs = array('success' => 0, 'errorMsg' => '评价失败');
}
}
}
$this->render("evaresult", array('result' => $rs));
}
?>
/css/newer/productdel.css" />
<style>
.spxq ,.sptj{text-indent:20px}
.wrap-contents{overflow:visible}
</style>
<div class="column">
<?php
$eval = EvaluateService::getevalgoods(array('GoodsID' => $GoodsID));
$total = $eval[1] + $eval[2] + $eval[3];
$goods_eval = !empty($total) ? sprintf('%0.1f', $eval[1] / $total * 100) : 0;
$mids_eval = !empty($total) ? sprintf('%0.1f', $eval[2] / $total * 100) : 0;
$bads_eval = !empty($total) ? sprintf('%0.1f', $eval[3] / $total * 100) : 0;
$goods_rate = EvaluateService::getJdtCss($goods_eval);
$mids_rate = EvaluateService::getJdtCss($mids_eval);
$bad_rate = EvaluateService::getJdtCss($bads_eval);
$sql = "SELECT ID FROM `pap_evaluation_goods_image` where GoodsID={$GoodsID} group by EvalID;";
$res = Yii::app()->papdb->createCommand($sql)->queryAll();
$pic_eval = count($res);
?>
<div class="rating">
<p class="rtitle">好评度</p>
<span class="percent fl"><i><?php
echo $goods_eval;
?>
</i>%</span>
<div class="cla_percent fr">
<div class="mt5"><div style="float:left">好评 </div><i>(<?php
echo $goods_eval;
?>
%)</i><?php
?>
</div>
</div>
<!--满意度评价-->
<p class="txxx bor_back m-top10">满意度评价</p>
<div class="bor_back ">
<div class="satisfied ">
<div class="jg-info float_l">
<div class="triangle-border2 tb-border2"></div>
<div class="triangle-border2 tb-background2"></div>
<div style="padding:35px 20px">
<?php
$OrderInfo = PapOrder::model()->findByPK($OrderID);
$OrganInfo = Organ::model()->findByPk($OrderInfo['SellerID']);
$OrganPhoto = OrganPhoto::model()->find("OrganID =:organID", array(':organID' => $OrganInfo['ID']));
$xylevel = EvaluateService::getpets($OrganInfo['Grade']);
if (empty($xylevel) || !$xylevel[0] || !$xylevel[1]) {
$xylvstr = "<div class='xy-div' title='积分过低'><i class='seller-level0'></i></div>";
} else {
$xylvstr = '<div class = "xy-div" title = "积分：' . $OrganInfo['Grade'] . '">' . str_repeat("<i class='seller-level" . $xylevel[0] . "'></i>", $xylevel[1]) . '</div>';
}
?>
<div class="eav-jg-img float_l"><img src="<?php
echo F::uploadUrl() . $OrganPhoto['Path'];
?>
"></div>
<div class="eav-jg-info float_l">
<p><b><?php
echo $OrganInfo['OrganName'];
?>
</b></p>
$ul2 .= '<li>' . str_repeat('<i class="floor"></i>', $fscore) . str_repeat('<i class="half"></i>', $hscore) . str_repeat('<i class="rest"></i>', $rscore) . '<a><em>' . $score . '</em>分</a></li><div class="clear"></div>';
}
}
$avgscore = $i == 0 ? 0.0 : sprintf('%0.1f', $sum / $i);
} else {
if (!empty($fwitem)) {
foreach ($fwitem as $v) {
$ul1 .= "<li>" . $v . '：</li>';
$ul2 .= '<li>' . str_repeat('<i class="rest"></i>', 5) . '<em>0</em>分</a></li>';
}
$avgscore = 0;
}
}
$ul1 .= "</ul>";
$ul2 .= "</ul>";
$jdt = EvaluateService::getJdtCss($praise);
?>
<!--信用管理-->
<div class="mywork">
<h3>我的信用管理</h3>
<p>信用信息</p>
<div style="width:100%; height:108px">
<div class="fl" style=" width:97px; height:97px; padding-left:25px;">
<img src="<?php
echo F::uploadUrl() . $imgUrl;
?>
" class="flimg"/>
</div>
<dl class="fl">
<dd><label style="margin-left:12px;">用户名：</label><a><?php
echo Yii::app()->user->getOrganName();
public function actionGetBuyer()
{
if (Yii::app()->request->isAjaxRequest) {
$buyerid = Yii::app()->request->getParam('buyerid');
//获取买家信用统计
$items = EvaluateService::getevainfo(3);
$totalrow = array();
if (!empty($items)) {
foreach ($items as $k => $v) {
$servicescore = EvaluateService::getevalservice(array('OrganID' => $buyerid, 'm' => $k));
// $totalnum = $servicescore['3'] + $servicescore['2'] + $servicescore['1'];
$totalrow[$k][0] = $v;
$totalrow[$k][1] = $servicescore['3'];
$totalrow[$k][2] = $servicescore['2'];
$totalrow[$k][3] = $servicescore['1'];
// $totalrow[$k][1] = $totalnum ? floor($servicescore['3'] * 100 / $totalnum) : '0';
// $totalrow[$k][2] = $totalnum ? floor($servicescore['2'] * 100 / $totalnum) : '0';
// $totalrow[$k][3] = $totalnum ? floor($servicescore['1'] * 100 / $totalnum) : '0';
}
}
$total = EvaluateService::getevalservice(array('OrganID' => $buyerid));
$totalall = $total['3'] + $total['2'] + $total['1'];
$praise = $totalall ? sprintf('%0.1f', $total['3'] * 100 / $totalall) : 0;
$jdt = EvaluateService::getJdtCss($praise);
echo json_encode(array('jdt' => array('jdt' => $jdt, 'rate' => $praise), 'row' => $totalrow));
}
}
public function actionBuytoevaluation()
{
$this->pageTitle = Yii::app()->name . '-' . "修理厂评价商品";
$this->layout = '';
$OrderStatus = $_GET['OrderStatus'];
$EvaStatus = $_GET['EvaStatus'];
$OrderID = $_GET['OrderID'];
$omodel = PapOrder::model()->findByPk($OrderID, '(EvaStatus=0 or EvaStatus=16) and (Status=9 or Status = 16)');
if (!$omodel) {
$this->redirect(array('orderreview/index/orderstype/4/evastatus/1'));
}
$model = PapOrderGoods::model()->findAll("OrderID=:ID", array(":ID" => $OrderID));
foreach ($model as $key => $value) {
//获得机构ID
// $goodsinfo = PapGoods::model()->find("ID=:ID", array(":ID" => $value['GoodsID']));
// $data[$key]['GoodsID'] = $GoodsID = $goodsinfo->ID;
// $data[$key]['GoodsName'] = $goodsinfo->Name;
// $data[$key]['GoodsNO'] = $goodsinfo->GoodsNO;
// $data[$key]['OrganID'] = $OrganID = $goodsinfo->OrganID;
$data[$key]['GoodsID'] = $GoodsID = $value['GoodsID'];
$data[$key]['GoodsName'] = $value['GoodsName'];
$data[$key]['GoodsNO'] = $value['GoodsNum'];
$data[$key]['OrganID'] = $OrganID = $omodel->SellerID;
//卖家ID
//获得图片
$goodsimg = PapGoodsImageRelation::model()->findAll("GoodsID=:GoodsID ", array(":GoodsID" => $GoodsID));
$data[$key]['GoodsIMG'] = $goodsimg[0]->ImageUrl;
}
$evarr = EvaluateService::getevainfo(2);
$this->render("papeva", array('data' => $data, 'OrderID' => $OrderID, 'OrderStatus' => $OrderStatus, 'EvaStatus' => $EvaStatus, 'evarr' => $evarr));
}
public static function getOrganName($id, $type = 1)
{
$model = Organ::model()->findByPk($id);
$grade = $model->Grade;
//信用等级
$xylevel = EvaluateService::getpets($grade);
if ($type == 2) {
if (empty($xylevel) || !$xylevel[0] || !$xylevel[1]) {
$str = "<div title='暂无' style='color:#888'>暂无</div>";
} else {
$str = '<div title = "积分：' . $grade . '">' . str_repeat("<i class='seller-level" . $xylevel[0] . "'></i>", $xylevel[1]) . '</div>';
}
return "<p class='eval_organ'><a href='" . Yii::app()->createUrl('servicer/uniondealer/detail', array('dealer' => $id)) . "' target='_blank'>" . $model->attributes['OrganName'] . "</a></p>" . "<div>{$str}</div>";
} else {
if (empty($xylevel) || !$xylevel[0] || !$xylevel[1]) {
$str = "<div title='暂无'>暂无</div>";
} else {
$str = '<div title = "积分：' . $grade . '">' . str_repeat("<i class='buyer-level" . $xylevel[0] . "'></i>", $xylevel[1]) . '</div>';
}
return "<p class='eval_organ'>" . $model->attributes['OrganName'] . "</p><div>{$str}</div>";
}
}
