/** * 创建卡牌库 * @author gentle */ public function actionCreate() { $model = new CardDb("Create"); if (isset($_POST['CardDb'])) { $model->attributes = $_POST['CardDb']; if ($model->save()) { $this->addLog('db', $model->id, '添加新库“' . $model->name . '”'); Yii::app()->user->setFlash("success", "新建 <b>{$model->name}</b> 数据库成功!"); } else { $errorMsg = ''; $errorErr = $model->getErrors(); foreach ($errorErr as $value) { $errorMsg .= "\t" . $value[0]; } $errorMsg = trim($errorMsg, ','); Yii::app()->user->setFlash("error", $errorMsg); } //$page = isset($_GET['CardDb_page']) ? $_GET['CardDb_page'] : 1; //$this->redirect(array('CardDb/index/CardDb_page/'.$page)); $this->redirect(array('CardDb/index')); } //if (Yii::app()->request->isAjaxRequest) { // $this->renderPartial('_form_db', array('model' => $model)); //} $this->renderPartial('_form_db', array('model' => $model)); }
/** * 左侧栏树形结构 * @author gentle */ public function dataTree() { $data = array(); $databases = CardDb::model()->findAll(); foreach ($databases as $key => $value) { $data[$key]['text'] = '<span>' . $value->name . '</span>'; $data[$key]['expanded'] = false; $data[$key]['children'] = array(); $datasets = CardDs::model()->findAllByAttributes(array('database_id' => (string) $value->id)); if (empty($datasets)) { continue; } foreach ($datasets as $k => $v) { $data[$key]['children'][$k] = array('text' => '<a href="' . $this->createUrl('/CardDs/Index/id/' . $value->id) . '">' . $v->name . '</a>'); } } return $data; }
/** * 左侧栏树形结构 * @author gentle */ public function dataTree($databaseId = 0, $action = 'cardItem/Index') { $data = array(); $databases = CardDb::model()->findAll(User::model()->getScopeDbCriteria()); foreach ($databases as $key => $value) { $data[$key]['text'] = '<span>' . $value->name . '</span>'; if ($databaseId == $value->id) { $data[$key]['expanded'] = true; } else { $data[$key]['expanded'] = false; } $data[$key]['children'] = array(); $dscriteria = User::model()->getScopeDsCriteria(); $dscriteria->addCond('database_id', '==', (int) $value->id); $datasets = CardDs::model()->findAll($dscriteria); if (empty($datasets)) { continue; } foreach ($datasets as $k => $v) { $data[$key]['children'][$k] = array('text' => '<a href="' . $this->createUrl('/' . $action . '/id/' . $v->id) . '">' . $v->name . '</a>'); } } return $data; }
/** * 根据表名得到真实的表和对应的查询条件 * @param $tname string 待解析表名 * @return 真实表名和条件 */ public function parseRealTable($tname) { $rs = array('name' => $tname, 'criteria' => new EMongoCriteria()); if (preg_match('/^(item_)/i', $tname)) { $tinfo = explode('_', $tname); if (count($tinfo) == 3) { $dbinfo = CardDb::model()->findByAttributes(array('en_name' => $tinfo[1])); if ($dbinfo) { $dsinfo = CardDs::model()->findByAttributes(array('database_id' => $dbinfo->id, 'en_name' => $tinfo[2])); if ($dsinfo) { $rs['name'] = $tinfo[0]; $rs['criteria']->dataset_id = (int) $dsinfo['id']; } } } } return $rs; }
$card_number = $_SESSION['card-number']; if(isset($_POST['points'])) $points_to_add=$_POST['points']; else $points_to_add=$_SESSION['points']; /*skip serve per mostrare tutto nel caso in cui i punti siano positivi*/ $skip=false; if($points_to_add < 0){ $skip=true; ?> <br/> <h2>ERRORE: Non puoi aggiungere punti negativi</h2> <h4>Se si vuole rimuovere dei punti usare lo strumento <a href="#editCard">Modifica Card</a> <?} $sq = new CardDb(); $error=1; //if <0 error is enable if(!$skip){ $error = $sq -> addPoints($card_number, $points_to_add); if($error >= 0){ $result = $sq -> getPoints($card_number)?> <h2>Punti aggiunti con successo. <br/>Situazione aggiornata Card <?php echo $card_number?>:</h2> <table class="rwd-table"> <tr> <th>Numero Card</th> <th>Saldo Punti</th> <th>Buono Utilizzabile</th> <th>Nome</th> <th>Telefono</th>
$card_number = $_SESSION['card-number']; $mail = $_SESSION['mail']; /*skip serve per mostrare tutto nel caso in cui i punti siano positivi*/ $skip = false; if (filter_var($mail, FILTER_VALIDATE_EMAIL) == false) { $skip = true; ?> <br/> <h2>ERRORE: Mail inserita non valida</h2> <h4>Se si vuole inviare una email, settare un email valido: <?php $_SESSION['card-number'] = $card_number; ?> <a href="editCard.php"> Modifica Card</a> <?php } $sq = new CardDb(); $result = $sq->getPoints($card_number); if (!$skip) { ?> <h2>Situazione aggiornata Card <?php echo $card_number; ?> </h2> <table class="rwd-table"> <tr> <th>Numero Card</th> <th>Saldo Punti</th> <th>Buono Utilizzabile</th> <th>Nome</th> <th>Telefono</th> <th>Email</th>
<?php session_start(); require "CardDb.php"; require "menu.html"; $sq = new CardDb(); $cleanAll = "No"; $cleanAll = $_SESSION['delete-all']; if ($cleanAll == "Yes") { $sq->cleanAll(); ?> <h2> Tutto le card sono state rimosse </h2> <?php }
/** * 获取库与实体对应关系表 * @return unknown_type */ public function getDBDSMap() { //添加统一前缀 $cache_key = strtolower('db.admin' . __FUNCTION__); //调用,有缓存则用缓存 if (($map = Yii::app()->cache->get($cache_key)) === false) { $dblist = CardDb::model()->findAll(User::model()->getScopeDbCriteria()); $dslist = CardDs::model()->findAll(User::model()->getScopeDsCriteria()); foreach ($dblist as $dv) { $map[$dv['id']] = array('en_name' => $dv['en_name'], 'name' => $dv['name'], 'list' => array()); } foreach ($dslist as $tv) { if (isset($map[$tv['database_id']])) { $map[$tv['database_id']]['list'][$tv['id']] = array('en_name' => $tv['en_name'], 'name' => $tv['name']); } } if (!Yii::app()->cache->set($cache_key, $map, Yii::app()->params['cache_expire'])) { Yii::log('设置缓存失败:key=' . $cache_key, CLogger::LEVEL_WARNING, 'system.cache'); } } return $map; }
<?php session_start(); require "CardDb.php"; require "menu.html"; $card_number = $_SESSION['card-number']; $new_points = $_POST['points']; $new_user = $_POST['name']; $new_phone = $_POST['phone']; $new_mail = $_POST['mail']; $sq = new CardDb(); $sq->updateAll($card_number, $new_points, $new_user, $new_phone, $new_mail); $values = $sq->getPoints($card_number); ?> <h2>Valori aggiornati correttamente.</h2> <table class="rwd-table"> <tr> <th>Numero Card</th> <th>Saldo Punti</th> <th>Buono Utilizzabile</th> <th>Nome</th> <th>Telefono</th> <th>eMail</th> <th></th> </tr> <?php while ($data = $values->fetchArray()) { ?> <tr><form method="POST" action="saveEdit.php"> <td data-th="Numero Card"><?php echo $data['id'];
<?php session_start(); require "CardDb.php"; require "menu.html"; $sq = new CardDb(); $result = $sq->getAlls(); ?> <h1>Database FidelityCards</h1> <table class="rwd-table"> <tr> <th>Numero Card</th> <th>Saldo Punti</th> <th>Buono Utilizzabile</th> <th>Nome</th> <th>Telefono</th> <th>Email</th> </tr> <?php while ($data = $result->fetchArray()) { ?> <tr> <td data-th="Numero Card"><?php echo $data['id']; ?> </td> <td data-th="Saldo Punti"><?php echo $data['points']; ?>
/** * 获取数据库列表 */ public function actionGetDbs() { $return['code'] = 0; $return['data'] = CardDb::model()->getList(); echo CJSON::encode($return); }
<?php session_start(); require "CardDb.php"; require "menu.html"; $card_number = $_SESSION['card-number']; $sq = new CardDb(); ?> <h2>Lo sconto di <?php echo $_SESSION['money']; $sq->setPoints($card_number, 0); $result = $sq->getPoints($card_number); ?> € è stato usato:</h2> <table class="rwd-table"> <tr> <th>Numero Card</th> <th>Saldo Punti</th> <th>Buono Utilizzabile</th> <th>Nome</th> <th>Telefono</th> <th>Email</th> </tr> <?php while ($data = $result->fetchArray()) { $_SESSION['card-number'] = $data['id']; $_SESSION['phone'] = $data['phone']; $_SESSION['mail'] = $data['mail']; ?> <tr>
<?php session_start(); require "CardDb.php"; require "menu.html"; $card_number = $_POST['card-number']; $_SESSION['card-number'] = $card_number; $sq = new CardDb(); if (is_numeric($card_number)) { if ($sq->addCard($card_number)) { ?> <br/> <h2>Card Inserita con successo. Aggiungi altri dettagli:</h2> <?php /*getPoints returns all fields with id=card_number */ $values = $sq->getPoints($card_number); if ($values == FALSE) { echo "<h2>Card non trovata nel sistema</h2>"; } else { ?> <table class="rwd-table"> <tr> <th>Numero Card</th> <th>Saldo Punti</th> <th>Buono Utilizzabile</th> <th>Nome</th> <th>Telefono</th> <th>eMail</th> <th></th> </tr> <?php while ($data = $values->fetchArray()) {
<?php session_start(); require "CardDb.php"; require "menu.html"; if (isset($_POST['card-number'])) { $card_number = $_POST['card-number']; $_SESSION['card-number'] = $card_number; } else { $card_number = $_SESSION['card-number']; } $sq = new CardDb(); /*getPoints returns all fields with id=card_number */ $values = $sq->getPoints($card_number); if ($values == FALSE) { echo "<h2>Card non trovata nel sistema</h2>"; } else { ?> <table class="rwd-table"> <tr> <th>Numero Card</th> <th>Saldo Punti</th> <th>Buono Utilizzabile</th> <th>Nome</th> <th>Telefono</th> <th>eMail</th> <th></th> </tr> <?php while ($data = $values->fetchArray()) { ?>