// 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));
}
