// echo "<hr>$ClassName Data: ".count($aData)." - Exists: ".count($aExists)." - New: ".count($aNew)." - Detail: ".implode(",",$aNew); } /** * @Author: ANH DUNG Mar 04, 2015 * @Todo: insert new record to db * @Param: $ClassName name of model * @Param: $field_name field in db * @Param: $aNew array data to insert new */ public function InsertNewRecord($ClassName, $FieldName, $aNew) { $model_ = call_user_func(array($ClassName, 'model')); $tableName = $model_->tableName(); Yii::app()->db->createCommand("truncate table {$tableName}")->query(); // sleep(1); $aRowInsert = array(); foreach ($aNew as $key => $item) { $aRowInsert[] = "( '{$item}' )"; } $sql = "insert into {$tableName} (\r\r {$FieldName}\r\r ) values " . implode(',', $aRowInsert); if (count($aRowInsert) > 0) { // echo "<br> SQL: $sql <br>"; Yii::app()->db->createCommand($sql)->execute(); } } /**
</span> </div> <?php } ?> </div> <div class="service-tab"> <div class="container"><div class="table-responsive"><!-- content added by js --></div></div> </div> </div> <div class="visible-xs-block" style="margin-top: 20px"> <div class="collapse in navbar-collapse" id="bs-example-navbar-collapse-2"> <ul class="nav navbar-nav service-nav"> <?php foreach (OurService::getMainCategories() as $category) { ?> <li class="dropdown"> <span><?php echo $category->name; ?> </span> <i class="fa fa-angle-right dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false" > </i> <ul class="dropdown-menu"> <?php
public function run() { $categories = OurService::getMainCategories(); $this->render('our-service-link-widget', array('categories' => $categories)); }