/**
     * Approve users action
     */
    public function actionApproveUsers()
    {
        if (isset($_GET['users']) && isset($_GET['userTypes'])) {
            foreach ($_GET['users'] as $id => $value) {
                if (is_numeric($id) && ($value == 'Y' || $value == 'N') && isset($_GET['userTypes'][$id]) && isset($this->userTypes[$_GET['userTypes'][$id]])) {
                    // get user type
                    $userType = $this->userTypes[$_GET['userTypes'][$id]];
                    $id = intval($id);

                    //get users to approve row
                    $usersToApprove = UsersToApprove::model()->with('user', 'client')->findByPk($id);
                    if ($usersToApprove && $value == 'Y') {
                        //approve user
                        if ($usersToApprove->New_Client == UsersToApprove::NEW_CLIENT) {
                            $client = $usersToApprove->client;
                            $client->Client_Type = 1;
                            $client->Client_Status = Clients::ACTIVE;
                            $client->Client_Number = $client->Client_ID;
                            $client->save();

                            ClientServiceSettings::addClientServiceSettings($client->Client_ID, true);

                            $password = Helper::generatePassword();
                            $user = $usersToApprove->user;
                            $user->Active = Users::ACTIVE;
                            $user->User_Pwd = md5($password);
                            $user->save();

                            $userClientRelation = UsersClientList::model()->findByAttributes(array(
                                'User_ID' =>$user->User_ID,
                                'Client_ID' =>$client->Client_ID,
                            ));

                            if ($userClientRelation) {
                                $userClientRelation->User_Type = $userType;

                                if (in_array($userType, UsersClientList::$clientAdmins)) {
                                    $userClientRelation->User_Approval_Value = Aps::APPROVED;
                                } else if ($userType == UsersClientList::APPROVER) {
                                    $userClientRelation->User_Approval_Value = Aps::READY_FOR_APPROVAL + 1;
                                } else {
                                    $userClientRelation->User_Approval_Value = 0;
                                }
                                $userClientRelation->save();
                            }

                            $emailSuccess = Mail::sendRegistrationMail($user->person->Email, $user->User_Login,$password, $user->person->First_Name, $user->person->Last_Name, $client->company->Company_Name);
                            $usersToApprove->delete();
                        } else {
                            $usersToApprove->Approved_By_Admin = UsersToApprove::APPR_BY_ADMIN;
                            $usersToApprove->save();

                            $client = $usersToApprove->client;
                            $client->Client_Type = 1;
                            $client->Client_Status = Clients::ACTIVE;
                            $client->Client_Number = $client->Client_ID;
                            $client->save();

                            $user = $usersToApprove->user;

                            if ($user->User_Pwd == md5('temp100')) {
                                // if user requested to join company by registration form
                                $password = Helper::generatePassword();
                                $user->Active = Users::ACTIVE;
                                $user->User_Pwd = md5($password);
                                $user->Default_Project = 0;
                                $user->save();

                                Mail::sendUserRegistrationMail($user->person->Email, $user->User_Login, $password, $user->person->First_Name, $user->person->Last_Name, $client->company->Company_Name);
                            } else {
                                // if user requested to join company and there is not client-admins
                                $user->Active = Users::ACTIVE;
                                $user->save();
                            }

                            $condition = UsersClientList::getClientAdminCondition($usersToApprove->Client_ID);

                            $client_admins_list = UsersClientList::model()->findAll($condition); //this is client admins for current client

                            if ($client_admins_list) {
                                // if client has client-admins
                                foreach ($client_admins_list as $clientAdm) {
                                    $clientAdmin = Users::model()->with('person')->findByPk($clientAdm->User_ID);
                                    $emailSuccess = Mail::sendClientOfUserRegistrationMail($clientAdmin->person->Email, $clientAdmin->person->First_Name, $clientAdmin->person->Last_Name, $user->person->First_Name, $user->person->Last_Name, $client->company->Company_Name);
                                }

                            }



                                // if client hasn't client admins
                                $usersClientList = UsersClientList::model()->findByAttributes(array(
                                   'Client_ID' => $usersToApprove->Client_ID,
                                    'User_ID' => $usersToApprove->User_ID
                                ));

                                if (!$usersClientList) {
                                    $usersClientList = new UsersClientList;
                                }

                                $usersClientList->User_ID = $usersToApprove->User_ID;
                                $usersClientList->Client_ID = $usersToApprove->Client_ID;
                                $usersClientList->User_Type = $userType;

                                if (in_array($userType, UsersClientList::$clientAdmins)) {
                                    $usersClientList->User_Approval_Value = Aps::APPROVED;
                                } else if ($userType == UsersClientList::APPROVER) {
                                    $usersClientList->User_Approval_Value = Aps::READY_FOR_APPROVAL + 1;
                                } else {
                                    $usersClientList->User_Approval_Value = 0;
                                }

                                $usersClientList->save();

                                $project = Projects::model()->findByAttributes(array(
                                    'Client_ID' => $usersToApprove->Client_ID,
                                ));

                                $usersProjectList = new UsersProjectList;
                                $usersProjectList->User_ID = $usersToApprove->User_ID;
                                $usersProjectList->Client_ID = $usersToApprove->Client_ID;
                                $usersProjectList->Project_ID =  $project->Project_ID;
                                $usersProjectList->save();

                                if ($user->Default_Project == 0) {
                                    $user->Default_Project = $project->Project_ID;
                                }
                                $user->save();

                                $usersToApprove->delete();

                                Mail::sendAddUserToClientMail($user->person->Email, $user->person->First_Name, $user->person->Last_Name, $client->company->Company_Name);

                        }
                    } else if ($usersToApprove && $value == 'N') {
                        //reject user
                        $user = $usersToApprove->user;
                        $client = $usersToApprove->client;

                        if ($usersToApprove->New_Client == UsersToApprove::NEW_CLIENT) {
                            $company = $client->company;
                            $addresses = $company->adreses;

                            //delete company addresses
                            foreach ($addresses as $address) {
                                $companyAddress = CompanyAddresses::model()->findByAttributes(array(
                                    'Company_ID' => $company->Company_ID,
                                    'Address_ID' => $address->Address_ID,
                                ));

                                if ($companyAddress) {
                                    $companyAddress->delete();
                                }
                                $address->delete();
                            }

                            $company->delete();

                            $usersClientList = UsersClientList::model()->findByAttributes(array(
                                'User_ID' => $user->User_ID,
                                'Client_ID' => $client->Client_ID,
                            ));

                            if ($usersClientList) {
                                $usersClientList->delete();
                            }

                            $usersToApprove->delete();
                            $client->delete();
                        } else {
                            $usersToApprove->delete();
                        }

                        if ($user->User_Pwd == md5('temp100')) {
                            $user->Active = Users::NOT_ACTIVE;
                            $user->Default_Project = 0;
                            $user->save();

                            Mail::sendRejectUserByAdminMail($user->person->Email, $user->person->First_Name, $user->person->Last_Name);
                        } else {
                            Mail::sendRejectMail($user->person->Email, $user->person->First_Name, $user->person->Last_Name, $client->company->Company_Name);
                        }
                    }
                }
            }

            Yii::app()->user->setFlash('success', "Users have been successfully approved/rejected!");
        } else {
            Yii::app()->user->setFlash('success', "Users was not approved/rejected!");
        }
        $this->redirect('/admin?tab=reg_requests');
    }
Beispiel #2
0
    public static function fillWithSessionDataEntry($company_model,$current_upload_file){
        $adr = $company_model->adreses[0];
        $adr->Address1 = $current_upload_file['street_adr'];
        $adr->City = $current_upload_file['city'];
        $adr->State = $current_upload_file['state'];
        $adr->ZIP = $current_upload_file['zip'];
        $adr->save();


        $companyAdreses = CompanyAddresses::model()->findByAttributes(array(
            'Company_ID'=>$company_model->Company_ID
        ));
        $companyAdreses->Address_ID = $adr->Address_ID;
        $companyAdreses->save();
    }
	/**
	 * Lists all models.
	 */
	public function actionIndex()
	{
        if (isset($_POST['oper']) && $_POST['oper'] == 'edit') {
            $companyId = intval($_POST["id"]);
            $company = Companies::model()->with('client', 'adreses')->findByPk($companyId);
            if ($company) {
                if ($company->client) {
                    $client = $company->client;
                    $client->Client_Number = $_POST["Client_Number"];
                    $client->Client_Logo_Name = $_POST["Client_Logo_Name"];
                    $client->Client_Approval_Amount_1 = $_POST["Client_Approval_Amount_1"] ? $_POST["Client_Approval_Amount_1"] : null;
                    $client->Client_Approval_Amount_2 = $_POST["Client_Approval_Amount_2"] ? $_POST["Client_Approval_Amount_2"] : null;
                    if ($client->validate()) {
                        $client->save();
                        echo "client\n";
                    }
                }

                if ($company->adreses) {
                    $addresses = $company->adreses;
                    if (isset($addresses[0])) {
                        $address = $addresses[0];
                        $address->Address1 =  $_POST["Address1"];
                        $address->Address2 =  $_POST["Address2"];
                        $address->City =  $_POST["City"];
                        $address->State =  $_POST["State"];
                        $address->ZIP =  $_POST["ZIP"];
                        $address->Country =  $_POST["Country"];
                        $address->Phone =  $_POST["Phone"];
                        $address->Fax =  $_POST["Fax"];

                        if ($address->validate()) {
                            $address->save();
                            echo "address\n";
                        }
                    }
                }

                $company->Company_Name = $_POST["Company_Name"];
                $company->Company_Fed_ID = $_POST["Company_Fed_ID"];
                $company->Email = $_POST["Email"];
                $company->SSN = $_POST["SSN"];
                $company->Business_NameW9 = $_POST["Business_NameW9"];

                if ($company->validate()) {
                    $company->save();
                    echo "company\n";
                }
            }
            die;
        }

        if (isset($_POST['oper']) && $_POST['oper'] == 'add') {
            die;
        }

        if (isset($_POST['oper']) && $_POST['oper'] == 'del') {
            $companyId = intval($_POST["id"]);
            $company = Companies::model()->with('client', 'adreses')->findByPk($companyId);
            $documents = Documents::model()->findByAttributes(array(
                'Client_ID' => $company->client->Client_ID,
            ));

            if ($company && !$documents) {
                if ($company->client) {
                    $client = $company->client;

                    UsersToApprove::model()->deleteAllByAttributes(array(
                        'Client_ID' => $client->Client_ID,
                    ));

                    UsersClientList::model()->deleteAllByAttributes(array(
                        'Client_ID' => $client->Client_ID,
                    ));

                    UsersProjectList::model()->deleteAllByAttributes(array(
                        'Client_ID' => $client->Client_ID,
                    ));

                    BankAcctNums::model()->deleteAllByAttributes(array(
                        'Client_ID' => $client->Client_ID,
                    ));

                    Coa::model()->deleteAllByAttributes(array(
                        'Client_ID' => $client->Client_ID,
                    ));

                    Vendors::model()->deleteAllByAttributes(array(
                        'Client_Client_ID' => $client->Client_ID,
                    ));

                    Vendors::model()->deleteAllByAttributes(array(
                        'Vendor_Client_ID' => $client->Client_ID,
                    ));

                    $w9s = W9::model()->findAllByAttributes(array(
                        'Client_ID' => $client->Client_ID,
                    ));

                    if ($w9s) {
                        foreach ($w9s as $w9) {
                            W9::deleteW9($w9->W9_ID);
                        }
                    }

                    $projects = Projects::model()->findAllByAttributes(array(
                        'Client_ID' => $client->Client_ID,
                    ));

                    if ($projects) {
                        foreach ($projects as $project) {
                            PoFormatting::model()->deleteAllByAttributes(array(
                                'Project_ID' => $project->Project_ID,
                            ));
                            $project->delete();
                        }
                    }

                    $client->delete();
                }

                if ($company->adreses) {
                    $addresses = $company->adreses;
                    foreach ($addresses as $address) {
                        $address->delete();
                    }
                }

                CompanyAddresses::model()->deleteAllByAttributes(array(
                    'Company_ID' => $companyId,
                ));

                $company->delete();
            }
            die;
        }

        $conn = mysql_connect(Yii::app()->params->dbhost, Yii::app()->params->dbuser, Yii::app()->params->dbpassword);
        mysql_select_db(Yii::app()->params->dbname);
        mysql_query("SET NAMES 'utf8'");

        Yii::import('ext.phpgrid.inc.jqgrid');

        // set columns
        $col = array();
        $col["title"] = "Company ID"; // caption of column
        $col["name"] = "Company_ID";
        $col["dbname"] = "companies.Company_ID"; // grid column name, same as db field or alias from sql
        $col["resizable"] = false;
        $col["editable"] = false; // this column is editable
        $col["hidden"] = false;
        $col["viewable"] = true;
        $col["search"] = false;
        $col["sortable"] = false;
        $cols[] = $col;

        // set columns
        $col = array();
        $col["title"] = "Company Name"; // caption of column
        $col["name"] = "Company_Name";
        $col["dbname"] = "companies.Company_Name"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $col["search"] = true;
        $col["sortable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Fed ID"; // caption of column
        $col["name"] = "Company_Fed_ID";
        $col["dbname"] = "companies.Company_Fed_ID"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        // set columns
        $col = array();
        $col["title"] = "SSN"; // caption of column
        $col["name"] = "SSN";
        $col["dbname"] = "companies.SSN"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $col["search"] = false;
        $col["sortable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Email"; // caption of column
        $col["name"] = "Email";
        $col["dbname"] = "companies.Email"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $col["search"] = false;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Business_NameW9"; // caption of column
        $col["name"] = "Business_NameW9";
        $col["dbname"] = "companies.Business_NameW9"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $col["search"] = false;
        $cols[] = $col;

        // set columns
        $col = array();
        $col["title"] = "Client ID"; // caption of column
        $col["name"] = "Client_ID";
        $col["dbname"] = "clients.Client_ID"; // grid column name, same as db field or alias from sql
        $col["resizable"] = false;
        $col["editable"] = false; // this column is editable
        $col["hidden"] = false;
        $col["viewable"] = true;
        $col["search"] = false;
        $col["sortable"] = false;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Client Number"; // caption of column
        $col["name"] = "Client_Number";
        $col["dbname"] = "clients.Client_Number"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Client Logo Name"; // caption of column
        $col["name"] = "Client_Logo_Name";
        $col["dbname"] = "clients.Client_Logo_Name"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Client Approval Amount 1"; // caption of column
        $col["name"] = "Client_Approval_Amount_1";
        $col["dbname"] = "clients.Client_Approval_Amount_1"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $col["search"] = false;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Client Approval Amount 2"; // caption of column
        $col["name"] = "Client_Approval_Amount_2";
        $col["dbname"] = "clients.Client_Approval_Amount_2"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $col["search"] = false;
        $cols[] = $col;

        // set columns
        $col = array();
        $col["title"] = "Address ID"; // caption of column
        $col["name"] = "Address_ID";
        $col["dbname"] = "addresses.Address_ID"; // grid column name, same as db field or alias from sql
        $col["resizable"] = false;
        $col["editable"] = false; // this column is editable
        $col["hidden"] = true;
        $col["viewable"] = true;
        $col["search"] = false;
        $col["sortable"] = false;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Address1"; // caption of column
        $col["name"] = "Address1";
        $col["dbname"] = "addresses.Address1"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Address2"; // caption of column
        $col["name"] = "Address2";
        $col["dbname"] = "addresses.Address2"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "City"; // caption of column
        $col["name"] = "City";
        $col["dbname"] = "addresses.City"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "State"; // caption of column
        $col["name"] = "State";
        $col["dbname"] = "addresses.State"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "ZIP"; // caption of column
        $col["name"] = "ZIP";
        $col["dbname"] = "addresses.ZIP"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Country"; // caption of column
        $col["name"] = "Country";
        $col["dbname"] = "addresses.Country"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Phone"; // caption of column
        $col["name"] = "Phone";
        $col["dbname"] = "addresses.Phone"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $cols[] = $col;

        $col = array();
        $col["title"] = "Fax"; // caption of column
        $col["name"] = "Fax";
        $col["dbname"] = "addresses.Fax"; // grid column name, same as db field or alias from sql
        $col["resizable"] = true;
        $col["editable"] = true; // this column is editable
        $col["viewable"] = true;
        $col["search"] = false;
        $cols[] = $col;

        $g = new jqgrid();

        $grid["caption"] = "Clients";
       // $grid["multiselect"] = true;
        $grid["autowidth"] = true;
        $grid["resizable"] = true;
        //$grid["toppager"] = true;
        $grid["sortname"] = 'companies.Company_Name';
        $grid["sortorder"] = "ASC";
        $grid["add_options"] = array(
            'width'=>'420',
            "closeAfterEdit"=>true, // close dialog after add/edit
            "top"=>"200", // absolute top position of dialog
            "left"=>"200" // absolute left position of dialog
        );

        $g->set_options($grid);

        $g->set_actions(array(
                "add"=>false, // allow/disallow add
                "edit"=>true, // allow/disallow edit
                "delete"=>true, // allow/disallow delete
                "rowactions"=>true, // show/hide row wise edit/del/save option
                "export"=>true, // show/hide export to excel option
                "autofilter" => true, // show/hide autofilter for search
                "search" => "advance" // show single/multi field search condition (e.g. simple or advance)
            )
        );

        $g->select_command = "SELECT  clients.Client_ID, clients.Client_Number, clients.Client_Logo_Name,
                                      companies.*, addresses.*, clients.Client_Approval_Amount_1,
                                      clients.Client_Approval_Amount_2
                              FROM clients
                              LEFT JOIN companies ON clients.Company_ID = companies.Company_ID
                              LEFT JOIN company_addresses ON company_addresses.Company_ID = companies.Company_ID
                              LEFT JOIN addresses ON addresses.Address_ID = company_addresses.Address_ID";

        // set database table for CRUD operations
        $g->table = "clients";

        $g->set_columns($cols);

        // group columns header
        $g->set_group_header( array(
                "useColSpanStyle"=>true,
                "groupHeaders"=>array(
                    array(
                        "startColumnName"=>'Company_ID', // group starts from this column
                        "numberOfColumns"=>6, // group span to next 2 columns
                        "titleText"=>'Company Information' // caption of group header
                    ),
                    array(
                        "startColumnName"=>'Client_ID', // group starts from this column
                        "numberOfColumns"=>5, // group span to next 2 columns
                        "titleText"=>'Client Information' // caption of group header
                    ),
                    array(
                        "startColumnName"=>'Address1', // group starts from this column
                        "numberOfColumns"=>8, // group span to next 2 columns
                        "titleText"=>"Company's Address" // caption of group header
                    )
                )
            )
        );

        // render grid and get html/js output
        $out = $g->render("Clients");

        $this->render('index',array(
            'out'=>$out,
        ));
	}