public function getListProductById($table, $idcate)
{
$Products = DB::table($table)->where("cate", "=", $idcate)->orderby('sort', 'asc')->get();
if ($Products) {
return $Products;
}
return false;
}
/**
* Register the Capsule service.
* Ref: http://stackoverflow.com/questions/17105829/using-eloquent-orm-from-laravel-4-outside-of-laravel
*
* @param $app
**/
public function register(Application $app)
{
$app['capsule.connection_defaults'] = array('driver' => 'mysql', 'host' => 'localhost', 'database' => null, 'username' => 'root', 'password' => null, 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci', 'prefix' => null, 'logging' => false);
$app['capsule.container'] = $app->share(function () {
return new Container();
});
$app['capsule.dispatcher'] = $app->share(function () use($app) {
return new Dispatcher($app['capsule.container']);
});
if (class_exists('Illuminate\\Cache\\CacheManager')) {
$app['capsule.cache_manager'] = $app->share(function () use($app) {
return new CacheManager($app['capsule.container']);
});
}
$app['capsule'] = $app->share(function ($app) {
$capsule = new DB($app['capsule.container']);
$capsule->setEventDispatcher($app['capsule.dispatcher']);
if (isset($app['capsule.cache_manager']) && isset($app['capsule.cache'])) {
$capsule->setCacheManager($app['capsule.cache_manager']);
foreach ($app['capsule.cache'] as $key => $value) {
$app['capsule.container']->offsetGet('config')->offsetSet('cache.' . $key, $value);
}
}
if (!isset($app['capsule.connections'])) {
$app['capsule.connections'] = array('default' => isset($app['capsule.connection']) ? $app['capsule.connection'] : array());
}
foreach ($app['capsule.connections'] as $connection => $options) {
$options = array_replace($app['capsule.connection_defaults'], $options);
$logging = $options['logging'];
unset($options['logging']);
$capsule->addConnection($options, $connection);
if ($logging) {
$capsule->getConnection($connection)->enableQueryLog();
} else {
$capsule->getConnection($connection)->disableQueryLog();
}
}
return $capsule;
});
}
public function get_comments($id)
{
return DB::table('comments')->where('on_post', $id)->orderBy('id', 'desc')->get();
}
public static function moveNode($parent_id, $child_id, $position)
{
$sth = new static();
$new_parent = static::findOrFail($parent_id);
$old_child[self::$atb[0]] = $child_id;
$old_child = static::where(self::$atb[0], $old_child[self::$atb[0]])->first();
$space = $old_child[self::$atb[3]] - $old_child[self::$atb[2]] + 1;
// Xác định left, right mới
for ($i = $new_parent[self::$atb[2]] + 1;;) {
if ($position == 1) {
$new_child[self::$atb[2]] = $i;
$new_child[self::$atb[3]] = $i + $space - 1;
break;
} else {
$cur_child = static::where(self::$atb[2], $i)->first();
$i = $cur_child[self::$atb[3]] + 1;
if ($old_child[self::$atb[2]] != $cur_child[self::$atb[2]]) {
$position--;
}
}
}
//Update relevant nodes
if ($new_child[self::$atb[2]] > $old_child[self::$atb[2]]) {
$new_child[self::$atb[2]] -= $space;
$new_child[self::$atb[3]] -= $space;
$child_road = $new_child[self::$atb[2]] - $old_child[self::$atb[2]];
$space = -$space;
$dau1 = '>';
$dau2 = '<=';
$lr1 = self::$atb[2];
$lr2 = self::$atb[3];
} else {
$child_road = $new_child[self::$atb[2]] - $old_child[self::$atb[2]];
$dau1 = '<';
$dau2 = '>=';
$lr1 = self::$atb[3];
$lr2 = self::$atb[2];
}
$little_child = DB::table(self::$tbl)->where(self::$atb[2], '>', $old_child[self::$atb[2]])->where(self::$atb[3], '<', $old_child[self::$atb[3]])->lists(self::$atb[0]);
DB::table(self::$tbl)->whereIn(self::$atb[0], $little_child)->increment(self::$atb[2], $child_road);
DB::table(self::$tbl)->whereIn(self::$atb[0], $little_child)->increment(self::$atb[3], $child_road);
$need_update = DB::table(self::$tbl)->where($lr1, $dau1, $old_child[$lr1])->where($lr2, $dau2, $new_child[$lr2])->whereNotIn(self::$atb[0], $little_child)->lists(self::$atb[0]);
DB::table(self::$tbl)->whereIn(self::$atb[0], $need_update)->increment(self::$atb[2], $space);
DB::table(self::$tbl)->whereIn(self::$atb[0], $need_update)->increment(self::$atb[3], $space);
DB::table(self::$tbl)->where($lr1, $dau2, $new_child[$lr2])->where($lr1, $dau1, $old_child[$lr1])->where($lr2, $dau1, $new_child[$lr2])->whereNotIn(self::$atb[0], $little_child)->whereNotIn(self::$atb[0], $need_update)->increment($lr1, $space);
DB::table(self::$tbl)->where($lr2, $dau1, $old_child[$lr1])->where($lr2, $dau2, $new_child[$lr2])->where($lr1, $dau2, $old_child[$lr1])->whereNotIn(self::$atb[0], $little_child)->whereNotIn(self::$atb[0], $need_update)->increment($lr2, $space);
static::where(self::$atb[0], $old_child[self::$atb[0]])->update($new_child);
}
function getCategory()
{
return DB::table('product_type')->get();
}
