public function postConn(Request $request)
{
$id = $request->input('module_id');
$field_id = $request->input('field_id');
$alias = $request->input('alias');
$row = \DB::table('tb_module')->where('module_id', $id)->get();
if (count($row) <= 0) {
return Redirect::to($this->module)->with('messagetext', 'Can not find module')->with('msgstatus', 'error');
}
$row = $row[0];
$this->data['row'] = $row;
$fr = array();
$config = \SiteHelpers::CF_decode_json($row->module_config);
foreach ($config['grid'] as $form) {
if ($form['field'] == $field_id && $form['alias'] == $alias) {
if ($request->input('db') != '') {
$value = implode("|", $request->input('display'));
$form['conn'] = array('valid' => '1', 'db' => $request->input('db'), 'key' => $request->input('key'), 'display' => implode("|", array_filter($request->input('display'))));
} else {
$form['conn'] = array('valid' => '0', 'db' => '', 'key' => '', 'display' => '');
}
$fr[] = $form;
} else {
$fr[] = $form;
}
}
unset($config["grid"]);
$new_config = array_merge($config, array("grid" => $fr));
$affected = \DB::table('tb_module')->where('module_id', '=', $id)->update(array('module_config' => \SiteHelpers::CF_encode_json($new_config)));
return Redirect::to('sximo/module/table/' . $row->module_name)->with('messagetext', 'Module Forms Has Changed Successful.')->with('msgstatus', 'success');
}
function getRemovesub()
{
$id = Input::get('id');
$module = Input::get('mod');
$row = DB::table('tb_module')->where('module_id', $id)->get();
if (count($row) <= 0) {
return Redirect::to($this->module)->with('messagetext', 'Can not find module')->with('msgstatus', 'error');
}
$row = $row[0];
$this->data['row'] = $row;
$config = SiteHelpers::CF_decode_json($row->module_config);
$subgrid = array();
foreach ($config['subgrid'] as $sb) {
if ($sb['module'] != $module) {
$subgrid[] = $sb;
}
}
unset($config["subgrid"]);
$new_config = array_merge($config, array("subgrid" => $subgrid));
//echo '<pre>'; print_r($new_config); echo '</pre>'; exit;
$affected = DB::table('tb_module')->where('module_id', '=', $id)->update(array('module_config' => SiteHelpers::CF_encode_json($new_config)));
return Redirect::to($this->module . '/sub/' . $row->module_name)->with('messagetext', 'Master Has removed Successful.')->with('msgstatus', 'success');
}
</div>
<div class="right-column-sub">
<div class="banner">
<img src="{{ URL::asset('images/duh-add.jpg') }}" alt="">
<!--banner --></div>
<div class="featured-head">
<h2>FEATURED</h2>
@if(count($featured))
@foreach($featured as $fkey)
<?php
/*params*/
$fp[0] = $fkey->fk_category_id;
$fp[1] = $fkey->fk_sub_category_id;
$fp[2] = $fkey->pk_poll_id;
$fpArr = SiteHelpers::CF_encode_json($fp);
?>
<div class="tab-sub-section">
<div class="soon-image">
<img src="{{ URL::asset('uploads/polls/thumb/'.$fkey->thumbnail) }}" alt="">
</div>
<div class="soon-des">
<a href = "{{URL::to('poll/'.$fpArr)}}" class = "single-poll">{{$fkey->title}}</a>
</div>
</div>
@endforeach
@else
{{"No Featured Polls"}}
@endif
<!--featured-head --></div>
function saveConn()
{
$id = $this->input->post('module_id');
$field_id = $this->input->post('field_id', true);
$alias = $this->input->post('alias', true);
$row = $this->db->get_where('tb_module', array('module_id' => $id))->row();
if (count($row) <= 0) {
redirect('sximo/module', 301);
}
$this->data['row'] = $row;
$fr = array();
$config = SiteHelpers::CF_decode_json($row->module_config);
foreach ($config['grid'] as $form) {
if ($form['field'] == $field_id && $form['alias'] == $alias) {
if ($this->input->post('db') != '') {
$value = implode("|", $this->input->post('display', true));
$form['conn'] = array('valid' => '1', 'db' => $this->input->post('db', true), 'key' => $this->input->post('key', true), 'display' => implode("|", array_filter($this->input->post('display', true))));
} else {
$form['conn'] = array('valid' => '0', 'db' => '', 'key' => '', 'display' => '');
}
$fr[] = $form;
} else {
$fr[] = $form;
}
}
unset($config["grid"]);
$new_config = array_merge($config, array("grid" => $fr));
// echo '<pre>'; print_r($new_config); echo '</pre>'; exit;
$this->db->where('module_id', $id);
$this->db->update('tb_module', array('module_config' => SiteHelpers::CF_encode_json($new_config)));
$this->session->set_flashdata('message', SiteHelpers::alert('success', 'Module Table Connection Has Been Save Successfull'));
redirect('sximo/module/table/' . $row->module_name, 301);
}
<li>contest based</li>
<li>votes: 14,57,000</li>
</ul>
</div>
</div>
<!--soon-section --></div>
@endforeach
<!--featured-polls --></div>
@endif
@if(isset($closed) && !empty($closed))
<?php
$closedArr = array();
$closedArr[0] = $categoryId;
$closedArr[1] = $subCatId;
$closedArr[2] = 'closed';
$cArr = SiteHelpers::CF_encode_json($closedArr);
?>
<div class="closed-polls">
<h2><span>CLOSED POLLS</span> <div class="view-more"><a href="{{URL::to('/viewall/'.$cArr)}}">view more</a></div></h2>
<ul>
@foreach($closed as $c)
<li>{{$c->title}}(<span>contest based votes 14,57,000</span>)</li>
@endforeach
</ul>
<!--closed-polls --></div>
@endif
<!--middle-column --></div>
<div class="right-column">
<?php
$categories = SiteHelpers::mainCategory('category');
$currentRoute = Route::current();
$parameters = $currentRoute->parameters();
$linkSelect = SiteHelpers::CF_encode_json($parameters);
if ($parameters) {
$cat = SiteHelpers::CF_decode_json($parameters['one']);
if (is_array($cat)) {
$categoryId = $cat[1];
} else {
$categoryId = $cat;
}
} else {
$categoryId = 'all';
}
/*if($params)
{
}*/
$subCategories = SiteHelpers::mainCategory($categoryId);
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width; initial-scale=1.0" />
<title>:: The Indian Edition ::</title>
<link type="text/css" rel="stylesheet" href="{{ URL::asset('css/layout.css') }}">
<link type="text/css" rel="stylesheet" href="{{ URL::asset('css/iPad.css') }}">
<link type="text/css" rel="stylesheet" href="{{ URL::asset('css/mobile-small.css') }}">
function postCreate()
{
$rules = array('module_name' => 'required|alpha|min:2|unique:tb_module', 'module_title' => 'required', 'module_note' => 'required', 'module_db' => 'required');
$validator = Validator::make(Input::all(), $rules);
if ($validator->passes()) {
$table = Input::get('module_db');
$primary = self::findPrimarykey(Input::get('module_db'));
$select = Input::get('sql_select');
$where = Input::get('sql_where');
$group = Input::get('sql_group');
if (Input::get('creation') == 'manual') {
if ($where == "") {
return Redirect::to($this->module . '/add')->withErrors($validator)->withInput()->with('message', SiteHelpers::alert('error', "SQL WHERE REQUIRED"));
}
try {
DB::select($select . ' ' . $where . ' ' . $group);
} catch (\Exception $e) {
// Do something when query fails.
$error = 'Error : ' . $select . ' ' . $where . ' ' . $group;
return Redirect::to($this->module . '/add')->withErrors($validator)->withInput()->with('message', SiteHelpers::alert('error', $error));
}
$columns = array();
$results = $this->model->getColoumnInfo($select . ' ' . $where . ' ' . $group);
//echo '<pre>'; print_r($results); echo '</pre>'; exit;
$primary_exits = '';
foreach ($results as $r) {
$Key = isset($r['flags'][1]) && $r['flags'][1] == 'primary_key' ? 'PRI' : '';
if ($Key != '') {
$primary_exits = $r['name'];
}
$columns[] = (object) array('Field' => $r['name'], 'Table' => $r['table'], 'Type' => $r['native_type'], 'Key' => $Key);
}
$primary = $primary_exits != '' ? $primary_exits : '';
} else {
$columns = DB::select("SHOW COLUMNS FROM " . Input::get('module_db'));
$select = " SELECT {$table}.* FROM {$table} ";
$where = " WHERE " . $table . "." . $primary . " IS NOT NULL";
if ($primary != '') {
$where = " WHERE " . $table . "." . $primary . " IS NOT NULL";
} else {
$where = '';
}
}
// echo '<pre>'; print_r($columns); echo '</pre>'; exit;
$i = 0;
$rowGrid = array();
$rowForm = array();
foreach ($columns as $column) {
if (!isset($column->Table)) {
$column->Table = $table;
}
if ($column->Key == 'PRI') {
$column->Type = 'hidden';
}
if ($column->Table == $table) {
$form_creator = self::configForm($column->Field, $column->Table, $column->Type, $i);
$relation = self::buildRelation($table, $column->Field);
foreach ($relation as $row) {
$array = array('external', $row['table'], $row['column']);
$form_creator = self::configForm($column->Field, $table, 'select', $i, $array);
}
$rowForm[] = $form_creator;
}
$rowGrid[] = self::configGrid($column->Field, $column->Table, $column->Type, $i);
$i++;
}
$setting = array('gridtype' => Input::get('module_template'), 'orderby' => $primary, 'ordertype' => 'asc', 'perpage' => '10', 'frozen' => 'false');
// echo '<pre>'; print_r($rowGrid); echo '</pre>'; exit;
$json_data['sql_select'] = $select;
$json_data['sql_where'] = $where;
$json_data['sql_group'] = $group;
$json_data['table_db'] = $table;
$json_data['primary_key'] = $primary;
$json_data['grid'] = $rowGrid;
$json_data['forms'] = $rowForm;
$json_data['setting'] = $setting;
//echo '<pre>'; print_r($json_data); echo '</pre>'; exit;
$data = array('module_name' => Input::get('module_name'), 'module_title' => Input::get('module_title'), 'module_note' => Input::get('module_note'), 'module_db' => Input::get('module_db'), 'module_db_key' => $primary, 'module_type' => 'addon', 'module_created' => date("Y-m-d H:i:s"), 'module_config' => SiteHelpers::CF_encode_json($json_data));
DB::table('tb_module')->insert($data);
// Add Default permission
$tasks = array('is_global' => 'Global', 'is_view' => 'View ', 'is_detail' => 'Detail', 'is_add' => 'Add ', 'is_edit' => 'Edit ', 'is_remove' => 'Remove ', 'is_excel' => 'Excel ');
$groups = DB::table('tb_groups')->get();
$row = DB::table('tb_module')->where('module_name', Input::get('module_name'))->get();
if (count($row) >= 1) {
$id = $row[0];
foreach ($groups as $g) {
$arr = array();
foreach ($tasks as $t => $v) {
if ($g->group_id == '1') {
$arr[$t] = '1';
} else {
$arr[$t] = '0';
}
}
$data = array("access_data" => json_encode($arr), "module_id" => $id->module_id, "group_id" => $g->group_id);
DB::table('tb_groups_access')->insert($data);
}
return Redirect::to($this->module . '/rebuild/' . $id->module_id);
} else {
return Redirect::to($this->module);
}
} else {
return Redirect::to($this->module . '/add')->with('message', SiteHelpers::alert('error', 'The following errors occurred'))->withErrors($validator)->withInput();
}
return Redirect::to($this->module)->with('message', SiteHelpers::alert('error', ' Create module disabled on demo page '));
}
function postSaveform()
{
$id = Input::get('module_id');
$row = DB::table('tb_module')->where('module_id', $id)->get();
if (count($row) <= 0) {
return Redirect::to($this->module)->with('message', SiteHelpers::alert('error', 'Can not find module'));
}
$row = $row[0];
$this->data['row'] = $row;
$config = SiteHelpers::CF_decode_json($row->module_config);
$this->data['tables'] = $config['grid'];
$total = count($_POST['field']);
extract($_POST);
$f = array();
for ($i = 1; $i <= $total; $i++) {
$language = array();
$f[] = array("field" => $field[$i], "alias" => $alias[$i], "language" => $language, "label" => $label[$i], 'form_group' => $form_group[$i], 'required' => isset($required[$i]) ? $required[$i] : 0, 'view' => isset($view[$i]) ? 1 : 0, 'type' => $type[$i], 'add' => 1, 'size' => '0', 'edit' => 1, 'search' => isset($search[$i]) ? $search[$i] : 0, "sortlist" => $sortlist[$i], 'option' => array("opt_type" => $opt_type[$i], "lookup_query" => $lookup_query[$i], "lookup_table" => $lookup_table[$i], "lookup_key" => $lookup_key[$i], "lookup_value" => $lookup_value[$i], 'is_dependency' => $is_dependency[$i], 'is_multiple' => isset($is_multiple[$i]) ? $is_multiple[$i] : 0, 'lookup_dependency_key' => $lookup_dependency_key[$i], 'path_to_upload' => $path_to_upload[$i], 'resize_width' => $resize_width[$i], 'resize_height' => $resize_height[$i], 'upload_type' => $upload_type[$i], 'tooltip' => $tooltip[$i], 'attribute' => $attribute[$i], 'extend_class' => $extend_class[$i]));
}
unset($config["forms"]);
$new_config = array_merge($config, array("forms" => $f));
$data['module_config'] = SiteHelpers::CF_encode_json($new_config);
//echo '<pre>'; print_r($new_config); echo '</pre>'; exit;
/*
$affected = DB::table('tb_module')
->where('module_id', '=',$id )
->update(array('module_config' => SiteHelpers::CF_encode_json($new_config)));
*/
return Redirect::to($this->module . '/form/' . $row->module_name)->with('message', SiteHelpers::alert('success', 'Module Forms Has Changed Successful.'));
}
