PHP Sections::save方法代码示例

 public function postCreate()
 {
     $all = Sections::all();
     $section = new Sections();
     $section->title = Input::get('title');
     $section->description = Input::get('description');
     $section->type = 'section';
     $section->status = 'draft';
     $section->order = count($all) + 1;
     $section->file = Input::get('file') == 'true' ? true : false;
     if ($section->save()) {
         return Redirect::to($this->route)->with('msg_success', Lang::get('messages.sections_create', array('title' => $section->title, 'description' => $section->description, 'file' => $section->file)));
     } else {
         return Redirect::to($this->route)->with('msg_error', Lang::get('messages.sections_create_err', array('title' => $section->title, 'description' => $section->description, 'file' => $section->file)));
     }
 }

    $path = public_path() . '\\' . 'sections\\' . Input::get('shortname');
    $section = ['name_of_section' => Input::get('name_of_section'), 'sub_section' => Input::get('sub_section'), 'shortname' => Input::get('shortname'), 'section_url' => $path];
    $sections = ['name_of_section' => Input::get('name_of_section'), 'sub_section' => Input::get('sub_section'), 'shortname' => Input::get('shortname')];
    $rule = array('name_of_section' => 'required', 'shortname' => 'required');
    $validator = Validator::make($sections, $rule);
    if ($validator->fails()) {
        return Redirect::to('/section')->withErrors($validator->messages());
    } else {
        if (Input::get('sub_section') != "CWC References" && Input::get('sub_section') != "CWC Calculators") {
            //echo "Not ready";
            File::makeDirectory($path, $mode = 0777, true, true);
        } else {
            //echo "ready";
        }
        $sectionData = new Sections($section);
        $sectionData->save();
        return Redirect::to('/section')->withMessage('Section created');
    }
});
Route::post('editSectionValue', function () {
    $sections = Sections::where('id', '=', Input::get('id'))->first();
    $pages = Pages::where('page_section', '=', $sections->name_of_section)->get();
    $array = (array) $pages;
    $path = public_path() . '\\' . 'sections\\' . Input::get('shortname');
    $Uploadpath = public_path() . '\\' . 'uploads\\' . $sections->shortname;
    $section = ['name_of_section' => Input::get('name_of_section'), 'sub_section' => Input::get('sub_section'), 'shortname' => Input::get('shortname'), 'section_url' => $path];
    $sectionValues = ['name_of_section' => Input::get('name_of_section'), 'sub_section' => Input::get('sub_section'), 'shortname' => Input::get('shortname')];
    $rule = array('name_of_section' => 'required', 'shortname' => 'required');
    $validator = Validator::make($sectionValues, $rule);
    if ($validator->fails()) {
        return Redirect::to('/editSection?id=' . $sections->id)->withErrors($validator->messages());

    /**
     * Create project shelve and cabinet
     * @param $projectId
     * @param $year
     */
    public static function createProjectStorages($projectId, $year)
    {
        $project = Projects::model()->findByPk($projectId);

        // check existing project cabinet
        $cabinet = Storages::model()->findByAttributes(array(
            'Storage_Type' => self::CABINET,
            'Created_By' => '0',
            'Project_ID' => $projectId,
            'Year' => $year,
        ));
        if (!$cabinet) {
            // if there is not cabinet for this project create it
            $cabinet = new Storages();
            $cabinet->Storage_Name = $project->Project_Name;
            $cabinet->Project_ID = $projectId;
            $cabinet->Client_ID = Yii::app()->user->clientID;
            $cabinet->Year = $year;
            $cabinet->Created_By = 0;
            $cabinet->Row_Num = 0;
            $cabinet->Storage_Type = self::CABINET;
            $cabinet->Access_Type = self::HAS_ACCESS;
            if ($cabinet->validate()) {
                $cabinet->save();
            }
        }

        // check existing project shelf
        $shelf = Storages::model()->findByAttributes(array(
            'Storage_Type' => self::SHELF,
            'Created_By' => '0',
            'Project_ID' => $projectId,
            'Year' => $year,
        ));
        if (!$shelf) {
            // if there is not cabinet for this project create it
            $shelf = new Storages();
            $shelf->Storage_Name = $project->Project_Name;
            $shelf->Project_ID = $projectId;
            $shelf->Client_ID = Yii::app()->user->clientID;
            $shelf->Year = $year;
            $shelf->Created_By = 0;
            $shelf->Row_Num = 0;
            $shelf->Storage_Type = self::SHELF;
            $shelf->Access_Type = self::HAS_ACCESS;
            if ($shelf->validate()) {
                $shelf->save();
            }
        }

        $countW9s = W9::getCountOfAvailableW9sOfYear($year);
        if ($countW9s > 0) {
            // also crete W9 book if it does not exist and there are Company's W9s
            $w9Binder = Sections::model()->findByAttributes(array(
                'Section_Type' => self::SHELF,
                'Created_By' => '0',
                'Storage_ID' => $shelf->Storage_ID,
                'Folder_Cat_ID' => Sections::W9_BOOK,
            ));

            if (!$w9Binder) {
                $w9Binder = new Sections();
                $w9Binder->Storage_ID = $shelf->Storage_ID;
                $w9Binder->Section_Name = "W9s";
                $w9Binder->Vendor_ID = 0;
                $w9Binder->Created_By = 0;
                $w9Binder->Section_Type = self::SHELF;
                $w9Binder->Folder_Cat_ID = Sections::W9_BOOK;
                $w9Binder->Access_Type = self::HAS_ACCESS;
                if ($w9Binder->validate()) {
                    $w9Binder->save();

                    $tab = new Subsections();
                    $tab->Section_ID = $w9Binder->Section_ID;
                    $tab->Subsection_Name = 'Tab 1';
                    $tab->Subsection_Type = self::SHELF;
                    $tab->Created_By = 0;
                    $tab->Access_Type = self::HAS_ACCESS;
                    $tab->save();
                }
            }
        }
    }

 public function postAddSections()
 {
     $validator = Validator::make(Input::all(), array('section_name' => 'required|max:30|min:3'));
     if ($validator->fails()) {
         $response = array('status' => 'failed', 'msg' => 'Item is not updated', 'errors' => $validator, 'error_messages' => $validator->messages());
         return Response::json($response);
     } else {
         $section_name = Input::get('section_name');
         $section_id = Input::get('section_id');
         $class_id = Input::get('class_id');
         if ($section_id) {
             $section = Sections::find($section_id);
             $section->section_name = ucwords($section_name);
             if ($section->save()) {
                 $response = array('status' => 'success', 'msg' => 'Setting created successfully', 'errors' => null, 'data_send' => array('id' => $section->id, 'section_name' => $section->section_name));
                 return Response::json($response);
             }
         } else {
             $section = new Sections();
             $section->section_name = ucwords($section_name);
             $section->class_id = $class_id;
             if ($section->save()) {
                 $response = array('status' => 'success', 'msg' => 'Setting created successfully', 'errors' => null, 'data_send' => array('id' => $section->id, 'section_name' => $section->section_name));
                 return Response::json($response);
             }
         }
     }
     $response = array('status' => 'failed', 'msg' => 'Item is not updated');
     return Response::json($response);
 }

    /**
     * Create PO Log or Check Log binder for project
     * @param $projectId
     * @param $docType
     * @param $year
     * @return int
     */
    public static function createLogBinder($projectId, $docType, $year)
    {
        // get shelf
        $shelf = self::getShelfForBinderCreate($projectId, $year);

        if ($docType == Documents::PM) {
            $folderCatID = self::CHECK_LOG;
        } else if ($docType == Documents::PO) {
            $folderCatID = self::PURCHASE_ORDER_LOG;
        }

        $binder = Sections::model()->findByAttributes(array(
            'Section_Type' => Storages::SHELF,
            'Created_By' => '0',
            'Storage_ID' => $shelf->Storage_ID,
            'Folder_Cat_ID' => $folderCatID,
        ));

        if (!$binder) {
            $binder = new Sections();
            $binder->Storage_ID = $shelf->Storage_ID;
            if ($docType == Documents::PM) {
                $binder->Section_Name = 'Payments';
            } else if ($docType == Documents::PO) {
                $binder->Section_Name = 'Purchase orders';
            }
            $binder->Vendor_ID = 0;
            $binder->Created_By = 0;
            $binder->Section_Type = Storages::SHELF;
            $binder->Folder_Cat_ID = $folderCatID;
            $binder->Access_Type = Storages::HAS_ACCESS;
            if ($binder->validate()) {
                $binder->save();

                $tab = new Subsections();
                $tab->Section_ID = $binder->Section_ID;
                $tab->Subsection_Name = 'Tab 1';
                $tab->Subsection_Type = Storages::SHELF;
                $tab->Created_By = 0;
                $tab->Access_Type = Storages::HAS_ACCESS;
                $tab->save();
            }
        } else {
            $tab = Subsections::model()->findByAttributes(array(
                'Subsection_Type' => Storages::SHELF,
                'Created_By' => '0',
                'Section_ID' => $binder->Section_ID,
            ));
        }

        return $tab->Subsection_ID;
    }