public static function add($characteristic) { $char = Characteristic::getByCharacteristic($characteristic); if( !$char ) { $char = new Characteristic(null, $characteristic); return $char->save(); } else { return $char; } }
public function searchPlat($idPlat) { $criteria = new CDbCriteria(); //$criteria->select = "id"; // $criteria->alias = "t"; $criteria->mergeWith(array('join' => 'LEFT JOIN characteristic_platforms as cp ON t.id = cp.id_characteristic', 'condition' => 'cp.id_platform = ' . $idPlat)); Characteristic::model()->findAll($criteria); // $criteria->addCondition(array("condtion"=>"id_app = $id_ap")); $criteria->compare('id', $this->id); $criteria->compare('name', $this->name, true); $criteria->compare('id_criteria', $this->id_criteria); return new CActiveDataProvider($this, array('criteria' => $criteria, 'pagination' => false)); }
public static function getByItem($id) { global $db; //get characteristics linked to item $characteristicsSQL = "SELECT * FROM items_have_characteristics WHERE itemid=?"; $values = array($id); $charList = $db->qwv($characteristicsSQL, $values); //get characteristic info for each characteristic linked to the item $characteristicSQL = "SELECT * FROM characteristics WHERE characteristicid=?"; $characteristics = array(); $db->prep($characteristicSQL); foreach($charList as $charID) { $values = array($charID['characteristicid']); $char = $db->qwv(null, $values); array_push($characteristics, $char[0]); } return Characteristic::wrap($characteristics); }
function replaceName($str, $type) { $itms = array(); foreach( $str as $splt ) { if( $splt != null && $splt != '' ) { array_push($itms, trim($splt)); } } $ints = array(); foreach( $itms as $name ) { switch( $type ) { case 0: $cat = Category::getByName($name); if( $cat instanceof Category ) { array_push($ints, $cat->categoryid); } break; case 1: $ing = Ingredient::getByName($name); if( $ing instanceof Ingredient ) { array_push($ints, $ing->ingredientid); } break; case 2: $char = Characteristic::getByCharacteristic($name); if( $char instanceof Characteristic ) { array_push($ints, $char->characteristicid); } break; default: break; } } return $ints; }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Characteristic the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Characteristic::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
protected function saveChar($model) { if (!($brand = Brand::model()->find('alias=:alias', array(':alias' => $model->brand_alias)))) { $brand = new Brand(); } $brand->title = $model->brand; $brand->alias = $model->brand_alias; $brand->save(); if (!empty($brand->errors)) { d('brand ' . $brand->title); d($brand->errors); } if (!($car = Car::model()->find('alias=:alias', array(':alias' => $model->model_alias)))) { $car = new Car(); } $car->brand_id = $brand->id; $car->title = $model->model; $car->alias = $model->model_alias; $car->manufacture_start = $model->modificationManufactureStart . '0101'; $car->manufacture_end = $model->modificationManufactureEnd ? $model->modificationManufactureEnd . '0101' : null; $car->save(); if (!empty($car->errors)) { d('model ' . $car->title); d($car->errors); } if (!($mod = Modification::model()->find('alias=:alias', array(':alias' => $model->mod_alias)))) { $mod = new Modification(); } $mod->model_id = $car->id; $mod->title = $model->mod; $mod->alias = $model->mod_alias; $mod->manufacture_start = $model->modificationManufactureStart . '0101'; $mod->manufacture_end = $model->modificationManufactureEnd ? $model->modificationManufactureEnd . '0101' : null; $mod->save(); if (!empty($mod->errors)) { d('mod ' . $mod->title); d($mod->errors); } if (!($char = Characteristic::model()->find('modification_id=:mod_id', array(':mod_id' => $mod->id)))) { $char = new Characteristic(); } $char->attributes = $model->char->attributes; $char->modification_id = $mod->id; $char->save(); if (!empty($char->errors)) { d('char ' . $mod->title); d($char->errors); d($model->url); } }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. */ public function loadModel() { if ($this->_model === null) { if (isset($_GET['id'])) { $this->_model = Characteristic::model()->findbyPk($_GET['id']); } if ($this->_model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } } return $this->_model; }
public function __get($var) { if( $var == 'ingredients' ) { return Ingredient::getByItem($this->itemid); } elseif( $var == 'recommendations' ) { return Ingredient::getRecommendedByItem($this->itemid); } elseif( $var == 'characteristics' ) { return Characteristic::getByItem($this->itemid); } elseif( $var == 'category' ) { return Category::getByID($this->categoryid); } elseif( $var == 'price' ) { return money_format('%i', $this->price); } else { return $this->$var; } }
</div> <?php } ?> <?php if ($options['select'] != 'Brand' && $options['select'] != 'Car') { ?> <div id='<?php echo $this->id; ?> _modification' style='display: none;'> <label for='model_id'><?php echo Characteristic::model()->getAttributeLabel('modification_id'); ?> </label><br /> <?php echo CHtml::dropDownList(get_class($model) . '[modification_id]', '', array()); ?> <img src='/images/loader.gif' class='loader' style='display: none;'> </div> <?php } ?> <?php Yii::app()->getClientScript()->registerScript($this->id, "jQuery('#{$this->id}').catalogSelect({\r\n\t\t\t\tid:'{$this->id}', \r\n\t\t\t\tmodel_id:'" . $model->{$name} . "', \r\n\t\t\t\tselect: '" . EString::strtolower($options['select']) . "',\r\n\t\t\t\tmodel:'{$options['select']}',\r\n\t\t\t\tbrandSelect: \$('#" . get_class($model) . "_brand_id'),\r\n\t\t\t\tmodelSelect: \$('#" . get_class($model) . "_model_id'),\r\n\t\t\t\tmodificationSelect: \$('#" . get_class($model) . "_modification_id'),\r\n\t\t\t\turlCatalog: '{$options['urlCatalog']}',\r\n\t\t\t\turlBrand: '{$options['urlBrand']}',\r\n\t\t\t\turlModel: '{$options['urlModel']}',\r\n\t\t\t\tallowEmpty: " . ($options['allowEmpty'] ? 'true' : 'false') . "\r\n\t\t\t});"); ?>
public function actionSelectdos() { //$id_cri = $_POST['TestCase']['id_criteria']; $id_cri = $_POST['TestCase']['id_criteria']; $lista = Characteristic::model()->findAll('id_criteria = :id_cri', array(':id_cri' => $id_cri)); $lista = CHtml::listData($lista, 'id', 'name'); //var_dump($lista); echo CHtml::tag('option', array('value' => ''), 'Select', TRUE); foreach ($lista as $valor => $name) { echo CHtml::tag('option', array('value' => $valor), CHtml::encode($name), true); } }
/** * Lists all models. */ public function actionPlatAutocomplete() { $term = trim($_GET['term']); if ($term != '') { // Note: Users::usersAutoComplete is the function you created in Step 2 $users = Characteristic::platAutoComplete($term); echo CJSON::encode($users); Yii::app()->end(); } }
require_once('Ingredient.php'); $page = new Page(0, "OrderUp - add things"); $tmpl = new Template(); if( !$_SESSION['active'] || $_SESSION['roleid'] > 2 ) { $loc = urlencode("add.php"); header("Location: /login.php?code=10&fwd=$loc"); } $tmpl->type = isset($_GET['type']) ? $_GET['type'] : null; if( $tmpl->type == 'characteristic' ) { $chars = Characteristic::getAll(); if( $chars ) { if( is_object($chars) ) { $tmpl->items = array($chars); } elseif( is_array($chars) ) { $tmpl->items = $chars; } } else { $tmpl->items = array(); }
?> <?php echo $form->errorSummary($model); ?> <div class="well"> <div class="well-cinza"> <b>Add a Characteristic</b> </div> <p class="help-block" >If you want add a new characteristic in this platform, choose the characteristic on the list:</p> <br/> <div style="overflow:scroll; height: 400px"> <?php $type_list = CHtml::listData(Characteristic::model()->findAllbySql('SELECT id, CONCAT(name) as name FROM characteristic WHERE id NOT IN (SELECT id_characteristic FROM characteristic_platforms WHERE id_platform =' . $id_plat . ')'), 'id', 'name'); echo $form->radioButtonList($model, 'id_characteristic', $type_list, array('labelOptions' => array('style' => 'font-size:14px'))); ?> </div> </div>
$name = isset($_POST['name']) ? $_POST['name'] : null; if( !isset($_SESSION['userid']) || $_SESSION['userid'] == null || $_SESSION['userid'] < 1 ) { throw new RedirectBrowserException("../login.php?code=10"); } if( $name != null ) { if( Characteristic::getByCharacteristic($name) ) { print jsonify(false, "This characteristic already exists", $name); } else { if( Characteristic::add($name) ) { print jsonify(true, "The characteristic was added successfully", $name); } else { print jsonify(false, "The characteristic could not be added", $name); } } } else { print jsonify(false, "There was an error adding this characteristic", $name); } function jsonify($stat, $msg, $data = null)
public function afterDelete() { # Проверка и очистка связей $characteristics = Characteristic::model()->findAll('Characteristic=:Characteristic', array(':Characteristic' => $this->id)); if (count($characteristics) > 0) { foreach ($characteristics as $characteristic) { $characteristic->delete(); } } Comment::model()->deleteAll('object_id=:object_id and type=' . L::ritem('CommentType', __CLASS__), array(':object_id' => $this->id)); return parent::afterDelete(); }
$selected_characteristic = array(); //para cada plataforma, insere os id_plataforma escolhidos no array foreach ($model->characteristic as $characteristic) { array_push($selected_characteristic, $characteristic->id); } ?> <div> <?php echo TbHtml::label($model->getAttributeLabel('characteristic'), 'Characteristic'); ?> <p class="help-block">Choose the platform's characteristics:</p> <div class="model-char"> <div class="portlet-content"> <?php echo TbHtml::CheckBoxList('Characteristic', $selected_characteristic, CHtml::listData(Characteristic::model()->findAll(), 'id', 'name'), array('template' => '{input} {label}')); ?> <?php echo $form->error($model, 'characteristic'); ?> </div> </div> </div> </div> <?php $this->endWidget(); ?> </div><!-- form -->
<?php set_include_path('../backbone:../global:../jquery:../components:../content:../images:../model:../render:../scripts:../styles'); require_once('Characteristic.php'); $q = isset($_GET['q']) ? $_GET['q'] : null; $chars = Characteristic::getBySearch($q); header('Content-type: application/json'); if( $chars instanceof Characteristic ) { $json = "[ " . jsonChar($chars) . " ]"; print $json; } elseif( is_array($chars) ) { $json = "[ "; $arr = array(); foreach( $chars as $char ) { array_push($arr, jsonChar($char)); } $json .= implode(',', $arr); $json .= " ]"; print $json; } function jsonChar($char) {