public function actionTranslate()
{
$sqlsm = "";
$sqlm = "";
$i = 0;
$authorities = Authority::model()->findAll();
foreach ($authorities as $r) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'authorities','authority_" . htmlentities($r->id, ENT_QUOTES, 'UTF-8') . "_charge');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($r->charge, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$numbers = Numbers::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 34;
foreach ($numbers as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'numbers','numbers_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_field');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->field, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$services = Service::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 68;
foreach ($services as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'services','services_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'services','services_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$modules = Module::model()->findAll();
$sqlsm = "";
$sqlm = "";
foreach ($modules as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'services','module_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'services','module_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$departments = Department::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 157;
foreach ($departments as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'departments','department_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$specialities = Speciality::model()->findAll();
$sqlsm = "";
$sqlm = "";
foreach ($specialities as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'departments','speciality_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_name');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->name, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$news = News::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 229;
foreach ($news as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'news','news_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_title');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'news','news_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$doctors = Doctor::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 406;
foreach ($doctors as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'doctors','doctor_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_specialty');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->specialism, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'doctors','doctor_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_fellowship');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->fellowship, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'doctors','doctor_" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_interests');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->interests, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
echo "<br/>";
$sqlm = "";
$con = mysqli_connect("166.63.0.204", "webcont_dba", "lN_Q*PR]FN[E", "webcont_hm");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con, "SELECT id_mdc, especialidad_mdc, fellowship_mdc, intereses_mdc FROM medicos");
$j = 406;
while ($row = mysqli_fetch_array($result)) {
$sqlm .= "update `Message` set translation='" . $row['fellowship_mdc'] . "' where id=" . $j++ . " and language='en';<br>";
$sqlm .= "update `Message` set translation='" . $row['especialidad_mdc'] . "' where id=" . $j++ . " and language='en';<br>";
$sqlm .= "update `Message` set translation='" . $row['intereses_mdc'] . "' where id=" . $j++ . " and language='en';<br>";
}
mysqli_close($con);
echo $sqlm;
echo "<br/>";
$firstaids = FirstAid::model()->findAll();
$sqlsm = "";
$sqlm = "";
$i = 1263;
foreach ($firstaids as $s) {
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'firstaid','" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_title');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->title, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
$sqlsm .= "insert into `SourceMessage` values (" . $i . ",'firstaid','" . htmlentities($s->id, ENT_QUOTES, 'UTF-8') . "_description');<br>";
$sqlm .= "insert into `Message` values (" . $i . ",'es','" . htmlentities($s->description, ENT_QUOTES, 'UTF-8') . "');<br>";
$sqlm .= "insert into `Message` values (" . $i++ . ",'en','');<br>";
}
echo $sqlsm;
echo $sqlm;
}
/**
* Ajax request
* validate number
*/
public function actionCheckNumber()
{
$data = array();
$request = Yii::app()->request;
if ($request->isAjaxRequest) {
$number = $request->getPost('number');
$countNumber = Numbers::model()->countByAttributes(array('pnumber' => $number));
if ($countNumber == 0) {
$data['message'] = 'Wrong number';
$data['status'] = 0;
} else {
$data['status'] = 1;
}
echo json_encode($data);
} else {
throw new CHttpException(404, 'The requested page does not exist.');
break;
}
// $request->isAjaxRequest
}
public function searchByPhone($phone)
{
$model = Numbers::model()->findByAttributes(array('phone' => $phone));
if ($model === null) {
throw new CHttpException('Phone was not found.');
}
return $model;
}
