/** * Modify User POST */ function modcontact() { $clang = Yii::app()->lang; $action = isset($_GET['action']) ? $_GET['action'] : ''; if ($action == "modcontact") { $contact_id = (int) Yii::app()->request->getPost("contact_id"); $saluation = flattenText($_POST['saluation'], false, true, 'UTF-8', true); $contact_fname = flattenText($_POST['contact_fname'], false, true, 'UTF-8', true); $contact_mname = flattenText($_POST['contact_mname'], false, true, 'UTF-8', true); $contact_lname = flattenText($_POST['contact_lname'], false, true, 'UTF-8', true); $company_id = (int) Yii::app()->request->getPost("company_id"); $contact_group = (int) Yii::app()->request->getPost("contact_group"); $contact_group = $contact_group == 0 ? '-1' : $contact_group; $IsListProvider = flattenText($_POST['IsListProvider'], false, true, 'UTF-8', true); $notes = flattenText($_POST['notes'], false, true, 'UTF-8', true); $gender = flattenText($_POST['gender'], false, true, 'UTF-8', true); $birthdate = date('Y-m-d', strtotime($_POST['birthdate'])); $add1 = flattenText($_POST['add1'], false, true, 'UTF-8', true); $add2 = flattenText($_POST['add2'], false, true, 'UTF-8', true); $add3 = flattenText($_POST['add3'], false, true, 'UTF-8', true); $country = (int) Yii::app()->request->getPost("country"); $zonelist = (int) Yii::app()->request->getPost("zonelist"); $statelist = (int) Yii::app()->request->getPost("statelist"); $citylist = (int) Yii::app()->request->getPost("citylist"); $zip = flattenText($_POST['zip'], false, true, 'UTF-8', true); $fax = flattenText($_POST['fax'], false, true, 'UTF-8', true); $emsilp = flattenText($_POST['emailp'], false, true, 'UTF-8', true); $emails = flattenText($_POST['emails'], false, true, 'UTF-8', true); $phonep = flattenText($_POST['phonep'], false, true, 'UTF-8', true); $phones = flattenText($_POST['phones'], false, true, 'UTF-8', true); $company_type = array(); if (isset($_POST['company_type'])) { $company_type = $_POST['company_type']; } $ctype = Company_type::model()->findAll(array('select' => 'concat(company_type_id,"__", company_type) as company_type_id , company_type_name')); $ctypelist = CHtml::listData($ctype, 'company_type_id', 'company_type_name'); $IsActive = flattenText(Yii::app()->request->getPost("IsActive")); $addsummary = ''; $aViewUrls = array(); $is_Active = 0; if ($IsActive) { $is_Active = 1; } $sresult = Contact::model()->findAllByAttributes(array('contact_id' => $contact_id)); $sresultcount = count($sresult); if (Permission::model()->hasGlobalPermission('superadmin', 'read') || $sresultcount > 0 && Permission::model()->hasGlobalPermission('contacts', 'update')) { if ($emsilp == '' || $phonep == '' || $contact_fname == '') { $aViewUrls['mboxwithredirect'][] = $this->_messageBoxWithRedirect($clang->gT("Failed to edit Contact "), $clang->gT("Could not modify Contact."), "warningheader", $clang->gT("Contact Name or Primary Email or Phone not be empty."), $this->getController()->createUrl('admin/contact/sa/modifycontact'), $clang->gT("Back"), array('contact_id' => $contact_id)); } elseif (Contact::model()->findByAttributes(array('primary_emailid' => $emsilp), 'contact_id != ' . $contact_id . '')) { $aViewUrls['message'] = array('title' => $clang->gT("Failed to edit Contact "), 'message' => $clang->gT("The Contact Email already exists."), 'class' => 'warningheader'); } else { $oRecord = Contact::model()->findByPk($contact_id); $oRecord->first_name = $contact_fname; $oRecord->middle_name = $contact_mname; $oRecord->last_name = $contact_lname; $oRecord->saluation = $saluation; $oRecord->contact_group_id = $contact_group; $oRecord->is_list_provider = $IsListProvider; $oRecord->notes = $notes; $oRecord->gender = $gender; $oRecord->birth_date = $birthdate; $oRecord->address1 = $add1; $oRecord->address2 = $add2; $oRecord->address3 = $add3; $oRecord->country_id = $country; $oRecord->zone_id = $zonelist; $oRecord->state_id = $statelist; $oRecord->city_id = $citylist; $oRecord->zip = $zip; $oRecord->fax = $fax; $oRecord->primary_emailid = $emsilp; $oRecord->primary_contact_no = $phonep; $oRecord->other_emailid = $emails; $oRecord->other_contact_no = $phones; $oRecord->IsActive = $is_Active; $oRecord->contact_type_id = CONTACT; $EditContact = $oRecord->save(); if ($EditContact) { // When saved successfully $dlt = "DELETE FROM {{map_contact_n_titles}} WHERE contact_id = " . $contact_id; $result = Yii::app()->db->createCommand($dlt)->query(); foreach ($ctypelist as $key => $value) { foreach ($company_type as $ky => $vle) { $test = explode('__', $vle); if ($vle == $key) { $title_ID = (int) Yii::app()->request->getPost($value); $sql = "INSERT INTO {{map_contact_n_titles}} (contact_id,contact_title_id)\n VALUES('{$contact_id}`', '{$title_ID}')"; $result = Yii::app()->db->createCommand($sql)->query(); } } } Yii::app()->setFlashMessage($clang->gT("Contact updated successfully")); $this->getController()->redirect(array("admin/contact/sa/modifycontact/contact_id/{$company_id}/action/modifycompany")); } else { //Saving the user failed for some reason, message about email is not helpful here // Username and/or email adress already exists. $aViewUrls['mboxwithredirect'][] = $this->_messageBoxWithRedirect($clang->gT("Editing contact title"), $clang->gT("Could not modify contact title."), 'warningheader'); } } } else { Yii::app()->setFlashMessage(Yii::app()->lang->gT("You do not have sufficient rights to access this page."), 'error'); } } elseif ($action == "modcompany") { // table contact_id $contact_id = (int) Yii::app()->request->getPost("contact_id"); // company filed value $company_name = flattenText($_POST['company_name'], false, true, 'UTF-8', true); $parent_contact = (int) Yii::app()->request->getPost("parent_contact"); $contact_group = (int) Yii::app()->request->getPost("contact_group"); $IsListProvider = flattenText($_POST['IsListProvider'], false, true, 'UTF-8', true); $notes = flattenText($_POST['notes'], false, true, 'UTF-8', true); $add1 = flattenText($_POST['add1'], false, true, 'UTF-8', true); $add2 = flattenText($_POST['add2'], false, true, 'UTF-8', true); $add3 = flattenText($_POST['add3'], false, true, 'UTF-8', true); $country = (int) Yii::app()->request->getPost("country"); $zonelist = (int) Yii::app()->request->getPost("zonelist"); $statelist = (int) Yii::app()->request->getPost("statelist"); $citylist = (int) Yii::app()->request->getPost("citylist"); $zip = flattenText($_POST['zip'], false, true, 'UTF-8', true); $fax = flattenText($_POST['fax'], false, true, 'UTF-8', true); $emsilp = flattenText($_POST['emailp'], false, true, 'UTF-8', true); $emails = flattenText($_POST['emails'], false, true, 'UTF-8', true); $phonep = flattenText($_POST['phonep'], false, true, 'UTF-8', true); $phones = flattenText($_POST['phones'], false, true, 'UTF-8', true); $RIDCheck = flattenText($_POST['RIDCheck'], false, true, 'UTF-8', true); $company_type = array(); if (isset($_POST['company_type'])) { $company_type = $_POST['company_type']; } foreach ($company_type as $key => $value) { $test = explode('__', $value); $row[] = $test[1]; } if (in_array('V', $row)) { $completionlink = flattenText($_POST['completionlink'], false, true, 'UTF-8', true); $disqualifylink = flattenText($_POST['disqualifylink'], false, true, 'UTF-8', true); $quatafulllink = flattenText($_POST['quatafulllink'], false, true, 'UTF-8', true); } else { $completionlink = ''; $disqualifylink = ''; $quatafulllink = ''; } $ctype = Company_type::model()->findAll(array('select' => 'concat(company_type_id,"__", company_type) as company_type_id , company_type_name')); $ctypelist = CHtml::listData($ctype, 'company_type_id', 'company_type_name'); $IsActive = flattenText(Yii::app()->request->getPost("IsActive")); $addsummary = ''; $aViewUrls = array(); $is_Active = 0; if ($IsActive) { $is_Active = 1; } $sresult = Contact::model()->findAllByAttributes(array('contact_id' => $contact_id)); $sresultcount = count($sresult); if (Permission::model()->hasGlobalPermission('superadmin', 'read') || $sresultcount > 0 && Permission::model()->hasGlobalPermission('contacts', 'update')) { if ($emsilp == '' || $phonep == '' || $company_name == '') { $aViewUrls['mboxwithredirect'][] = $this->_messageBoxWithRedirect($clang->gT("Failed to add Company"), $clang->gT("Could not modify company."), "warningheader", $clang->gT("Company Name or Primary Email or Phone no not be empty."), $this->getController()->createUrl('admin/contact/sa/modifycontact'), $clang->gT("Back"), array('contact_id' => $contact_id)); } elseif (Contact::model()->findByAttributes(array('company_name' => $company_name), 'contact_id != ' . $contact_id . '')) { $aViewUrls['message'] = array('title' => $clang->gT("Failed to edit Company"), 'message' => $clang->gT("The Company Name already exist."), 'class' => 'warningheader'); } elseif (Contact::model()->findByAttributes(array('primary_emailid' => $emsilp), 'contact_id != ' . $contact_id . '')) { $aViewUrls['message'] = array('title' => $clang->gT("Failed to edit Company"), 'message' => $clang->gT("The Company Email Id already exist."), 'class' => 'warningheader'); } else { $oRecord = Contact::model()->findByPk($contact_id); $oRecord->company_name = $company_name; $oRecord->parent_contact_id = $parent_contact; $oRecord->contact_group_id = $contact_group; $oRecord->is_list_provider = $IsListProvider; $oRecord->notes = $notes; $oRecord->address1 = $add1; $oRecord->address2 = $add2; $oRecord->address3 = $add3; $oRecord->country_id = $country; $oRecord->zone_id = $zonelist; $oRecord->state_id = $statelist; $oRecord->city_id = $citylist; $oRecord->zip = $zip; $oRecord->fax = $fax; $oRecord->primary_emailid = $emsilp; $oRecord->primary_contact_no = $phonep; $oRecord->other_emailid = $emails; $oRecord->other_contact_no = $phones; $oRecord->completionlink = $completionlink; $oRecord->disqualifylink = $disqualifylink; $oRecord->quatafulllink = $quatafulllink; $oRecord->IsActive = $is_Active; $oRecord->contact_type_id = COMPANY; $EditCompany = $oRecord->save(); if ($EditCompany) { // When saved successfully change mapping table $dlt = "DELETE FROM {{map_company_n_types}} WHERE company_id = " . $contact_id; $result = Yii::app()->db->createCommand($dlt)->query(); foreach ($company_type as $ky => $vle) { $test = explode('__', $vle); $sql = "INSERT INTO {{map_company_n_types}} (company_id, company_type_id)\n VALUES('{$contact_id}', '{$test['0']}')"; $result = Yii::app()->db->createCommand($sql)->query(); } Yii::app()->setFlashMessage($clang->gT("Company updated successfully")); $this->getController()->redirect(array("admin/contact/index")); } else { $aViewUrls['mboxwithredirect'][] = $this->_messageBoxWithRedirect($clang->gT("Editing contact title"), $clang->gT("Could not modify contact title."), 'warningheader'); } } } else { Yii::app()->setFlashMessage(Yii::app()->lang->gT("You do not have sufficient rights to access this page."), 'error'); } } $this->_renderWrappedTemplate('contacts/contact', $aViewUrls); }
<tr> <td align="right" style="text-align: right;"> <label for='company_type'><?php $clang->eT("Company Type* : "); ?> </label> </td> <td> <?php $test = explode(',', $mrw['company_type_id']); $test1 = explode(',', $mrw['company_type']); $t = array_combine($test, $test1); foreach ($t as $key => $val) { $testkey[] = $key . '__' . $val; } $ctype = Company_type::model()->findAll(array('select' => 'concat(company_type_id,"__", company_type) as company_type_id , company_type_name', 'condition' => "Istitle = '1'")); $ctypelist = CHtml::listData($ctype, 'company_type_id', 'company_type_name'); echo CHtml::checkBoxList('company_type', $testkey, $ctypelist, array('onChange' => 'javascript:hideshow(this.value,this.id)', 'required' => true)); ?> </td> </tr> <tr> <td align="right" style="text-align: right; display: none"> <label for='IsListProvider'><?php $clang->eT("IsListProvider : "); ?> </label> </td> <td style="display: none"> <?php echo CHtml::radioButtonList('IsListProvider', $mrw['is_list_provider'], array('1' => 'Yes', '0' => 'No'), array('separator' => ' '));
/** * Modify User POST */ function modcompany_type() { $clang = Yii::app()->lang; // old Details $company_type_id = (int) Yii::app()->request->getPost("company_type_id"); $company_type_name = flattenText(Yii::app()->request->getPost("company_type_name")); $IsActive = flattenText(Yii::app()->request->getPost("IsActive")); $IsTitle = flattenText(Yii::app()->request->getPost("IsTitle")); $company_type = flattenText(Yii::app()->request->getPost("company_type")); //New Name $c_type_name = flattenText(Yii::app()->request->getPost("c_type_name")); $addsummary = ''; $aViewUrls = array(); // update defult value $is_Active = $Is_Title = 0; if ($IsActive) { $is_Active = 1; } if ($IsTitle) { $Is_Title = 1; } $sresult = Company_type::model()->findAllByAttributes(array('company_type_id' => $company_type_id)); $sresultcount = count($sresult); if (Permission::model()->hasGlobalPermission('superadmin', 'read') || $sresultcount > 0 && Permission::model()->hasGlobalPermission('contacts', 'update')) { if ($c_type_name == '') { $aViewUrls['mboxwithredirect'][] = $this->_messageBoxWithRedirect($clang->gT("Editing Company Type"), $clang->gT("Could not modify Company Type."), "warningheader", $clang->gT("Company Type name not be empty."), $this->getController()->createUrl('admin/company_type/sa/modifycontact_group'), $clang->gT("Back"), array('company_type_id' => $company_type_id)); } elseif (Company_type::model()->findByAttributes(array('company_type_name' => $c_type_name, 'IsActive' => $is_Active, 'company_type' => $company_type, 'Istitle' => $Is_Title))) { $aViewUrls['message'] = array('title' => $clang->gT("Failed to Edit Company Type"), 'message' => $clang->gT("The Company Type already exists."), 'class' => 'warningheader'); } else { $oRecord = Company_type::model()->findByPk($company_type_id); $oRecord->company_type_name = $this->escape($c_type_name); $oRecord->company_type = $this->escape($company_type); $oRecord->Istitle = $this->escape($Is_Title); $oRecord->IsActive = $this->escape($is_Active); $uresult = $oRecord->save(); // store result of save in uresult if ($uresult) { // When saved successfully Yii::app()->setFlashMessage($clang->gT("Company Type updated successfully")); $this->getController()->redirect(array("admin/company_type/index")); } else { $aViewUrls['mboxwithredirect'][] = $this->_messageBoxWithRedirect($clang->gT("Editing contact type"), $clang->gT("Could not modify contact type."), 'warningheader'); } } } else { Yii::app()->setFlashMessage(Yii::app()->lang->gT("You do not have sufficient rights to access this page."), 'error'); $this->getController()->redirect(array("admin/index")); } $this->_renderWrappedTemplate('contacts/company_type', $aViewUrls); }