/**
* Store a newly created resource in storage.
*
* @param OptionRequest $request
* @return Response
*/
public function store(OptionRequest $request)
{
$input = $request->all();
$option = Option::create($input);
Flash('Option created');
return Redirect()->route('options');
}
public function run()
{
$faker = Faker\factory::create();
DB::table('options')->delete();
foreach (range(1, 5) as $index) {
Option::create(['option' => $faker->word]);
}
}
protected static function saveAllQuestions($questions, $test)
{
foreach ($questions as $question) {
$savedQuestion = Question::create(['test_id' => $test->id, 'title' => $question['title']]);
foreach ($question['options'] as $i => $option) {
Option::create(['question_id' => $savedQuestion->id, 'value' => $option]);
}
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$data = $request->only('name', 'price');
try {
$option = Option::create($data);
return $option;
} catch (Exception $e) {
return $e;
}
}
/**
* Store a newly created resource in storage.
*
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$validation = Validator::make($request->all(), ['label' => 'required', 'name' => 'required|alpha|unique:options', 'value' => 'required', 'type' => 'required|alpha']);
if ($validation->fails()) {
return redirect()->back()->withErrors($validation);
}
Option::create($request->all());
flash()->message('添加成功');
return redirect()->back();
}
public function saveNewTest($test)
{
$newTest = Test::create(['name' => $test['name'], 'preparation' => $test['preparation'], 'time' => $test['time']]);
// Nested loop to add questions > options
foreach ($test['questions'] as $question) {
$savedQuestion = Question::create(['test_id' => $newTest->id, 'title' => $question['title'], 'correct' => $question['correct']]);
foreach ($question['options'] as $i => $option) {
Option::create(['question_id' => $savedQuestion->id, 'value' => $option]);
}
}
}
public function saveFromNested($test)
{
// Clear already existing questions for this particular test.
Question::where('test_id', $test['id'])->delete();
foreach ($test['questions'] as $question) {
$savedQuestion = Question::create(['test_id' => $test['id'], 'title' => $question['title'], 'correct' => $question['correct']]);
// Clear already existing options for this particular question.
Option::where('question_id', $savedQuestion['id'])->delete();
foreach ($question['options'] as $i => $option) {
Option::create(['question_id' => $savedQuestion->id, 'value' => $option]);
}
}
}
public function edit(Request $request, $id)
{
$product = Product::find($id);
/**
* Validate the submitted Data
*/
$this->validate($request, ['name' => 'required', 'manufacturer' => 'required', 'price' => 'required', 'details' => 'required', 'quantity' => 'required', 'categories' => 'required', 'thumbnail' => 'image']);
if ($request->hasFile('album')) {
foreach ($request->album as $photo) {
if ($photo && strpos($photo->getMimeType(), 'image') === false) {
return \Redirect()->back();
}
}
}
/**
* Remove the old categories from the pivot table and maintain the reused ones
*/
$added_categories = [];
foreach ($product->categories as $category) {
if (!in_array($category->id, $request->categories)) {
CategoryProduct::whereProduct_id($product->id)->whereCategory_id($category->id)->delete();
} else {
$added_categories[] = $category->id;
}
}
/**
* Link the new categories to the pivot table
*/
foreach ($request->categories as $category_id) {
if (!in_array($category_id, $added_categories)) {
CategoryProduct::create(['category_id' => $category_id, 'product_id' => $product->id]);
}
}
$info = $request->all();
/**
* Upload a new thumbnail and delete the old one
*/
$dest = "content/images/";
if ($request->file('thumbnail')) {
File::delete(public_path() . $product->thumbnail);
$name = str_random(11) . "_" . $request->file('thumbnail')->getClientOriginalName();
$request->file('thumbnail')->move($dest, $name);
$info['thumbnail'] = "/" . $dest . $name;
}
/**
* Upload Album Photos
*/
if ($request->hasFile('album')) {
foreach ($request->album as $photo) {
if ($photo) {
$name = str_random(11) . "_" . $photo->getClientOriginalName();
$photo->move($dest, $name);
AlbumPhoto::create(['product_id' => $product->id, 'photo_src' => "/" . $dest . $name]);
}
}
}
$product->update($info);
/**
* Linking the options to the product
*/
if ($request->has('options')) {
foreach ($request->options as $option_details) {
if (!empty($option_details['name']) && !empty($option_details['values']['name'][0])) {
if (isset($option_details['id'])) {
$size = count($option_details['values']['id']);
Option::find($option_details['id'])->update(['name' => $option_details['name']]);
foreach ($option_details['values']['name'] as $key => $value) {
if ($key < $size) {
OptionValue::find($option_details['values']['id'][$key])->update(['value' => $value]);
} else {
OptionValue::create(['value' => $value, 'option_id' => $option_details['id']]);
}
}
} else {
$option = Option::create(['name' => $option_details['name'], 'product_id' => $product->id]);
foreach ($option_details['values']['name'] as $value) {
if (!empty($value)) {
OptionValue::create(['value' => $value, 'option_id' => $option->id]);
}
}
}
}
}
}
return \Redirect()->back()->with(['flash_message' => 'Product Successfully Modified']);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Option::create(['module' => 'main', 'option' => 'status', 'value' => 'firstuse']);
Option::create(['module' => 'main', 'option' => 'name', 'value' => 'My Website']);
Option::create(['module' => 'main', 'option' => 'tagline', 'value' => 'New Selforganised Website']);
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//
if (App::environment() === 'production') {
exit('Do not seed in production environment');
}
DB::statement('SET FOREIGN_KEY_CHECKS = 0');
// disable foreign key constraints
DB::table('options')->truncate();
/**
* Options for group: Habit Status
*/
Option::create(['id' => 1, 'name' => 'Yes', 'groupId' => 1, 'order' => 1]);
Option::create(['id' => 2, 'name' => 'No', 'groupId' => 1, 'order' => 2]);
Option::create(['id' => 3, 'name' => 'Ex', 'groupId' => 1, 'order' => 3]);
/**
* Options for group: Food Preferences
*/
Option::create(['id' => 4, 'name' => 'Veg', 'groupId' => 2, 'order' => 1]);
Option::create(['id' => 5, 'name' => 'Non-Veg', 'groupId' => 2, 'order' => 2]);
/**
* Options for group: Non-Veg Foods
*/
Option::create(['id' => 6, 'name' => 'Eggs', 'groupId' => 3, 'order' => 1]);
Option::create(['id' => 7, 'name' => 'Fresh Fish', 'groupId' => 3, 'order' => 2]);
Option::create(['id' => 8, 'name' => 'Dry Fish', 'groupId' => 3, 'order' => 3]);
Option::create(['id' => 9, 'name' => 'Meat', 'groupId' => 3, 'order' => 4]);
Option::create(['id' => 10, 'name' => 'Beef', 'groupId' => 3, 'order' => 5]);
/**
* Options for group: Junk Foods
*/
Option::create(['id' => 9, 'name' => 'Pizzas/ Burgers', 'groupId' => 4, 'order' => 1]);
Option::create(['id' => 10, 'name' => 'Fries/ Bhajjis', 'groupId' => 4, 'order' => 2]);
Option::create(['id' => 11, 'name' => 'Soda/ Cola', 'groupId' => 4, 'order' => 3]);
Option::create(['id' => 12, 'name' => 'Other Junk Food', 'groupId' => 4, 'order' => 4]);
/**
* Options for group: Chronic Diseases
*/
Option::create(['id' => 13, 'name' => 'Diabetes', 'groupId' => 5, 'order' => 1]);
Option::create(['id' => 14, 'name' => 'BP', 'groupId' => 5, 'order' => 2]);
Option::create(['id' => 15, 'name' => 'TB', 'groupId' => 5, 'order' => 3]);
Option::create(['id' => 16, 'name' => 'Heart Diseases', 'groupId' => 5, 'order' => 4]);
Option::create(['id' => 17, 'name' => 'Cancer', 'groupId' => 5, 'order' => 5]);
Option::create(['id' => 18, 'name' => 'Others Diseases', 'groupId' => 5, 'order' => 6]);
/**
* Options for group: Menstural Information
*/
Option::create(['id' => 19, 'name' => 'Cycle Regular', 'groupId' => 6, 'order' => 1]);
Option::create(['id' => 20, 'name' => 'Discharge PV', 'groupId' => 6, 'order' => 2]);
Option::create(['id' => 21, 'name' => 'Post Menopausal Bleeding', 'groupId' => 6, 'order' => 3]);
Option::create(['id' => 22, 'name' => 'Post Coital Bleeding', 'groupId' => 6, 'order' => 4]);
Option::create(['id' => 23, 'name' => 'Inter Menstrual Bleeding', 'groupId' => 6, 'order' => 5]);
/**
* Options for group: Familiy Planning Methods
*/
Option::create(['id' => 24, 'name' => 'Loop', 'groupId' => 7, 'order' => 1]);
Option::create(['id' => 25, 'name' => 'Pills', 'groupId' => 7, 'order' => 2]);
Option::create(['id' => 26, 'name' => 'Tubectomy', 'groupId' => 7, 'order' => 3]);
Option::create(['id' => 27, 'name' => 'Vasectomy', 'groupId' => 7, 'order' => 4]);
Option::create(['id' => 28, 'name' => 'Other methods', 'groupId' => 7, 'order' => 5]);
/**
* Options for group: Clinical Investigations
*/
Option::create(['id' => 29, 'name' => 'ECG', 'groupId' => 8, 'order' => 1]);
Option::create(['id' => 30, 'name' => 'Chest X Ray', 'groupId' => 8, 'order' => 2]);
Option::create(['id' => 31, 'name' => 'BA Swallow', 'groupId' => 8, 'order' => 3]);
Option::create(['id' => 32, 'name' => 'FNAC', 'groupId' => 8, 'order' => 4]);
Option::create(['id' => 33, 'name' => 'Biopsy', 'groupId' => 8, 'order' => 5]);
Option::create(['id' => 34, 'name' => 'PAP Smear', 'groupId' => 8, 'order' => 6]);
Option::create(['id' => 35, 'name' => 'ECTO', 'groupId' => 8, 'order' => 7]);
Option::create(['id' => 36, 'name' => 'ENDO', 'groupId' => 8, 'order' => 8]);
Option::create(['id' => 37, 'name' => 'Post FX', 'groupId' => 8, 'order' => 9]);
/**
* Options for group: Feeding Methods
*/
Option::create(['id' => 38, 'name' => 'Breast Feeding', 'groupId' => 9, 'order' => 1]);
Option::create(['id' => 39, 'name' => 'Bottle Feeding', 'groupId' => 9, 'order' => 2]);
DB::statement('SET FOREIGN_KEY_CHECKS = 1');
// enable foreign key constraints
}
public function run()
{
\App\Option::create(['name' => 'home_page', 'title' => 'Главная страница', 'value' => null, 'other_opts' => '{"type": "select", "model": "\\App\\Page"}']);
}
