public function NotifyProcess($data, &$msg)
{
// Array( <- $data
// [appid] => wx043b7e57e5b34701
// [attach] => tst
// [bank_type] => CFT
// [cash_fee] => 1
// [fee_type] => CNY
// [is_subscribe] => Y
// [mch_id] => 1255284001
// [nonce_str] => m5kw5jw21ymyy97an9zzu4tn9pzr8ut2
// [openid] => oRqCWt8RWZA9-JoDs2TbhvKBl-kA
// [out_trade_no] => 125528400120150727185109
// [result_code] => SUCCESS
// [return_code] => SUCCESS
// [sign] => AB42A3E63459944637BF05771D86669E
// [time_end] => 20150727185147
// [total_fee] => 1
// [trade_type] => JSAPI
// [transaction_id] => 1005280712201507270489874922
// )
// Yii::log(print_r($data, true), CLogger::LEVEL_ERROR, 'payment.notify');
$notfiyOutput = array();
if (!array_key_exists("transaction_id", $data)) {
$msg = "输入参数不正确";
return false;
}
//查询订单，判断订单真实性
if (!$this->Queryorder($data["transaction_id"], $data['trade_type'])) {
$msg = "订单查询失败";
return false;
}
//更新订单状态
$order = new COrder();
$result = $order->update($data['out_trade_no']);
if ($result['code'] !== 200) {
Yii::log('update fail', CLogger::LEVEL_ERROR, 'payment.notify');
} else {
$orderitem = Order::model()->findByAttributes(array('id' => $data['out_trade_no']));
$userId = $orderitem->userId;
$user = User::model()->findByAttributes(array('id' => $userId));
Yii::log($data['attach'], CLogger::LEVEL_ERROR, 'payment.notify');
if ($user->status == 0) {
$user->status = 1;
}
if ($data['attach']) {
$user->deadDate = $data['attach'];
}
if ($user->save()) {
return true;
} else {
throw new Exception("dead Date fail", 1);
}
}
}
public function actionCompany()
{
try {
$list = Yii::app()->user->orderlist;
$date = Yii::app()->user->orderdate;
$months = Yii::app()->user->ordermonths;
} catch (Exception $e) {
echo 'fail';
die;
}
if (Yii::app()->user->isGuest) {
$userId = Yii::app()->session['user']['id'];
} else {
$userId = Yii::app()->user->id;
}
$wechat = Yii::app()->params['partner']['wechat'];
$jsapi = new WxJsPayHelper();
$openid = $jsapi->GetOpenid();
$this->bodyCss = 'orderDetail';
$totalPrice = 0;
foreach ($list as &$value) {
$product = CompanyProduct::model()->findByAttributes(array('id' => $value['id']));
$value['name'] = $product->name;
$value['price'] = $product->price;
$value['type'] = $product->type;
$totalPrice = $totalPrice + $value['price'] * $value['num'];
}
$order = new COrder();
$newOrder = $order->create(array('userId' => $userId, 'type' => 2, 'price' => $totalPrice, 'orderTime' => date('YmdHis'), 'hubId' => 1));
$orderId = $newOrder['data']['orderId'];
$endDate = date('Y-m-d', strtotime($date) + (date('t', strtotime($date)) - 1) * $months * 60 * 60 * 24);
foreach ($list as $v) {
$companyProduct = $order->createCompanyProduct(array('cproductId' => $v['id'], 'startDate' => $date, 'endDate' => $endDate, 'orderId' => $orderId, 'num' => $v['num']));
Coding::makeCode(array('userId' => $userId, 'type' => $v['type'], 'startDate' => $date, 'endDate' => $endDate, 'times' => $v['num'], 'ordercompanyProductId' => $companyProduct['data']['id']));
}
$input = new WxPayUnifiedOrder();
$input->SetBody('Company product');
// $input->SetAttach(date('Ymd',$date));
$input->SetOut_trade_no((string) $orderId);
$input->SetTotal_fee($totalPrice / 100);
$input->SetTime_start(date('YmdHis'));
$input->SetTime_expire(Assist::getOrderExpireTime(time()));
$input->SetProduct_id(1);
$input->SetNotify_url('http://hubapp.livenaked.com' . $wechat['payment']['notify']);
$input->SetTrade_type('JSAPI');
$input->SetOpenid($openid);
Yii::log(print_r($input->values, 1), CLogger::LEVEL_ERROR, 'input');
$bill = WxPayApi::unifiedOrder($input);
$jsApiParameters = $jsapi->GetJsApiParameters($bill);
$this->render('company', array('list' => $list, 'date' => $date, 'months' => $months, 'totalPrice' => $totalPrice, 'jsparams' => $jsApiParameters));
}
public function run()
{
$this->controller->pageTitle = 'My Account';
$order = new COrder();
$productlist = $order->getlist(Yii::app()->user->id);
$orderlist = $order->getOrderlist(Yii::app()->user->id);
$this->controller->bodyCss = 'account';
// print_r($orderlist);die;
if ($productlist['code'] == 200 && $orderlist['code'] == 200) {
$this->controller->render('account', array('orderlist' => $orderlist['data'], 'productlist' => $productlist['data']));
} else {
throw new Exception("参数错误", 1);
}
}
public function run()
{
if (Yii::app()->request->isAjaxRequest) {
$date = Yii::app()->request->getParam('date');
$mouth = Yii::app()->request->getParam('mouth');
if (!$mouth) {
$date = date('Y-m-d');
} else {
$endDate = date('Y-m-d', strtotime($date) + (date('t', strtotime($date)) - 1) * $mouth * 60 * 60 * 24);
}
$proxy = new COrder();
$result = $proxy->getCompanyProductlist($date, $endDate);
echo CJSON::encode(array('code' => 200, 'data' => $result));
} else {
$this->controller->render('companyproductlist', array('date' => date('Y-m-d')));
}
}
static function select($istart=0,$ioffset=1000,$igrp=0,$order = 'mlt_iListId')
{
$tGrps = array();
$zSql = " ";
$zSql .= " SELECT DISTINCT mlt_iListId FROM moul_tables ";
$zSql .= " INNER JOIN moul_listes ON (moul_listes.id=moul_tables.mlt_iListId)";
if($igrp == 1000) {
$grp = CTableMoulGpFic::get_elms_of_grp(0);
foreach($grp as $i=>$grps){
if($grps['fic']!='') $tGrps[$i] = $grps['fic'];
}
if($grps['fic']!=''){
$zSql .= " WHERE mlt_iListId NOT IN (";
for($i=0;$i<count($tGrps)-1;$i++) $zSql .= $tGrps[$i].",";
$zSql .= $tGrps[$i].") ";
}
}
if($igrp == 1001){
$grp = CTableMoulGpFic::get_elms_of_grp();
foreach($grp as $i=>$grps){
if($grps['fic']!='') $tGrps[$i] = $grps['fic'];
}
if($grps['fic']!=''){
$zSql .= " WHERE mlt_iListId IN (";
for($i=0;$i<count($tGrps)-1;$i++) $zSql .= $tGrps[$i].",";
$zSql .= $tGrps[$i].") ";
}
}
if(($igrp != 0) && ($igrp != 1000) && ($igrp != 1001)) {
$grp = CTableMoulGpFic::get_elms_of_grp($igrp);
foreach($grp as $i=>$grps){
if($grps['fic']!='') $tGrps[$i] = $grps['fic'];
}
if($grps['fic']!=''){
$zSql .= " WHERE mlt_iListId IN (";
for($i=0;$i<count($tGrps)-1;$i++) $zSql .= $tGrps[$i].",";
$zSql .= $tGrps[$i].") ";
}
}
$zSql .= " ORDER BY " . COrder::formate($order) ;
$zSql .= " LIMIT " . $istart ."," . $ioffset;
$toRes = CBdd::select($zSql);
$tFichiers = array();
while($toItm = mysql_fetch_assoc($toRes)){
array_push($tFichiers,$toItm);
}
return $tFichiers;
}
static function select($order='mtp_iListId')
{
$zSql = " SELECT DISTINCT mtp_iListId FROM moul_tables_tmp ";
$zSql .= " INNER JOIN moul_listes ON (moul_listes.id = moul_tables_tmp.mtp_iListId) ";
$zSql .= " ORDER BY " . COrder::formate($order);
$toRes = CBdd::select($zSql);
$tFichiers = array();
while($toItm = mysql_fetch_assoc($toRes)){
array_push($tFichiers,$toItm);
}
return $tFichiers;
}
static function fetchAll($select="*", $where="1", $order="mlt_zMail, mlt_zDateCreation") {
$oRes = parent::select($select, 'moul_tables', $where, COrder::formate($order));
$toResults = array() ;
if ($oRes){
while ($toRes = mysql_fetch_assoc($oRes)){
$toResults[] = $toRes ;
}
}
return $toResults ;
}
static function select($select="*", $where, $order="id") {
if(empty($order)) $order = "id";
return parent::select($select, 'rdvContact', $where, COrder::formate($order));
}
$a = 0;
break;
case 6 : // Filtrer
if(!empty($_GET['idcat'])) $idcat = $_GET['idcat'];
$_SESSION['idcat'] = $idcat;
break;
}
/*------------------------------------------------------
A FAIRE DANS TOUS LES CAS
--------------------------------------------------------*/
$select = "*";
$filtre = "1";
$r_opportunite = CTableOpportuniteUtilisateur::select("*", $filtre, COrder::formate($order));
?>
<!-- InstanceEndEditable -->
<div id="mainwrap">
<div id="header"><?php include("../nav/header.php"); ?></div>
<div id="top"><?php include("../nav/menu_h.php"); ?></div>
<div id="filet">
<div id="zonetitre">
<div id="signe"></div>
<div id="titre"><!-- InstanceBeginEditable name="titre" -->Opportunités<!-- InstanceEndEditable --></div>
</div>
</div>
<div id="contentarea">
<div id="left"><?php include("../nav/menu_g.php"); ?></div>
<div id="center">
<div id="page"><!-- InstanceBeginEditable name="page" --><?php echo CHtml::get_toolbar() ?><!-- InstanceEndEditable --></div>
static function select($select="*", $where="1", $order="id") {
if(empty($order)) $order = "id";
// return parent::select($select, 'gr_rdv_user', $where, COrder::formate($order));
return parent::select($select, 'gr_rdv', $where, COrder::formate($order));
}
if(isset($_GET['idpays'])) $idpays = $_GET['idpays'];
$_SESSION['idpays'] = $idpays;
break;
}
/*------------------------------------------------------
A FAIRE DANS TOUS LES CAS
--------------------------------------------------------*/
if(!empty($_SESSION['idpays']) && (empty($_GET['ville']))){
$filtre = " WHERE pays like '".$_SESSION['idpays']."' ";
}else $filtre = " WHERE pays like '%%' ";
$requetPays_ ="select * from departement ";
if ($_GET['order']) $requetPays_ .= "".$filtre." ORDER BY ".COrder::formate($_GET['order'])."";
else $requetPays_ .= "".$filtre." ORDER BY ".$order." DESC";
$requetPays = CBdd::select($requetPays_);
?>
<!-- InstanceEndEditable -->
<div id="mainwrap">
<div id="header"><? include("../nav/header.php"); ?></div>
<div id="top"><? include("../nav/menu_h.php"); ?></div>
<div id="filet">
<div id="zonetitre">
<div id="signe"></div>
<div id="titre"><!-- InstanceBeginEditable name="titre" -->Departement/Canton<!-- InstanceEndEditable --></div>
</div>
</div>
<div id="contentarea">
static function select($select="*", $where="1", $order="id") {
return parent::select($select, 'groupeUtilitaire', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="rang") {
return parent::select($select, 'categorie_user', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="nom_com"){
return parent::select($select, 'commune', $where, COrder::formate($order));
}
$listeGroupe__ = str_replace(array('(,', ',)',',,'), array('(', ')',''), ($listeGroupe));
$filtre_groupe = " WHERE id_ent <> 0 AND id_ent IN ".$listeGroupe__;
}
$filtre = " 1 " . $filtre_groupe;
$zSql = "" ;
$zSql .= " SELECT * FROM entreprise " ;
$zSql .= " INNER JOIN cat ON cat.id_cat = entreprise.categorie_ent" ;
$zSql .= " INNER JOIN secteur ON secteur.id_sec = cat.secteur_cat" ;
if (($_GET['alphaA']) ||($_SESSION['alphaA'])){
if ($_GET['alphaA'] != '') $zSql .=" AND nom_ent LIKE '" . $_GET['alphaA'] ."%'";
}
$zSql .= $filtre_groupe ;
if ($_GET['order']) $zSql .= " ORDER BY ".COrder::formate($_GET['order']);
else $zSql .= " ORDER BY nom_ent";
$zSql .= " LIMIT " . $iStart . ", " . $iMaxPerPage ;
//print_r($zSql);
$r_user = CBdd::select($zSql);
//print_r($zSql);
?>
<body>
<div id="main">
<?php if(($a != 4) && ($a != 5) ) { ?>
<?php
//----------------------------------------------------------------------------------------------
// LISTE
//----------------------------------------------------------------------------------------------
$id_default_group = CTableConfiguration::get_value_by_element('DEFAULT_GROUP');
public function actionSave()
{
$order = new COrder();
$order->setAttributes(CRequest::getArray($order::getClassName()));
if ($order->validate()) {
$order->save();
if ($this->continueEdit()) {
$this->redirect("?action=viewOrder&id=" . $order->getId());
} else {
$this->redirect("?action=view&id=" . $order->person->getId());
}
return true;
}
$this->addJSInclude("_core/jquery-ui-1.8.20.custom.min.js");
$this->addCSSInclude("_core/jUI/jquery-ui-1.8.2.custom.css");
$this->setData("order", $order);
$this->renderView("_orders/edit.tpl");
}
static function select($select="*", $where="1", $order="id desc") {
if(empty($order)) $order = "id desc";
return parent::select($select, 'user', $where, COrder::formate($order));
}
static function select($select="*", $where="id_campagne < 1", $order="id") {
return parent::select($select, 'gr_email', $where, COrder::formate($order));
}
}
$values = array('id_sec'=>$id, 'nom_sec'=>CFunction::addslashes($nom));
$tcat = new CTableSecteur($values);
$tcat->update();
$msginfo = 'Menu bien modifié';
$a = 0;
break;
}
/*------------------------------------------------------
A FAIRE DANS TOUS LES CAS
--------------------------------------------------------*/
$requetSecteur_ ="select * from secteur";
if ($_GET['order']) $requetSecteur_ .= " ORDER BY ".COrder::formate($_GET['order']);
else $requetSecteur_ .= " ORDER BY ".$order;
$requetSecteur = mysql_query($requetSecteur_);
?>
<!-- InstanceEndEditable -->
<div id="mainwrap">
<div id="header"><?php include("../nav/header.php"); ?></div>
<div id="top"><?php include("../nav/menu_h.php"); ?></div>
<div id="filet">
<div id="zonetitre">
<div id="signe"></div>
<div id="titre"><!-- InstanceBeginEditable name="titre" -->Secteur<!-- InstanceEndEditable --></div>
</div>
</div>
<div id="contentarea">
}
$values = array('id'=>$id, 'nom'=>CFunction::addslashes($nom));
$tcat = new CTablePays($values);
$tcat->update();
$msginfo = 'Menu bien modifié';
$a = 0;
break;
}
/*------------------------------------------------------
A FAIRE DANS TOUS LES CAS
--------------------------------------------------------*/
$requetPays_ ="select * from pays ";
if ($_GET['order']) $requetPays_ .= " ORDER BY ".COrder::formate($_GET['order']);
else $requetPays_ .= " ORDER BY ".$order." DESC";
//print_r($requetPays_);
$requetPays = CBdd::select($requetPays_);
?>
<!-- InstanceEndEditable -->
<div id="mainwrap">
<div id="header"><?php include("../nav/header.php"); ?></div>
<div id="top"><?php include("../nav/menu_h.php"); ?></div>
<div id="filet">
<div id="zonetitre">
<div id="signe"></div>
<div id="titre"><!-- InstanceBeginEditable name="titre" -->Pays<!-- InstanceEndEditable --></div>
</div>
</div>
$i=0;
//while ($row = mysql_fetch_assoc($queryCnt)) {
// $val=$row['id'];
// $i++;
//}
$iMaxPerPage1 = $i-1;
// FIN COMPTEUR
$iNbPage = ceil(($iMaxPerPage1/$iMaxPerPage)) ;
$zSql = "" ;
$zSql .= " SELECT * FROM commune INNER JOIN departement ON commune.departement=departement.id_dep" ;
$zSql .= $filtre ;
$zSql .= COrder::formate($order) ;
$zSql .= " LIMIT " . $iStart . ", " . $iMaxPerPage ;
$requetCcom = CBdd::select($zSql);
?>
<!-- InstanceEndEditable -->
<div id="mainwrap">
<div id="header"><? include("../nav/header.php"); ?></div>
<div id="top"><? include("../nav/menu_h.php"); ?></div>
<div id="filet">
<div id="zonetitre">
<div id="signe"></div>
<div id="titre"><!-- InstanceBeginEditable name="titre" -->Commune<!-- InstanceEndEditable --></div>
</div>
</div>
<div id="contentarea">
static function select($select="*", $where="1", $order="id") {
return parent::select($select, 'image', $where, COrder::formate($order));
}
$_SESSION['secteur'] = $idsec;
break;
case 66 : // Filtrer cat
if(isset($_GET['idcat'])) $idcat = $_GET['idcat'];
$_SESSION['idcat'] = $idcat;
break;
}
/*------------------------------------------------------
A FAIRE DANS TOUS LES CAS
--------------------------------------------------------*/
if(($idsec!=0) && ($idsec!='')) $filtre = " WHERE cat.secteur_cat =".$idsec;
else if (($idcat!=0) && ($idcat!='')) $filtre = " WHERE mot.cat_motcle =".$idcat;
else $filtre = " WHERE id_motcle like '%%'";
if ($_GET['order']) $parOrder .= " ORDER BY ".COrder::formate($_GET['order']);
else $parOrder .= " ORDER BY ".$order;
//print_r($filtre);
$requetteSql = "SELECT mot.* FROM motcle mot INNER JOIN cat cat ON mot.cat_motcle=cat.id_cat".$filtre."".$parOrder."";
//$r_user = CBdd::select($zSql);
//print_r($requetteSql);
$requetCat = CBdd::select($requetteSql);
?>
<!-- InstanceEndEditable -->
<div id="mainwrap">
<div id="header"><?php include("../nav/header.php"); ?></div>
<div id="top"><?php include("../nav/menu_h.php"); ?></div>
<div id="filet">
<div id="zonetitre">
<div id="signe"></div>
$a = 0;
break;
case 6 : // Filtrer
if(!empty($_GET['idcat'])) $idcat = $_GET['idcat'];
$_SESSION['idcat'] = $idcat;
break;
}
/*------------------------------------------------------
A FAIRE DANS TOUS LES CAS
--------------------------------------------------------*/
$select = "*";
$filtre = "1";
$order = COrder::formate($order) ;
$sql = " SELECT opportunite.*, hbpiecesjointes.piece AS pj, texte.nom AS txt FROM opportunite" ;
$sql .= " LEFT JOIN hbpiecesjointes ON hbpiecesjointes.id = pieId" ;
$sql .= " LEFT JOIN texte ON texte.id = texId" ;
$sql .= ($order) ? " ORDER BY " . $order : '' ;
$r_opportunite = CBdd::select($sql);
?>
<!-- InstanceEndEditable -->
<div id="mainwrap">
<div id="header"><?php include("../nav/header.php"); ?></div>
<div id="top"><?php include("../nav/menu_h.php"); ?></div>
<div id="filet">
<div id="zonetitre">
static function select($select="*", $where="1", $order="rang") {
return parent::select($select, 'article_cat', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="DESC") {
if(empty($order)) $order = "DESC";
return parent::select($select, 'entreprise', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="nomart, rang") {
return parent::select($select, 'page_art', $where, COrder::formate($order));
}
