public function addSectionName($section_name)
{
$section_details = UserProductSection::Select('id', 'user_id')->whereRaw('section_name = ?', array($section_name))->first();
if (count($section_details) > 0) {
if ($section_details->user_id != $this->logged_user_id) {
//throw exception
}
$user_section_id = $section_details->id;
} else {
$data_arr = array('user_id' => $user_id, 'section_name' => $section_name, 'status' => 'Yes', 'date_added' => \DB::raw('NOW()'));
$user_section_id = UserProductSection::insertGetId($data_arr);
}
return $user_section_id;
}
public function getProductUserSections($user_id)
{
$section_list_arr = array();
$q = UserProductSection::where('status', '=', 'Yes')->where('user_id', '=', $user_id)->get();
$i = 0;
foreach ($q as $value) {
$section_list_arr[$i]['id'] = $value->id;
$section_list_arr[$i]['section_name'] = $value->section_name;
$i++;
}
return $section_list_arr;
}
public function addSectionName($input_arr)
{
$user_section_id = '';
$user_id = '';
if (count($input_arr) > 0) {
$data_arr = array('user_id' => $this->logged_user_id, 'section_name' => $input_arr['section_name'], 'status' => 'Yes', 'date_added' => date('Y-m-d H:i:s'));
$user_section_id = UserProductSection::insertGetId($data_arr);
return $user_section_id;
}
return $user_section_id;
}
