/**
* 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');
}
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,
));
}