MAINHACK

Viewing / Editing File: Setup.php

<?php

/** --------------------------------------------------------------------------------
 * This controller manages the business logic for the setup wizard
 *
 * @package    Grow CRM
 * @author     NextLoop
 *----------------------------------------------------------------------------------*/

namespace App\Http\Controllers\Setup;

use App\Http\Controllers\Controller;
use App\Http\Controllers\Setup\DatabaseResponse;
use App\Http\Controllers\Setup\FinishResponse;
use App\Http\Controllers\Setup\IndexResponse;
use App\Http\Controllers\Setup\RequirementsResponse;
use App\Http\Controllers\Setup\SettingsResponse;
use App\Http\Controllers\Setup\UserResponse;
use App\Repositories\EnvRepository;
use App\Repositories\SpaceRepository;
use Exception;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Http;
use Illuminate\Support\Facades\Log;
use Validator;

class Setup extends Controller {

/**
     * The space repository instance.
     */
    protected $spacerepo;

public function __construct(SpaceRepository $spacerepo) {

//parent
        parent::__construct();

//authenticated
        $this->middleware('guest');

$this->spacerepo = $spacerepo;
    }

/**
     * Display Setup first page
     * @return blade view | ajax view
     */
    public function index() {

//reponse payload
        $payload = [
            'page' => $this->pageSettings(),
        ];

//show the view
        return new IndexResponse($payload);
    }

/**
     * Display Setup first page
     * @return blade view | ajax view
     */
    public function serverInfo() {

//show the view
        return view('pages/setup/serverinfo');
    }

/**
     * [source] https://laravel.com/docs/7.x/installation#server-requirements
     * PHP >= 7.2.5
     * BCMath PHP Extension
     * Ctype PHP Extension
     * Fileinfo PHP extension
     * JSON PHP Extension
     * Mbstring PHP Extension
     * OpenSSL PHP Extension
     * PDO PHP Extension
     * Tokenizer PHP Extension
     * XML PHP Extension
     * @return blade view | ajax view
     */
    public function checkRequirements() {

$error['count'] = 0;

//server requirements checks
        $requirements['php_version'] = version_compare(PHP_VERSION, '8.2.0', ">=") && version_compare(PHP_VERSION, '8.4.0', "<");
        $requirements['bcmath'] = extension_loaded("bcmath");
        $requirements['mysql'] = extension_loaded("mysqli");
        $requirements['ctype'] = extension_loaded("ctype");
        $requirements['fileinfo'] = extension_loaded("fileinfo");
        $requirements['json'] = extension_loaded("json");
        $requirements['mbstring'] = extension_loaded("mbstring");
        $requirements['openssl'] = extension_loaded("openssl");
        $requirements['pdo'] = defined('PDO::ATTR_DRIVER_NAME');
        $requirements['tokenizer'] = extension_loaded("tokenizer");
        $requirements['xml'] = extension_loaded("xml");
        $requirements['gd'] = extension_loaded("gd");
        $requirements['fileinfo'] = extension_loaded("fileinfo");

//directory (writable checks)
        $requirements['dir_updates'] = is_writable(BASE_DIR . '/updates');
        $requirements['dir_storage'] = is_writable(BASE_DIR . '/storage');
        $requirements['dir_storage_avatars'] = is_writable(BASE_DIR . '/storage/avatars');
        $requirements['dir_storage_logos'] = is_writable(BASE_DIR . '/storage/logos');
        $requirements['dir_storage_logos_clients'] = is_writable(BASE_DIR . '/storage/logos/clients');
        $requirements['dir_storage_logos_app'] = is_writable(BASE_DIR . '/storage/logos/app');
        $requirements['dir_storage_files'] = is_writable(BASE_DIR . '/storage/files');
        $requirements['dir_storage_temp'] = is_writable(BASE_DIR . '/storage/temp');
        $requirements['dir_app_storage_app'] = is_writable(BASE_DIR . '/application/storage/app');
        $requirements['dir_app_storage_app_public'] = is_writable(BASE_DIR . '/application/storage/app/public');
        $requirements['dir_app_storage_cache'] = is_writable(BASE_DIR . '/application/storage/cache');
        $requirements['dir_app_storage_cache_data'] = is_writable(BASE_DIR . '/application/storage/cache/data');
        $requirements['dir_app_storage_debugbar'] = is_writable(BASE_DIR . '/application/storage/debugbar');
        $requirements['dir_app_storage_framework'] = is_writable(BASE_DIR . '/application/storage/framework');
        $requirements['dir_app_storage_framework_cache'] = is_writable(BASE_DIR . '/application/storage/framework/cache');
        $requirements['dir_app_storage_framework_cache_data'] = is_writable(BASE_DIR . '/application/storage/framework/cache/data');
        $requirements['dir_app_storage_framework_sessions'] = is_writable(BASE_DIR . '/application/storage/framework/sessions');
        $requirements['dir_app_storage_framework_testing'] = is_writable(BASE_DIR . '/application/storage/framework/testing');
        $requirements['dir_app_storage_framework_views'] = is_writable(BASE_DIR . '/application/storage/framework/views');
        $requirements['dir_app_storage_logs'] = is_writable(BASE_DIR . '/application/storage/logs');
        $requirements['dir_app_bootstrap_cache'] = is_writable(BASE_DIR . '/application/bootstrap/cache');
        $requirements['dir_app_storage_app_purifier'] = is_writable(BASE_DIR . '/application/storage/app/purifier');
        $requirements['dir_app_storage_app_purifier_html'] = is_writable(BASE_DIR . '/application/storage/app/purifier/HTML');

//files (writable checks)
        $requirements['dir_app_env'] = is_writable(BASE_DIR . '/application/.env');

//check if we had errors
        foreach ($requirements as $key => $value) {
            if (!$value) {
                $error['count']++;
            }
        }

//reponse payload
        $payload = [
            'page' => $this->pageSettings(),
            'requirements' => $requirements,
            'error' => $error,
        ];

//show the view
        return new RequirementsResponse($payload);
    }

/**
     * Display database form page
     * @return blade view | ajax view
     */
    public function showDatabase() {

$error['count'] = 0;

//reponse payload
        $payload = [
            'page' => $this->pageSettings(),
            'error' => $error,
        ];

//show the view
        return new DatabaseResponse($payload);
    }

/**
     * Update database and show settings form
     * @return blade view | ajax view
     */
    public function updateDatabase(EnvRepository $envrepo) {

$error['count'] = 0;

//validate
        $validator = Validator::make(request()->all(), [
            'database_host' => 'required',
            'database_port' => 'required',
            'database_name' => 'required',
            'database_username' => 'required',
        ]);

//errors
        if ($validator->fails()) {
            abort(409, __('Fill in al required fields'));
        }

//check if password has disallowed characters "
        if (request()->filled('database_password')) {
            if (stripos(request('database_password'), '"')) {
                abort(409, 'You MySQL password contains a disallowed character "');
            }
        }

//try and connect to database
        $dbhost = request('database_host');
        $dbport = request('database_port');
        $dbname = request('database_name');
        $dbuser = request('database_username');
        $dbpass = request('database_password');

//connect
        try {
            $connection = @mysqli_connect($dbhost, $dbuser, $dbpass);
        } catch (Exception $e) {
            abort(409, __('Error(1001): Unable to connect to your database. Check details and try again'));
        }

//select the database
        try {
            @mysqli_select_db($connection, $dbname);
        } catch (Exception $e) {
            abort(409, __('Error(1001): Unable to connect to your database. Check details and try again'));
        }

//update the .env file
        $data = [
            'DB_HOST' => $dbhost,
            'DB_PORT' => $dbport,
            'DB_DATABASE' => $dbname,
            'DB_USERNAME' => $dbuser,
            'DB_PASSWORD' => $dbpass,
        ];
        if (!$envrepo->updateDatabase($data)) {
            abort(409, __('Error(1003): Unable to save the (.env) file'));
        }

//reponse payload
        $payload = [
            'page' => $this->pageSettings(),
            'error' => $error,
        ];

//show the view
        return new SettingsResponse($payload);
    }

/**
     * Update settings and display user form
     * @return blade view | ajax view
     */
    public function updateSettings() {

//validate
        $validator = Validator::make(request()->all(), [
            'settings_company_name' => 'required',
            'settings_system_timezone' => 'required',
        ]);

//errors
        if ($validator->fails()) {
            abort(409, __('Fill in al required fields'));
        }

//import sql file
        $sql_file = BASE_DIR . '/setup.sql';

//validate file
        if (!is_file($sql_file)) {
            abort(409, __('Error(1004): A required file (/setup.sql) is missing'));
        }

//import the file
        DB::unprepared(file_get_contents($sql_file));

//update default settings
        if (!$settings = \App\Models\Settings::Where('settings_id', 1)->first()) {
            abort(409, __('Error(1007): Unable to load database settings'));
        }

//update default categories dates
        \App\Models\Category::where('category_system_default', 'yes')
            ->update(['category_created' => now()]);

//update default categories dates
        \App\Models\KbCategories::where('kbcategory_system_default', 'yes')
            ->update(['kbcategory_created' => now()]);

//update settings
        $settings->settings_company_name = request('settings_company_name');
        $settings->settings_installation_date = now();
        $settings->save();

//reponse payload
        $payload = [
            'page' => $this->pageSettings(),
        ];

//show the view
        return new UserResponse($payload);
    }

/**
     * Update admin user and display finish page
     * @return blade view | ajax view
     */
    public function updateUser(EnvRepository $envrepo) {

//validate
        $validator = Validator::make(request()->all(), [
            'first_name' => 'required',
            'last_name' => 'required',
            'email' => 'required',
            'password' => 'required',
        ]);

//errors
        if ($validator->fails()) {
            abort(409, __('Fill in al required fields'));
        }

//update default settings
        if (!$settings = \App\Models\Settings::Where('settings_id', 1)->first()) {
            abort(409, __('Error(1007): Unable to load database settings'));
        }

//update default user
        if (!$user = \App\Models\User::Where('id', 1)->first()) {
            abort(409, __('Error(1005): Admin user could not be updated'));
        }
        $user->first_name = request('first_name');
        $user->last_name = request('last_name');
        $user->email = request('email');
        $user->password = bcrypt(request('password'));
        $user->created = now();
        $user->updated = now();
        $user->last_seen = now();
        $user->creatorid = 0;
        $user->unique_id = str_unique();
        $user->timezone = $settings->settings_system_timezone;
        $user->save();

//create spaces [TODO][SPACES] uncomment this for spaces
        //$this->createUserSpace($user);

//create spaces [TODO][SPACES] uncomment this for spaces
        //$this->createTeamSpace();

//post actions
        $this->postActions();

//opt-in mailing list
        $this->mailingList();

//delete setup sql file
        @unlink(BASE_DIR . '/setup.sql');

//final .env file update
        if (!$envrepo->completeSetup()) {
            abort(409, __('Error(1006): - Setup could not complete'));
        }

//reponse payload
        $payload = [
            'page' => $this->pageSettings(),
            'cronjob_path' => '/usr/local/bin/php ' . BASE_DIR . '/application/artisan schedule:run >> /dev/null 2>&1',
        ];

//show the view
        return new FinishResponse($payload);
    }

/**
     * create user space,for the default user
     *
     * @param  obj  user model
     * @return null
     */
    public function createUserSpace($user) {

//create a space for this user
        $space = new \App\Models\Project();
        $space->project_uniqueid = str_unique();
        $space->project_id = -(time() + 1);
        $space->project_type = 'space';
        $space->project_creatorid = 0;
        $space->project_title = 'My Space';
        $space->project_reference = 'default-user-space';
        $space->save();

//assign the user to the new space
        $assigned = new \App\Models\ProjectAssigned();
        $assigned->projectsassigned_projectid = $space->project_id;
        $assigned->projectsassigned_userid = 1;
        $assigned->save();

//create a default folder for the [files] feature, in the space
        $folder = new \App\Models\FileFolder();
        $folder->filefolder_creatorid = 0;
        $folder->filefolder_projectid = $space->project_id;
        $folder->filefolder_name = 'Default';
        $folder->filefolder_default = 'yes';
        $folder->filefolder_system = 'no';
        $folder->save();

//update profile with space id
        $user->space_uniqueid = $space->project_uniqueid;
        $user->save();

}

/**
     * create a space,for the team
     * @return null
     */
    public function createTeamSpace() {

$space = new \App\Models\Project();
        $space->setConnection('tenant');
        $space->project_uniqueid = str_unique();
        $space->project_id = -(time() - 5);
        $space->project_type = 'space';
        $space->project_creatorid = 0;
        $space->project_title = 'Team Space';
        $space->project_reference = 'default-team-space';
        $space->save();

//save the unique id of the space, in the settings table
        \App\Models\Settings2::where('settings2_id', 1)
            ->update([
                'settings2_spaces_team_space_id' => $space->project_uniqueid,
            ]);

//assign user to the space
        $assigned = new \App\Models\ProjectAssigned();
        $assigned->projectsassigned_projectid = $space->project_id;
        $assigned->projectsassigned_userid = 1;
        $assigned->save();

}

/**
     * final actions
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function postActions() {

/** -------------------------------------------------------------------------
         * update system tempates to have todays dates
         * -------------------------------------------------------------------------*/
        DB::table('contract_templates')->update([
            'contract_template_created' => now(),
        ]);

DB::table('proposal_templates')->update([
            'proposal_template_created' => now(),
        ]);

/** -------------------------------------------------------------------------
         * store product code
         * -------------------------------------------------------------------------*/
        \App\Models\Settings::where('settings_id', 1)
            ->update(['settings_purchase_code' => session('purchase_code')]);

}

/**
     * some notes
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function mailingList() {

//validate
        if (request('optin') != 'on') {
            return;
        }

//connect to updates
        try {
            $response = Http::asForm()->post('https://updates.growcrm.io/mailinglist/add', [
                'first_name' => request('first_name'),
                'last_name' => request('last_name'),
                'email' => request('email'),
                'ip' => request()->ip(),
                'url' => url()->current(),
                'domain' => request()->getHost(),
            ]);
        } catch (\Illuminate\Http\Client\ConnectionException$e) {
            //nothing
        }

}

/**
     * basic page setting for this section of the app
     * @param string $section page section (optional)
     * @param array $data any other data (optional)
     * @return array
     */
    private function pageSettings($section = '', $data = []) {

$page = [
            'page' => 'setup',
            'meta_title' => 'Application Setup',
        ];
        return $page;
    }

}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: Setup.php

Server Info

System Features

User Info