public function actionIndex() { $op = EnvUtil::getRequest("op"); $op = in_array($op, array("dept", "letter")) ? $op : "dept"; $params = array(); if ($op == "letter") { $params["datas"] = $this->getDataByLetter(); } else { $params["datas"] = $this->getDataByDept(); } $userDatas = array(); if (!empty($params["datas"])) { foreach ($params["datas"] as $datas) { $userDatas = $op == "dept" ? array_merge($userDatas, $datas["users"]) : array_merge($userDatas, $datas); } } $params["uids"] = implode(",", ConvertUtil::getSubByKey($userDatas, "uid")); $uid = Ibos::app()->user->uid; $params["cuids"] = Contact::model()->fetchAllConstantByUid($uid); $this->setPageTitle(Ibos::lang("Contact")); $this->setPageState("breadCrumbs", array(array("name" => Ibos::lang("Contact"), "url" => $this->createUrl("defalut/index")), array("name" => Ibos::lang("Company contact")))); $view = $op == "letter" ? "letter" : "dept"; $params["allLetters"] = $this->allLetters; $this->render($view, $params); }
public function actionIndex() { $criteriaContact = new CDbCriteria(); $criteriaContact->limit = 10; $criteriaContact->order = "id DESC"; $contact = Contact::model()->findAll($criteriaContact); $this->render('index', compact('contact')); }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Contact the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Contact::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function delete() { $status = parent::delete(); $inversed = Contact::model()->findByAttributes(array('user_id' => $this->contact_id, 'contact_id' => $this->user_id)); if ($inversed !== null) { $inversed->delete(); } return $status; }
public function init() { $eventHandler = array($this, 'deletePersonsOrAccountsItems'); Contact::model()->attachEventHandler('onAfterDelete', $eventHandler); $this->attachedEventHandlersIndexedByModelClassName['Contact'] = array('onAfterDelete', $eventHandler); User::model()->attachEventHandler('onAfterDelete', $eventHandler); $this->attachedEventHandlersIndexedByModelClassName['User'] = array('onAfterDelete', $eventHandler); Account::model()->attachEventHandler('onAfterDelete', $eventHandler); $this->attachedEventHandlersIndexedByModelClassName['Account'] = array('onAfterDelete', $eventHandler); }
/** * Collate the data and persist it to the table. * * @param $id * * @throws CHttpException * @throws Exception */ public function loadData($id) { $booking = Element_OphTrOperationbooking_Operation::model()->find('event_id=?', array($id)); $eye = Eye::model()->findByPk($booking->eye_id); if ($eye->name === 'Both') { throw new CHttpException(400, 'Can\'t display whiteboard for dual eye bookings'); } $eyeLabel = strtolower($eye->name); $event = Event::model()->findByPk($id); $episode = Episode::model()->findByPk($event->episode_id); $patient = Patient::model()->findByPk($episode->patient_id); $contact = Contact::model()->findByPk($patient->contact_id); $biometryCriteria = new CDbCriteria(); $biometryCriteria->addCondition('patient_id = :patient_id'); $biometryCriteria->params = array('patient_id' => $patient->id); $biometryCriteria->order = 'last_modified_date DESC'; $biometryCriteria->limit = 1; $biometry = Element_OphTrOperationnote_Biometry::model()->find($biometryCriteria); $examination = $event->getPreviousInEpisode(EventType::model()->findByAttributes(array('name' => 'Examination'))->id); //$management = new \OEModule\OphCiExamination\models\Element_OphCiExamination_Management(); //$anterior = new \OEModule\OphCiExamination\models\Element_OphCiExamination_AnteriorSegment(); $risks = new \OEModule\OphCiExamination\models\Element_OphCiExamination_HistoryRisk(); if ($examination) { //$management = $management->findByAttributes(array('event_id' => $examination->id)); //$anterior = $anterior->findByAttributes(array('event_id' => $examination->id)); $risks = $risks->findByAttributes(array('event_id' => $examination->id)); } $labResult = Element_OphInLabResults_Inr::model()->findPatientResultByType($patient->id, '1'); $allergies = Yii::app()->db->createCommand()->select('a.name as name')->from('patient_allergy_assignment pas')->leftJoin('allergy a', 'pas.allergy_id = a.id')->where("pas.patient_id = {$episode->patient_id}")->order('a.name')->queryAll(); $allergyString = 'None'; if ($allergies) { $allergyString = implode(',', array_column($allergies, 'name')); } $operation = Yii::app()->db->createCommand()->select('proc.term as term')->from('et_ophtroperationbooking_operation op')->leftJoin('ophtroperationbooking_operation_procedures_procedures opp', 'opp.element_id = op.id')->leftJoin('proc', 'opp.proc_id = proc.id')->where("op.event_id = {$id}")->queryAll(); $this->event_id = $id; $this->booking = $booking; $this->eye_id = $eye->id; $this->eye = $eye; $this->predicted_additional_equipment = $booking->special_equipment_details; $this->comments = ''; $this->patient_name = $contact['title'] . ' ' . $contact['first_name'] . ' ' . $contact['last_name']; $this->date_of_birth = $patient['dob']; $this->hos_num = $patient['hos_num']; $this->procedure = implode(',', array_column($operation, 'term')); $this->allergies = $allergyString; $this->iol_model = $biometry ? $biometry->attributes['lens_description_' . $eyeLabel] : 'Unknown'; $this->iol_power = $biometry ? $biometry->attributes['iol_power_' . $eyeLabel] : 'none'; $this->predicted_refractive_outcome = $biometry ? $biometry->attributes['predicted_refraction_' . $eyeLabel] : 'Unknown'; $this->alpha_blockers = $patient->hasRisk('Alpha blockers'); $this->anticoagulants = $patient->hasRisk('Anticoagulants'); $this->alpha_blocker_name = $risks ? $risks->alpha_blocker_name : ''; $this->anticoagulant_name = $risks ? $risks->anticoagulant_name : ''; $this->inr = $labResult ? $labResult : 'None'; $this->save(); }
public function actionDelete() { $contact = Contact::model()->findByAttributes(array('user_id' => Yii::app()->getUser()->getId(), 'contact_id' => Yii::app()->getRequest()->getParam('id'))); if ($contact !== null) { $userLink = $contact->contact->getUrl(); $contact->delete(); $this->redirect($userLink); } else { throw new CHttpException(404, Yii::t('application', 'Write error message here')); } }
public function actionGetContentByID($id) { $arr = explode(",", $id); $id = $arr[count($arr) - 1]; $model = Contact::model()->findByPk($id); $data = array(); $data[0] = $model->content; $data[1] = $model->title; $data[2] = $model->address; echo json_encode($data); }
public function beforeDelete() { $contactgroup = Contact::model()->findAll(); foreach ($contactgroup as $id => $item) { $contactgroups = explode('|', $item->contact_group_id); if (in_array($this->contact_group_id, array_values($contactgroups))) { Yii::app()->setFlashMessage('Can not delete these, Contact Group, it is used in contact master', 'error'); return false; } } return parent::beforeDelete(); }
public function beforeDelete() { $suppliers = Contact::model()->findAll(); foreach ($suppliers as $id => $item) { $vehicles = explode('|', $item->city_id); if (in_array($this->city_id, array_values($vehicles))) { Yii::app()->setFlashMessage('Can not delete, City in use in contact master', 'error'); return false; } } return parent::beforeDelete(); }
public function actionExportCsv() { $model = new Contact('search'); $model->unsetAttributes(); if (isset($_GET['Contact'])) { $model->attributes = $_GET['Contact']; } if (isset($_SESSION['criteria']) && $_SESSION['criteria'] != null && $_SESSION['criteria'] instanceof EMongoCriteria) { $criteria = $_SESSION['criteria']; } else { $criteria = new EMongoCriteria(); } $models = Contact::model()->findAll($criteria); $listAttributes = array(); foreach ($models as $model) { //récuperation de la liste totale des attributs foreach ($model->attributes as $attributeName => $attributeValue) { $listAttributes[$attributeName] = $attributeName; } } $dataProvider = array(); //creation du dataprovider foreach ($models as $model) { $datas = array(); foreach ($listAttributes as $attribute) { if (isset($model->{$attribute})) { if (!is_object($model->{$attribute})) { $datas[$attribute] = $model->{$attribute}; } } else { $datas[$attribute] = ""; } } //create full adress $datas['fullAddress'] = $model->fullAddress; //create biobank $datas['fullAddress'] = $model->biobankName; $dataProvider[] = $datas; } $filename = 'biobanks_list.csv'; $csv = new ECSVExport($dataProvider); $toExclude = array(); $toExport = $model->attributeExportedLabels(); foreach ($model->attributes as $attribute => $value) { if (!isset($toExport[$attribute])) { $toExclude[] = $attribute; } } $csv->setExclude($toExclude); // $csv->exportCurrentPageOnly(); Yii::app()->getRequest()->sendFile($filename, $csv->toCSV(), "text/csv", false); }
public function actionIndex() { $uid = Ibos::app()->user->uid; $cuids = Contact::model()->fetchAllConstantByUid($uid); $res = UserUtil::getUserByPy($cuids); $group = ContactUtil::handleLetterGroup($res); $userDatas = array(); foreach ($group as $users) { $userDatas = array_merge($userDatas, $users); } $params = array("datas" => $group, "letters" => array_keys($group), "allLetters" => $this->allLetters, "uids" => implode(",", ConvertUtil::getSubByKey($userDatas, "uid"))); $this->setPageTitle(Ibos::lang("Regular contact")); $this->setPageState("breadCrumbs", array(array("name" => Ibos::lang("Contact"), "url" => $this->createUrl("default/index")), array("name" => Ibos::lang("Regular contact")))); $this->render("index", $params); }
public function run($args) { //uppar case for each last name of contact $criteria = new EMongoCriteria(); $criteria->sort('last_name', EMongoCriteria::SORT_ASC); $contacts = Contact::model()->findAll($criteria); foreach ($contacts as $model) { $town = $model->ville; $postalCode = $this->getPostalCode($town); if ($postalCode != null) { try { $model->code_postal = $postalCode; $model->update(); } catch (Exception $e) { echo 'Exception reçue pour le model: ' . $model->ville, $e->getMessage(), "\n"; } } } }
public function run($args) { //uppar case for each last name of contact $criteria = new EMongoCriteria(); $criteria->sort('last_name', EMongoCriteria::SORT_ASC); $contacts = Contact::model()->findAll($criteria); foreach ($contacts as $model) { //last name to upper case automatically /prevent pb to sort and display // echo $model->_id."\n"; $model->last_name = mb_strtoupper($model->last_name, "UTF-8"); //convertie first name en lower case et mettant les caracteres en utf-8 ( cas possible de bug sur chaines mixtes) $model->first_name = mb_strtolower($model->first_name, "UTF-8"); //phone without withespace, point a 0> +33 $model->phone = mb_ereg_replace('/\\s+/', '', $model->phone); $model->phone = mb_ereg_replace('/\\./', '', $model->phone); //replace first zero and add +33 $model->phone = mb_ereg_replace('/^0/', '+33', $model->phone); //pays = FR $model->pays = "FR"; $model->inactive = 0; //catch exception on update if problem ( utf8 encoding for example?) try { $model->update(); } catch (Exception $e) { echo 'Exception reçue pour le model: ' . $model->_id . " " . $model->last_name . " " . $model->first_name, $e->getMessage(), "\n"; //detection de le ncodage si pb d estring echo "first name encoding :" . mb_detect_encoding($model->first_name) . "\n"; } } //update relation biobank->contact_id if old id contact, si ancien attribut id utilisé alors on mets le nouvel attribut _id $criteriaB = new EMongoCriteria(); $criteriaB->sort('name', EMongoCriteria::SORT_ASC); $biobanks = Biobank::model()->findAll($criteriaB); foreach ($biobanks as $biobank) { $contact = Contact::model()->findByAttributes(array('id' => $biobank->contact_id)); if ($contact != null) { // echo "current value from migration:" . $contact->last_name . " " . $contact->first_name."\n"; $biobank->contact_id = $contact->_id; $biobank->update(); } } }
protected function validateAttribute($object, $attribute) { $criteria = array('condition' => ''); if (false !== strpos($attribute, "+")) { $attributes = explode("+", $attribute); } else { $attributes = array($attribute); } $where = ""; foreach ($attributes as $key => $attribute) { $where .= $attribute . "='" . $object->{$attribute} . "'"; if (array_key_exists($key + 1, $attributes)) { $where .= ' AND '; } } $exists = Contact::model()->find($where); if (!empty($exists)) { $this->addError($object, $attributes[0], $this->message); } }
public function actionDeleteContactLabel() { if (!($contactlabel = ContactLabel::model()->findByPk(@$_POST['contact_label_id']))) { throw new Exception("ContactLabel not found: " . @$_POST['contact_label_id']); } $count = Contact::model()->count('contact_label_id=?', array($contactlabel->id)); if ($count == 0) { if (!$contactlabel->delete()) { throw new Exception("Unable to delete ContactLabel: " . print_r($contactlabel->getErrors(), true)); } Audit::add('admin-ContactLabel', 'delete', @$_POST['contact_label_id']); } echo $count; }
public function actionMarkread($id) { $contactModel = Contact::model(); $contactModel = $contactModel->findByPk($id); $contactModel->isread = 1; $contactModel->save(false); $this->redirect(array('admin/message', 'm' => 2)); }
public function afterDelete($event) { if ($this->owner->contact_id && get_class($this->owner) != 'ContactLocation') { Address::model()->deleteAll('contact_id = :contact_id', array(':contact_id' => $this->owner->contact_id)); Contact::model()->deleteByPk($this->owner->contact_id); } parent::afterDelete($event); }
function modproject() { $clang = Yii::app()->lang; if (!Permission::model()->hasGlobalPermission('superadmin', 'read') || !Permission::model()->hasGlobalPermission('projects', 'update')) { Yii::app()->setFlashMessage($clang->gT("You do not have sufficient rights to access page."), 'error'); $this->getController()->redirect(array("admin/index")); } $action = isset($_GET['action']) ? $_GET['action'] : ''; if ($action == "editproject") { if ($_POST['submit'] == "Clone") { // Project details $project_name = "Clone-" . flattenText($_POST['project_name'], false, true, 'UTF-8', true); $project_friendly_name = flattenText($_POST['project_friendly_name'], false, true, 'UTF-8', true); $parent_project = (int) Yii::app()->request->getPost("parent_project"); $client = (int) Yii::app()->request->getPost("client"); $client_contact = (int) Yii::app()->request->getPost("client_contact"); $project_manager = (int) Yii::app()->request->getPost("project_manager"); $sales_person = (int) Yii::app()->request->getPost("sales_person"); $country = (int) Yii::app()->request->getPost("country"); $quota = flattenText($_POST['quota'], false, true, 'UTF-8', true); $maxcompletes = flattenText($_POST['maxcompletes'], false, true, 'UTF-8', true); if ($maxcompletes == 'percent0') { $QuotaBufferAmnt = $quota; } if ($maxcompletes == 'percent10') { $QuotaBufferAmnt = $quota + $quota * 0.1; } if ($maxcompletes == 'percent50') { $QuotaBufferAmnt = $quota + $quota * 0.5; } if ($maxcompletes == 'percent100') { $QuotaBufferAmnt = $quota * 2; } if ($maxcompletes == 'infinite') { $QuotaBufferAmnt = 0; } $cpc = flattenText($_POST['cpc'], false, true, 'UTF-8', true); $los = flattenText($_POST['los'], false, true, 'UTF-8', true); $ir = flattenText($_POST['ir'], false, true, 'UTF-8', true); $points = flattenText($_POST['points'], false, true, 'UTF-8', true); $surveylink = flattenText($_POST['surveylink'], false, true, 'UTF-8', true); $notes = flattenText($_POST['notes'], false, true, 'UTF-8', true); $status = (int) getGlobalSetting('project_status_test'); //$status = (int) Yii::app()->request->getPost("status"); $RIDCheck = "Yes"; $result = Yii::app()->db->createCommand("SELECT count(*) AS cnt FROM {{contact_master}} WHERE \n contact_id = '{$client}' AND RIDCheck = 'Yes'")->queryRow(); if ($result['cnt'] <= 0) { $RIDCheck = "No"; } $internal_company = getGlobalSetting('Own_Panel'); $CPC = $points / 100; $current_datetime = date('y-m-d h:i:s'); $int_cmp = Contact::model()->findAll(array('condition' => 'contact_id = ' . $internal_company)); $completed_link = $int_cmp[0]['completionlink']; $disqualify_link = $int_cmp[0]['disqualifylink']; $quotafull_link = $int_cmp[0]['quatafulllink']; if ($project_name == '') { $aViewUrls['message'] = array('title' => $clang->gT("Failed to add Project"), 'message' => $clang->gT("A Project Name was not supplied or the Project Name is invalid."), 'class' => 'warningheader'); } else { $NewProject = Project::model()->instProject($project_name, $project_friendly_name, $parent_project, $client, $client_contact, $project_manager, $sales_person, $country, $quota, $QuotaBufferAmnt, $RIDCheck, $cpc, $los, $ir, $points, $surveylink, $notes, $status); if ($NewProject) { // create own panel $newvendor = Project_vendor::model()->instvendor($NewProject, $internal_company, $internal_company, $status, 'Own Panel', $CPC, $quota, $QuotaBufferAmnt, $completed_link, $disqualify_link, $quotafull_link, '0', $current_datetime); $sql = "INSERT INTO {{project_master_vendors}} \n (project_id,vendor_id,vendor_contact_id,vendor_status_id,notes,CPC,required_completes\n ,QuotaBuffer_Completes, completed_link,disQualified_link,QuotaFull_URL,max_redirects\n ,created_datetime)\n VALUES('{$NewProject}','{$internal_company}','{$internal_company}','{$status}','Own Panel'\n ,'{$CPC}','{$quota}','{$QuotaBufferAmnt}','{$completed_link}','{$disqualify_link}'\n ,'{$quotafull_link}','0','{$current_datetime}')"; //$result = Yii::app()->db->createCommand($sql)->query(); $loginuser = Yii::app()->session['user']; // Update Message Table $query = 'INSERT INTO {{messages}} (type_id, body, receipid, chainid, created ) VALUES (10,"Created by ' . $loginuser . '",0,"' . $NewProject . '", "' . $current_datetime . '")'; $result = Yii::app()->db->createCommand($query)->query(); Yii::app()->setFlashMessage($clang->gT("Project Cloned successfully")); $this->getController()->redirect(array("admin/project/index")); } } } else { $project_id = (int) Yii::app()->request->getPost("project_id"); $project_name = flattenText($_POST['project_name'], false, true, 'UTF-8', true); $project_friendly_name = flattenText($_POST['project_friendly_name'], false, true, 'UTF-8', true); $parent_project = (int) Yii::app()->request->getPost("parent_project"); $client = (int) Yii::app()->request->getPost("client"); $client_contact = (int) Yii::app()->request->getPost("client_contact"); $project_manager = (int) Yii::app()->request->getPost("project_manager"); $sales_person = (int) Yii::app()->request->getPost("sales_person"); $country = (int) Yii::app()->request->getPost("country"); $quota = flattenText($_POST['quota'], false, true, 'UTF-8', true); $maxcompletes = flattenText($_POST['maxcompletes'], false, true, 'UTF-8', true); if ($maxcompletes == 'percent0') { $QuotaBufferAmnt = $quota; } if ($maxcompletes == 'percent10') { $QuotaBufferAmnt = $quota + $quota * 0.1; } if ($maxcompletes == 'percent50') { $QuotaBufferAmnt = $quota + $quota * 0.5; } if ($maxcompletes == 'percent100') { $QuotaBufferAmnt = $quota * 2; } if ($maxcompletes == 'infinite') { $QuotaBufferAmnt = 0; } $cpc = flattenText($_POST['cpc'], false, true, 'UTF-8', true); $los = flattenText($_POST['los'], false, true, 'UTF-8', true); $ir = flattenText($_POST['ir'], false, true, 'UTF-8', true); $points = flattenText($_POST['points'], false, true, 'UTF-8', true); $surveylink = flattenText($_POST['surveylink'], false, true, 'UTF-8', true); $notes = flattenText($_POST['notes'], false, true, 'UTF-8', true); $status = (int) Yii::app()->request->getPost("status"); $old_status = (int) Yii::app()->request->getPost("old_status"); //$RIDCheck = flattenText($_POST['RIDCheck'], false, true, 'UTF-8', true); $internal_company = getGlobalSetting('Own_Panel'); $CPC = $points / 100; $current_datetime = date('y-m-d h:i:s'); $int_cmp = Contact::model()->findAll(array('condition' => 'contact_id = ' . $internal_company)); $completed_link = $int_cmp[0]['completionlink']; $disqualify_link = $int_cmp[0]['disqualifylink']; $quotafull_link = $int_cmp[0]['quatafulllink']; if (Permission::model()->hasGlobalPermission('superadmin', 'read') || Permission::model()->hasGlobalPermission('projects', 'update')) { if ($project_name == '') { $aViewUrls['message'] = array('title' => $clang->gT("Failed to edit Project"), 'message' => $clang->gT("A Project Name was not supplied or the Project Name is invalid."), 'class' => 'warningheader'); } elseif (Project::model()->findByAttributes(array('project_name' => $project_name), 'project_id !=' . $project_id . '')) { $aViewUrls['message'] = array('title' => $clang->gT("Failed to add Project"), 'message' => $clang->gT("The Project Name already exists."), 'class' => 'warningheader'); } else { $oRecord = Project::model()->findByPk($project_id); $oRecord->project_name = $project_name; $oRecord->friendly_name = $project_friendly_name; $oRecord->parent_project_id = $parent_project; $oRecord->client_id = $client; $oRecord->contact_id = $client_contact; $oRecord->manager_user_id = $project_manager; $oRecord->sales_user_id = $sales_person; $oRecord->country_id = $country; $oRecord->required_completes = $quota; $oRecord->QuotaBuffer_Completes = $QuotaBufferAmnt; $oRecord->CPC = $cpc; $oRecord->IR = $ir; $oRecord->expected_los = $los; $oRecord->reward_points = $points; $oRecord->client_link = $surveylink; $oRecord->notes = $notes; //$oRecord->RIDCheck = $RIDCheck; $oRecord->project_status_id = $status; if (isset($_POST['cleanedup'])) { $oRecord->cleanedup = $_POST['cleanedup']; } if ($status == getGlobalSetting('project_status_closed')) { $oRecord->closed = $current_datetime; } $EditContact = $oRecord->save(); if ($EditContact) { // When saved successfully //update cpc of project $internal_company_id = getGlobalSetting('Own_Panel'); $sql = "UPDATE {{project_master_vendors}} SET CPC = '{$CPC}' \n WHERE project_id = '{$project_id}' and vendor_id = '{$internal_company_id}' and vendor_contact_id = '{$internal_company_id}'"; $result = Yii::app()->db->createCommand($sql)->query(); $loginuser = Yii::app()->session['user']; // update message table $query = 'INSERT INTO {{messages}} (type_id, body, receipid, chainid, created ) VALUES (10,"Information updated By ' . $loginuser . '","0","' . $project_id . '", "' . $current_datetime . '")'; $result = Yii::app()->db->createCommand($query)->query(); // if status is change if ($old_status != $status) { $sql = "SELECT status_name FROM {{project_status_master}} WHERE status_id = {$status}"; $result = Yii::app()->db->createCommand($sql)->queryRow(); $status_name = $result['status_name']; $query = 'INSERT INTO {{messages}} (type_id, body, receipid, chainid, created ) VALUES (10,"Project status changed to ' . $status_name . ' by ' . $loginuser . '",0,"' . $project_id . '"," ' . $current_datetime . '" )'; $result = Yii::app()->db->createCommand($query)->query(); } Yii::app()->setFlashMessage($clang->gT("Project updated successfully")); $this->getController()->redirect(array("admin/project/sa/modifyproject/project_id/" . $project_id . "/action/modifyproject")); } 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->getController()->redirect(array("admin/index")); } } } elseif ($action == "editvendor") { $project_id = (int) Yii::app()->request->getPost("project_id"); $vendor_project_id = (int) Yii::app()->request->getPost("vendor_project_id"); $vendor_id = (int) Yii::app()->request->getPost("panel"); $vendor_contact = (int) Yii::app()->request->getPost("vendor_contact"); $cpc = flattenText($_POST['cpc'], false, true, 'UTF-8', true); $maxredirects = flattenText($_POST['maxredirects'], false, true, 'UTF-8', true); $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); $quota = flattenText($_POST['quota'], false, true, 'UTF-8', true); $current_datetime = date('y-m-d h:i:s'); $maxcompletes = flattenText($_POST['maxcompletes'], false, true, 'UTF-8', true); if ($maxcompletes == 'percent0') { $QuotaBufferAmnt = $quota; } if ($maxcompletes == 'percent10') { $QuotaBufferAmnt = $quota + $quota * 0.1; } if ($maxcompletes == 'percent50') { $QuotaBufferAmnt = $quota + $quota * 0.5; } if ($maxcompletes == 'percent100') { $QuotaBufferAmnt = $quota * 2; } if ($maxcompletes == 'infinite') { $QuotaBufferAmnt = 0; } $notes = flattenText($_POST['notes'], false, true, 'UTF-8', true); $status = (int) Yii::app()->request->getPost("status"); $AskOnRedirect = ""; if (isset($_POST['askEmail'])) { $AskOnRedirect .= 'Email'; } if (isset($_POST['askZip'])) { $AskOnRedirect .= 'Zip'; } if (isset($_POST['askAge'])) { $AskOnRedirect .= 'Age'; } if (isset($_POST['askGender'])) { $AskOnRedirect .= 'Gender'; } $oRecord = Project_vendor::model()->findByPk($vendor_project_id); $oRecord->vendor_id = $vendor_id; $oRecord->vendor_contact_id = $vendor_contact; $oRecord->vendor_status_id = $status; $oRecord->notes = $notes; $oRecord->CPC = $cpc; $oRecord->required_completes = $quota; $oRecord->QuotaBuffer_Completes = $QuotaBufferAmnt; $oRecord->completed_link = $completionlink; $oRecord->disQualified_link = $disqualifylink; $oRecord->QuotaFull_URL = $quatafulllink; $oRecord->max_redirects = $maxredirects; $oRecord->AskOnRedirect = $AskOnRedirect; $oRecord->created_datetime = $current_datetime; $EditContact = $oRecord->save(); $sql = "UPDATE {{project_master_vendors}}\n SET\n vendor_id = '{$vendor_id}' , \n vendor_contact_id = '{$vendor_contact}' , \n vendor_status_id = '{$status}' , \n notes = '{$notes}' , \n CPC = '{$cpc}' , \n required_completes = '{$quota}' , \n QuotaBuffer_Completes = '{$QuotaBufferAmnt}' , \n completed_link = '{$completionlink}' , \n disQualified_link = '{$disqualifylink}' , \n QuotaFull_URL = '{$quatafulllink}' , \n max_redirects = '{$maxredirects}' , \n AskOnRedirect = '{$AskOnRedirect}' , \n created_datetime = '{$current_datetime}'\n WHERE\n vendor_project_id = '{$vendor_project_id}'"; //$result = Yii::app()->db->createCommand($sql)->query(); Yii::app()->setFlashMessage($clang->gT("Vendor updated successfully")); $this->getController()->redirect(array("admin/project/sa/modifyproject/project_id/{$project_id}/action/modifyproject")); exit; } else { Yii::app()->setFlashMessage(Yii::app()->lang->gT("You do not have sufficient rights to access this page."), 'error'); } $aViewUrls = array(); $this->_renderWrappedTemplate('projects', $aViewUrls); }
public static function areContacts($userId, $contactId) { $contact = Contact::model()->findBySql("SELECT l.* \n\t\t\tFROM contact AS l INNER JOIN contact as r ON (l.user_id=r.contact_id AND l.contact_id=r.user_id) \n\t\t\tWHERE l.user_id=:user_id AND l.contact_id=:contact_id\n\t\t", array(':user_id' => $userId, ':contact_id' => $contactId)); return $contact !== null; }
$("#Order_contact_id").children().remove(); $("#Order_contact_id").append( new Option("Seleccionar")); $("#Order_payment_type_id > option[value=]").attr("selected","selected"); }'))); ?> <?php echo $form->error($model, 'customer_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'contact_id'); ?> <?php echo $form->dropDownList($model, 'contact_id', CHtml::listData(Contact::model()->findAll(array('with' => array('customer'), 'condition' => 't.active = 1 AND customer.id = :customer_id', 'order' => 't.name', 'params' => array(':customer_id' => $model->customer_id))), 'id', 'name'), array('prompt' => 'Seleccionar')); ?> <?php echo $form->error($model, 'contact_id'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'receptionist_user_id'); ?> <?php echo $form->dropDownList($model, 'receptionist_user_id', CHtml::listData(User::model()->findAll(array('with' => array('roles'), 'condition' => 'role_id = 3 AND t.active = 1', 'order' => 't.name')), 'id', 'fullName'), array('prompt' => 'Seleccionar')); ?> <?php echo $form->error($model, 'receptionist_user_id');
protected function changeConstant() { $uid = Ibos::app()->user->uid; $cuid = intval(EnvUtil::getRequest("cuid")); $status = EnvUtil::getRequest("status"); if ($status == "mark") { Contact::model()->addConstant($uid, $cuid); } elseif ($status == "unmark") { Contact::model()->deleteConstant($uid, $cuid); } $this->ajaxReturn(array("isSuccess" => true)); }
<th>Subject</th> <th>Body</th> <th>Date</th> </thead> <div class ="text-center"> hello you are in the inbox </div> <div class="text-center" > <?php $model = new Contact(); $row = Contact::model()->findAll(); foreach ($row as $value) { Yii::app()->user->setState('subject', $value->subject); Yii::app()->user->setState('email', $value->email); echo "\n\t\t\n\t\t\t\n\n\t\t\t\t<tbody>\n\t\t\t\t\n\t\t\t\t\t<td>{$value->name}</td>\n\t\t\t\t\t<td>{$value->email}</td>\n\t\t\t\t\t\t<td>{$value->subject}</td>\n\t\t\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t<td>{$value->body}</td>\n\t\t\t\t\t<td>{$value->date}</td>\n \n\n\t\t\t\t</tbody>\n\t\t\t\t\t"; echo '<td>'; echo CHtml::link('<button class="btn btn-primary" type="submit">delete</button>', array('site/delete')); echo '</td>'; echo '<td>'; echo CHtml::link('<button class="btn btn-danger" type="submit">reply</button>', array('site/reply')); echo '</td>'; } ?> <table> </body>
public function actionEditContact() { if (!($patient = Patient::model()->findByPk(@$_POST['patient_id']))) { throw new Exception("Patient not found: " . @$_POST['patient_id']); } if (!($contact = Contact::model()->findByPk(@$_POST['contact_id']))) { throw new Exception("Contact not found: " . @$_POST['contact_id']); } if (@$_POST['site_id']) { if (!($site = Site::model()->findByPk(@$_POST['site_id']))) { throw new Exception("Site not found: " . @$_POST['site_id']); } if (!($cl = ContactLocation::model()->find('contact_id=? and site_id=?', array($contact->id, $site->id)))) { $cl = new ContactLocation(); $cl->contact_id = $contact->id; $cl->site_id = $site->id; if (!$cl->save()) { throw new Exception("Unable to save contact location: " . print_r($cl->getErrors(), true)); } } } else { if (!($institution = Institution::model()->findByPk(@$_POST['institution_id']))) { throw new Exception("Institution not found: " . @$_POST['institution_id']); } if (!($cl = ContactLocation::model()->find('contact_id=? and institution_id=?', array($contact->id, $institution->id)))) { $cl = new ContactLocation(); $cl->contact_id = $contact->id; $cl->institution_id = $institution->id; if (!$cl->save()) { throw new Exception("Unable to save contact location: " . print_r($cl->getErrors(), true)); } } } if (!($pca = PatientContactAssignment::model()->findByPk(@$_POST['pca_id']))) { throw new Exception("PCA not found: " . @$_POST['pca_id']); } $pca->location_id = $cl->id; if (!$pca->save()) { throw new Exception("Unable to save patient contact assignment: " . print_r($pca->getErrors(), true)); } $this->redirect(array('/patient/view/' . $patient->id)); }
/** * Envoie une demande aux contacts des biobanques concernées par une demande */ public function actionEnvoyer() { if (isset($_GET['demande_id'])) { $demande = $this->loadModel($_GET['demande_id']); if (!empty($demande->titre) && !empty($demande->detail) && !empty($demande->sampleList)) { $samples = $demande->getArraySamples(); $biobankIdList = $demande->getBiobanksFromSamples($samples); $demandeSent = false; foreach ($biobankIdList as $biobankId) { $biobank = Biobank::model()->findByPk(new MongoId($biobankId)); if ($biobank->contact_id != null) { $contact = Contact::model()->findByPk(new MongoId($biobank->contact_id)); if ($contact != null) { $concernSamplesList = array(); foreach ($samples as $sample) { if ($sample->biobank_id == $biobankId) { $concernSamplesList[] = $sample; } } // PB si pas envoyer a une biuobank alors pas sauvegarder if (CommonMailer::sendDemande($contact, $demande->titre . ' : ' . $biobank->identifier, $demande->detail, $concernSamplesList) == 1) { $demandeSent = true; } } else { } } } if ($demandeSent) { $demande->envoi = 1; $demande->save(); $this->actionCreateNewDemand(); Yii::app()->user->setFlash('success', 'Votre demande a bien été envoyée aux différents sites'); $this->render('view', array_merge(array('model' => $this->loadModel($demande->_id), isset($_GET['layout']) || isset($layout) && $layout != null ? array('layout' => $_GET['layout']) : array()))); } else { Yii::app()->user->setFlash('error', 'Un problème est apparu, les demandes n\'ont pas été transmises'); $this->redirect(array_merge(array('updateAndSend', 'id' => Yii::app()->session['activeDemand'][0]->_id), isset($_GET['layout']) ? array('layout' => $_GET['layout']) : array())); // } } else { Yii::app()->user->setFlash('notice', 'Merci de completer votre demande avant de l\'envoyer'); $this->redirect(array_merge(array('updateAndSend', 'id' => $demande->_id), isset($_GET['layout']) ? array('layout' => $_GET['layout']) : array())); // } } }
public function actionLostpassword() { $contact = Contact::model()->findByAttributes(array('email' => $_POST['email'], 'parent_model' => 'Customer')); if ($contact == null && $contact == '') { echo CJSON::encode($this->statusError('Email not valid')); Yii::app()->end(); } $customer = Customer::model()->findByPk($contact->parent_id); $customer->key = Yii::app()->hasher->hashPassword(time() . $contact->email); if ($customer->update()) { echo CJSON::encode($this->statusSuccess($customer)); } }
$parent_project = Project::model()->findAll(array('condition' => "parent_project_id = '0'")); $parent_project_list = CHtml::listData($parent_project, 'project_id', 'project_name'); echo CHtml::dropDownList('parent_project', '', $parent_project_list, array('prompt' => 'Select Parent Project')); ?> </td> </tr> <tr> <td style="text-align: right;"> <label for='client'><?php $clang->eT("Client : "); ?> </label> </td> <td> <?php $company = Contact::model()->findAll(array('condition' => "contact_type_id = '1'")); $company_list = CHtml::listData($company, 'contact_id', 'company_name'); echo CHtml::dropDownList('client', '', $company_list, array('prompt' => 'Select Client', 'ajax' => array('type' => 'POST', 'data' => array('client_id' => 'js:this.value'), 'url' => CController::createUrl('admin/project/sa/selectclientcontact'), 'update' => '#client_contact'), 'required' => true)); ?> </td> <td style="text-align: right;"> <label for='client_contact'><?php $clang->eT("Client Contact : "); ?> </label> </td> <td> <?php echo CHtml::dropDownList('client_contact', '', array(), array('prompt' => 'Select Contact', 'required' => true)); ?> </td>
if (is_object($model->{$attName})) { foreach ($model->{$attName}->attributeNames() as $emAtt) { $count++; if ($count % 2 == 0) { echo ' <td>'; } else { echo '<tr><td width="400px">'; } ?> <?php echo $form->labelEx($model->{$attName}, $emAtt); ?> <?php if ($emAtt == "country") { echo $form->dropDownList($model->{$attName}, $emAtt, Contact::model()->getArrayCountries()); } else { echo $form->textField($model->{$attName}, $emAtt); } ?> <?php echo $form->error($model->{$attName}, $emAtt); } } else { ?> <?php echo $form->labelEx($model, $attName); ?> <?php echo $form->textField($model, $attName);
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = Contact::model()->findByPk((int) $id); if ($model === null) { throw new CHttpException(404, 'Запрашиваемая страница не существует.'); } return $model; }
public static function arrQuestionPracivnuk() { $pracivnuk_id = Pracivnuku::getIdPracivnuk(Yii::app()->user->name); return Contact::model()->findAll("pracivnuk_id='{$pracivnuk_id}'"); }