/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
//
$product = Product::find($id);
$categories = array('') + Category::all()->lists('name', 'id');
return View::make('products.create', array('product' => $product, 'categories' => $categories));
}
public static function index()
{
return function ($request, $response) {
$models = Category::all();
$response->json($models->as_array());
};
}
public function getEdit($id)
{
// Find the module using the user id
$module = Module::find($id);
// No such id
if ($module == null) {
return \View::make('redminportal::pages/404');
}
$categories = array();
foreach (Category::all() as $category) {
$categories[$category->id] = $category->name;
}
$tagString = "";
foreach ($module->tags as $tag) {
if (!empty($tagString)) {
$tagString .= ",";
}
$tagString .= $tag->name;
}
if (empty($module->options)) {
$module_cn = (object) array('name' => $module->name, 'short_description' => $module->short_description, 'long_description' => $module->long_description);
} else {
$module_cn = json_decode($module->options);
}
$pricelists = array();
foreach (Membership::orderBy('rank')->get() as $membership) {
$pricelist = Pricelist::where('module_id', $module->id)->where('membership_id', $membership->id)->first();
if ($pricelist == null) {
$pricelists[] = array('id' => $membership->id, 'name' => $membership->name, 'price' => '');
} else {
$pricelists[] = array('id' => $membership->id, 'name' => $membership->name, 'price' => $pricelist->price);
}
}
return \View::make('redminportal::modules/edit')->with('module', $module)->with('module_cn', $module_cn)->with('imageUrl', 'assets/img/modules/')->with('categories', $categories)->with('tagString', $tagString)->with('pricelists', $pricelists);
}
public function search()
{
$param['pageNo'] = 1;
$param['store_name'] = Input::has('store') ? Input::get('store') : '';
$param['company_name'] = Input::has('company') ? Input::get('company') : '';
$param['category_id'] = Input::has('category') ? Input::get('category') : '';
$param['city_id'] = Input::has('city') ? Input::get('city') : '';
$param['waiting_time_min'] = Input::has('min') ? Input::get('min') : WAITING_TIME_MIN;
$param['waiting_time_max'] = Input::has('max') ? Input::get('max') : WAITING_TIME_MAX;
$param['is_all'] = Input::has('is_all') ? true : !Input::has('min');
$userId = Session::has('user_id') ? Session::get('user_id') : 0;
$prefix = DB::getTablePrefix();
$result = DB::table('store')->join('company', 'store.company_id', '=', 'company.id')->leftJoin(DB::raw('(SELECT * FROM ' . $prefix . 'queue WHERE user_id = ' . $userId . ' AND DATE(created_at) = DATE(NOW()) GROUP BY store_id) AS ' . $prefix . 'queues'), 'store.id', '=', 'queues.store_id')->join('status', 'store.id', '=', 'status.store_id')->leftJoin(DB::raw('(SELECT count(*) as cnt, store_id FROM ' . $prefix . 'agent WHERE is_active = 1 GROUP BY store_id) AS ' . $prefix . 'agt'), 'agt.store_id', '=', 'store.id')->join('company_setting', 'company_setting.company_id', '=', 'company.id')->join('category', 'category.id', '=', 'company.category_id')->join('city', 'city.id', '=', 'company.city_id')->select('store.id', 'store.name as store_name', 'store.address as address', 'company.name as company_name', 'company_setting.waiting_time', 'status.current_queue_no', 'status.last_queue_no', 'agt.cnt', 'queues.queue_no');
if ($param['store_name'] != '') {
$result = $result->where('store.name', 'like', '%' . $param['store_name'] . '%');
}
if ($param['company_name'] != '') {
$result = $result->where('company.name', 'like', '%' . $param['company_name'] . '%');
}
if ($param['category_id'] != '') {
$result = $result->where('category.id', '=', $param['category_id']);
}
if ($param['city_id'] != '') {
$result = $result->where('city.id', '=', $param['city_id']);
}
if (!$param['is_all']) {
$result = $result->whereRaw($prefix . 'agt.cnt > 0')->whereRaw('((' . $prefix . 'status.last_queue_no - ' . $prefix . 'status.current_queue_no' . ') * ' . $prefix . 'company_setting.waiting_time / 60) / (' . $prefix . 'agt.cnt)' . ' BETWEEN ' . $param['waiting_time_min'] . ' AND ' . $param['waiting_time_max']);
}
$stores = $result->paginate(PAGINATION_SIZE);
$param['stores'] = $stores;
$param['categories'] = CategoryModel::all();
$param['cities'] = CityModel::all();
return View::make('user.store.search')->with($param);
}
public function getEdit($id)
{
// Find the media using the user id
$media = Media::find($id);
// No such id
if ($media == null) {
return \View::make('redminportal::pages/404');
}
$categories = array();
foreach (Category::all() as $category) {
$categories[$category->id] = $category->name;
}
$tagString = "";
foreach ($media->tags as $tag) {
if (!empty($tagString)) {
$tagString .= ",";
}
$tagString .= $tag->name;
}
if (empty($media->options)) {
$media_cn = (object) array('name' => $media->name, 'short_description' => $media->short_description, 'long_description' => $media->long_description);
} else {
$media_cn = json_decode($media->options);
}
return \View::make('redminportal::medias/edit')->with('media', $media)->with('media_cn', $media_cn)->with('imageUrl', 'assets/img/medias/')->with('categories', $categories)->with('tagString', $tagString);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id = NULL)
{
$currUser = Auth::user();
$oCategories = Category::all();
$oCity = Cities::all();
$oVacancy = null;
if ($id > 0) {
$oVacancy = Vacancy::find($id);
}
foreach ($oCategories as $item) {
$aCategories[$item->id] = $item->name;
}
if (Auth::user()->is_admin == 0) {
$aCompanies = Companies::where('user_id', '=', $currUser->id)->get();
} else {
$aCompanies = Companies::all();
}
foreach ($aCompanies as $item) {
$aCompany[$item->id] = $item->name;
}
$oQuery = Regions::join('country', 'country.id', '=', 'country_id')->select('regions.id as id', 'regions.name', 'country.name as country_name', 'country.id as country_id');
if ($oRegions = $oQuery->get()) {
}
foreach ($oRegions as $item) {
$aRegions[$item->country_name] = array();
$aCity = Cities::where('region_id', '=', $item->id)->get();
foreach ($aCity as $city) {
$aRegions[$item->name][$city->id] = $city->name;
}
}
if ($currUser->is_admin == 0 && (empty($oVacancy) === false && $oVacancy->user_id != $currUser->id)) {
return Redirect::route('vacancy-list', array('user_id' => $currUser->id));
}
return View::make('/vacancy/edit', array('currUser' => $currUser, 'aCategories' => $aCategories, 'aCompany' => $aCompany, 'aRegions' => $aRegions, 'oVacancy' => $oVacancy, 'id' => $id));
}
/**
* Display a listing of the resource.
* GET /categories
*
* @return Response
*/
public function index()
{
//
$category = Category::all();
//$category = Category::where('user_id', Auth::user()->id)->get();
return Response::json(array('error' => false, 'categories' => $category->toArray()), 200);
}
public function getIndex()
{
if (Auth::guest() || Auth::user()->isAdmin == 0) {
return Redirect::secure('/');
}
// layouts variables
$this->layout->title = 'Админ панел | Нещо Шантаво';
$this->layout->canonical = 'https://neshto.shantavo.com/admin/';
$this->layout->robots = 'noindex,nofollow,noodp,noydir';
$users = count(User::all());
$admins = count(User::where('isAdmin', ">", 0)->get());
$categories = count(Category::all());
$albums = count(Album::all());
$votes = count(DB::table('votes')->get());
$pictures = count(Picture::all());
$pictureSize = 0;
foreach (Picture::all() as $p) {
$pictureSize += $p->size;
}
// get disqus stats
include app_path() . '/config/_disqus.php';
$disqus = new DisqusAPI(getDisqusKey());
$disqus->setSecure(false);
$comments = $disqus->posts->list(array('forum' => 'shantavo'));
// nesting the view into the layout
$this->layout->nest('content', 'admin.index', array('users' => $users, 'admins' => $admins, 'votes' => $votes, 'categories' => $categories, 'albums' => $albums, 'pictures' => $pictures, 'pictureSize' => $pictureSize, 'comments' => $comments));
}
public function show($id)
{
try {
$iteration = Iterations::findOrFail($id);
$iterations = Iterations::where('projectid', '=', $iteration->projectid)->get();
$project = Project::findOrFail($iteration->projectid);
$issues = Issue::where('iterationid', '=', $id)->get();
//$issues = $iteration->issues;
$countIssues = sizeof($issues);
$categories = Category::all();
$idCategory = 0;
$totalPoints = $issues->sum('points');
$materiales = Material::all();
$personal = PersonalType::all();
$team = Teams::where('projectid', '=', $project->id)->get()->first();
$members = DB::table('memberof')->where('teamid', '=', $team->id)->get();
$hasmembers = sizeof($members) > 0 ? true : false;
$users = array();
foreach ($members as $member) {
$users[] = User::findOrFail($member->usersid);
echo $hasmembers;
}
$this->layout->content = View::make('layouts.iterations.show')->with('iteration', $iteration)->with('iterations', $iterations)->with('issues', $issues)->with('categories', $categories)->with('idCategory', $idCategory)->with('countIssues', $countIssues)->with('totalPoints', $totalPoints)->with('project', $project)->with('materiales', $materiales)->with('personal', $personal)->with('hasmembers', $hasmembers)->with('members', $members)->with('users', $users)->with('message', '');
} catch (Illuminate\Database\Eloquent\ModelNotFoundException $e) {
return Redirect::to('/projects/')->with('message', 'Error al crear la iteración');
}
}
/**
* Upload un torrent
*
* @access public
* @return View torrent.upload
*
*/
public function upload()
{
$user = Auth::user();
// Post et fichier upload
if (Request::isMethod('post')) {
// No torrent file uploaded OR an Error has occurred
if (Input::hasFile('torrent') == false) {
Session::put('message', 'You must provide a torrent for the upload');
return View::make('torrent.upload', array('categories' => Category::all(), 'user' => $user));
} else {
if (Input::file('torrent')->getError() != 0 && Input::file('torrent')->getClientOriginalExtension() != 'torrent') {
Session::put('message', 'An error has occurred');
return View::make('torrent.upload', array('categories' => Category::all(), 'user' => $user));
}
}
// Deplace et decode le torrent temporairement
TorrentTools::moveAndDecode(Input::file('torrent'));
// Array from decoded from torrent
$decodedTorrent = TorrentTools::$decodedTorrent;
// Tmp filename
$fileName = TorrentTools::$fileName;
// Info sur le torrent
$info = Bencode::bdecode_getinfo(getcwd() . '/files/torrents/' . $fileName, true);
// Si l'announce est invalide ou si le tracker et privée
if ($decodedTorrent['announce'] != route('announce', ['passkey' => $user->passkey]) && Config::get('other.freeleech') == true) {
Session::put('message', 'Your announce URL is invalid');
return View::make('torrent.upload', array('categories' => Category::all(), 'user' => $user));
}
// Find the right category
$category = Category::find(Input::get('category_id'));
// Create the torrent (DB)
$torrent = new Torrent(['name' => Input::get('name'), 'slug' => Str::slug(Input::get('name')), 'description' => Input::get('description'), 'info_hash' => $info['info_hash'], 'file_name' => $fileName, 'num_file' => $info['info']['filecount'], 'announce' => $decodedTorrent['announce'], 'size' => $info['info']['size'], 'nfo' => Input::hasFile('nfo') ? TorrentTools::getNfo(Input::file('nfo')) : '', 'category_id' => $category->id, 'user_id' => $user->id]);
// Validation
$v = Validator::make($torrent->toArray(), $torrent->rules);
if ($v->fails()) {
if (file_exists(getcwd() . '/files/torrents/' . $fileName)) {
unlink(getcwd() . '/files/torrents/' . $fileName);
}
Session::put('message', 'An error has occured may bee this file is already online ?');
} else {
// Savegarde le torrent
$torrent->save();
// Compte et sauvegarde le nombre de torrent dans cette catégorie
$category->num_torrent = Torrent::where('category_id', '=', $category->id)->count();
$category->save();
// Sauvegarde les fichiers que contient le torrent
$fileList = TorrentTools::getTorrentFiles($decodedTorrent);
foreach ($fileList as $file) {
$f = new TorrentFile();
$f->name = $file['name'];
$f->size = $file['size'];
$f->torrent_id = $torrent->id;
$f->save();
unset($f);
}
return Redirect::route('torrent', ['slug' => $torrent->slug, 'id' => $torrent->id])->with('message', trans('torrent.your_torrent_is_now_seeding'));
}
}
return View::make('torrent.upload', array('categories' => Category::all(), 'user' => $user));
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$project = Project::find($id);
$categories = Category::all()->lists('name', 'id');
$customers = Customer::all()->lists('name', 'id');
return View::make('admin.projects.edit')->with(['project' => $project, 'categories' => $categories, 'customers' => $customers]);
}
/**
* @before _secure
*/
public function campaign($id)
{
$ad = \Ad::first(['_id' => $id, 'org_id' => $this->org->_id]);
if (!$ad) {
$this->_404();
}
$this->seo(["title" => $ad->title]);
$view = $this->getActionView();
if (RM::post("action")) {
// action value already checked in _postback func
$this->_postback('add', ['ad' => $ad]);
}
if (RM::type() === 'DELETE') {
$this->_postback('delete');
}
$start = RM::get("start", date('Y-m-d', strtotime("-7 day")));
$end = RM::get("end", date('Y-m-d'));
$limit = RM::get("limit", 10);
$page = RM::get("page", 1);
$query = ['adid' => Db::convertType($id), 'created' => Db::dateQuery($start, $end)];
$clicks = \Click::all($query, [], 'created', 'desc', $limit, $page);
$count = \Click::count($query);
$cf = Utils::getConfig("cf", "cloudflare");
$view->set("domain", $cf->api->domain)->set("clicks", $clicks)->set("count", $count)->set('advertiser', $this->user);
$comms = Commission::all(["ad_id = ?" => $id], ['model', 'coverage', 'revenue', 'description']);
$models = ArrayMethods::arrayKeys($comms, 'model');
$advertiser = User::first(["id = ?" => $ad->user_id], ['name']);
$categories = \Category::all(["org_id = ?" => $this->org->_id], ['name', '_id']);
$this->_postback('show', ['ad' => $ad]);
$view->set("ad", $ad)->set("comms", $comms)->set("categories", $categories)->set("advertiser", $advertiser)->set('models', $models)->set("start", $start)->set("end", $end);
}
/**
* Displays the create product form.
*/
public function getNewProduct()
{
// Get all the categories.
$categories = Category::all();
// Render the view.
return View::make('admin.products.new', ['categories' => $categories]);
}
public function editPost($id)
{
$category = Category::all();
$post = Post::find($id);
$cate = explode(',', $post->category);
$publishers = Publisher::orderBy('name', 'ASC')->get();
return View::make('contributor.editPost')->with('title', "Posts Management")->with('page', "posts")->with('category', $category)->with('post', $post)->with('cate', $cate)->with('publishers', $publishers);
}
/**
* Setup the layout used by the controller.
*
* @return void
*/
protected function setupLayout()
{
if (!is_null($this->layout)) {
$categories = Category::all();
$pages = Page::all();
$this->layout = View::make($this->layout)->with('styles', $this->styles)->with('scripts', $this->scripts)->with('content_title', '')->with('categories', $categories)->with('pages', $pages)->with('inline_js', $this->inline_js)->with('sidebar', null);
}
}
public function getIndex()
{
$categories = array();
foreach (Category::all() as $category) {
$categories[$category->id] = $category->name;
}
return View::make('products.index')->with('products', Product::take(6)->paginate(6))->with('categories', $categories);
}
/**
* Список категорий
*/
public function index()
{
if (!User::isAdmin()) {
App::abort('403');
}
$categories = Category::all(['conditions' => ['parent_id = ?', 0], 'order' => 'sort', 'include' => ['children']]);
App::view('categories.index', compact('categories'));
}
public function getIndex()
{
$categories = [];
foreach (Category::all() as $category) {
$categories[$category->id] = $category->name;
}
return View::make('admin.products.index')->with('products', Product::all())->with('categories', $categories);
}
/**
* Get list categories
* @return array()
*/
public function scopeGetAll()
{
$data = array();
$items = Category::all();
foreach ($items as $item) {
$data[$item->id] = $item->name;
}
return $data;
}
/**
* Show the form for creating a new pedido
*
* @return Response
*/
public function create($id = 0)
{
$cliente = Cliente::find($id);
$fornecedores = Fornecedor::all();
$produtos = Produto::all();
$vendedores = Vendedor::all();
$categories = Category::all();
return View::make('pedidos.create', compact('cliente', 'produtos', 'fornecedores', 'vendedores', 'categories'));
}
public function editPost($id)
{
$category = Category::all();
$post = Post::find($id);
$cate = explode(',', $post->category);
$authors = User::where('is_activated', 1)->get();
$publishers = Publisher::orderBy('name', 'ASC')->get();
return View::make('moderate.editPost')->with('title', "Posts Management")->with('page', "posts")->with('category', $category)->with('post', $post)->with('cate', $cate)->with('authors', $authors)->with('publishers', $publishers);
}
public static function categoryArray()
{
$category = Category::all()->toArray();
$array = [0 => ['id' => 0, 'name' => '- Danh mục', 'created_at' => '2016-03-24 16:08:58', 'updated_at' => '2016-03-24 16:08:58']];
foreach ($category as $key => $value) {
$array[$key + 1] = $value;
}
return $array;
}
/**
* Setup the layout used by the controller.
*
* @return void
*/
protected function setupLayout()
{
$cats = Category::all();
if (!is_null($this->layout)) {
View::share('cats', $cats);
$this->layout = View::make($this->layout);
//->nest('category', 'partials.category', array($cats));
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$product = Product::find($id);
$departments = Department::all()->lists('name', 'id');
$categories = Category::all()->lists('name', 'id');
$brands = Brand::all()->lists('name', 'id');
$sizes = Size::all()->lists('name', 'id');
$colors = Color::all()->lists('name', 'id');
return View::make('admin::products.edit', compact('product', 'departments', 'categories', 'brands', 'sizes', 'colors'));
}
public static function loadCategories()
{
$categories = new \Illuminate\Database\Eloquent\Collection();
try {
$categories = Category::all();
} catch (Exception $e) {
//Discard query exception.. categories table not found.. discard
}
View::share('categories', $categories);
}
public function catalogue()
{
$ids = DB::table('tblCatalogue')->select('strCatalogueID')->orderBy('created_at', 'desc')->orderBy('strCatalogueID', 'desc')->take(1)->get();
$ID = $ids["0"]->strCatalogueID;
$newID = $this->smartCounter($ID);
$category = Category::all();
$reason = ReasonCatalogue::all();
$catalogue = DB::table('tblCatalogue')->join('tblGarmentCategory', 'tblCatalogue.strCatalogueCategory', '=', 'tblGarmentCategory.strGarmentCategoryID')->leftJoin('tblReasonCatalogue', 'tblCatalogue.strCatalogueID', '=', 'tblReasonCatalogue.strInactiveCatalogueID')->select('tblCatalogue.*', 'tblGarmentCategory.strGarmentCategoryName', 'tblReasonCatalogue.strInactiveCatalogueID', 'tblReasonCatalogue.strInactiveReason')->orderBy('created_at')->get();
return View::make('catalogue')->with('newID', $newID)->with('catalogue', $catalogue)->with('reason', $reason)->with('category', $category);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$categories = \Category::all();
echo '<pre>';
foreach ($categories as $category) {
print_r($category->term->slug);
}
echo '</pre>';
// return view('post.list-category');
}
/**
* Display a listing of categories
*
* @return Response
*/
public function index()
{
if (Request::ajax()) {
$categories = Category::all();
return Response::json($categories);
} else {
$categories = Category::all();
return View::make('categories.index', compact('categories'));
}
}
public function dashboard()
{
$settings = Setting::first();
$media = Media::all();
$users = User::all();
$comments = Comment::all();
$categories = Category::all();
$data = array('settings' => $settings, 'media' => $media, 'users' => $users, 'comments' => $comments, 'categories' => $categories);
return View::make('admin.sections.dashboard', $data);
}
public function segment()
{
$ids = DB::table('tblGarmentSegment')->select('strGarmentSegmentID')->orderBy('created_at', 'desc')->orderBy('strGarmentSegmentID', 'desc')->take(1)->get();
$ID = $ids["0"]->strGarmentSegmentID;
$newID = $this->smartCounter($ID);
$category = Category::all();
$reason = ReasonSegment::all();
$segment = DB::table('tblGarmentSegment')->join('tblGarmentCategory', 'tblGarmentSegment.strCategory', '=', 'tblGarmentCategory.strGarmentCategoryID')->leftJoin('tblReasonSegment', 'tblGarmentSegment.strGarmentSegmentID', '=', 'tblReasonSegment.strInactiveSegmentID')->select('tblGarmentSegment.*', 'tblGarmentCategory.strGarmentCategoryName', 'tblReasonSegment.strInactiveSegmentID', 'tblReasonSegment.strInactiveReason')->get();
return View::make('garmentsDetails')->with('segment', $segment)->with('category', $category)->with('reason', $reason)->with('newID', $newID);
}
