/**
* Remove the specified Speciality from storage.
*
* @param int $id
* @return Response
*/
public function destroy()
{
$id = Input::all()['id'];
$Speciality = Speciality::findOrFail($id);
$Speciality->delete();
return Response::json(array('status' => true, 'id_speciality' => $id));
}
public function run()
{
Speciality::create(['name' => 'Angiologia']);
Speciality::create(['name' => 'Cardiologia']);
Speciality::create(['name' => 'Cirugia Cardiovascular']);
Speciality::create(['name' => 'Cirugia General']);
Speciality::create(['name' => 'Cirugia Oncologia']);
Speciality::create(['name' => 'Cirugia Pediatrica']);
Speciality::create(['name' => 'Cirugia Plastica']);
Speciality::create(['name' => 'Dermatologia']);
Speciality::create(['name' => 'Gastroenterologia']);
Speciality::create(['name' => 'Gineco-obstericia']);
Speciality::create(['name' => 'Infectologia']);
Speciality::create(['name' => 'Infecto Pediatria']);
Speciality::create(['name' => 'Medicina Critica']);
Speciality::create(['name' => 'Medicina Interna']);
Speciality::create(['name' => 'Nefrologia']);
Speciality::create(['name' => 'Neumologia']);
Speciality::create(['name' => 'Neurocirugia']);
Speciality::create(['name' => 'Neurologia']);
Speciality::create(['name' => 'Oftalmologia']);
Speciality::create(['name' => 'Otorrinolaringologia']);
Speciality::create(['name' => 'Pediatria']);
Speciality::create(['name' => 'Proctologia']);
Speciality::create(['name' => 'Reumatologia']);
Speciality::create(['name' => 'Traumatologia']);
Speciality::create(['name' => 'Urologia']);
}
public function run()
{
DB::table('speciality')->truncate();
/**
* Tipos de examen
*/
$specialityList = [["name" => 'Ginecología']];
foreach ($specialityList as $speciality) {
Speciality::create($speciality);
}
}
public function initialLoad()
{
$advertisings = Advertising::orderBy('order', 'asc')->get();
$budgets = Budget::orderBy('order', 'asc')->get();
$doctors = Doctor::with('speciality')->get();
$nav_menus = NavigationMenu::orderBy('order', 'asc')->get();
$promos = Promo::all();
$services = Service::orderBy('order', 'asc')->get();
$slider_images = SliderImage::all();
$specialities = Speciality::all();
return View::make('layouts.main', array('advertisings' => $advertisings, 'budgets' => $budgets, 'doctors' => $doctors, 'nav_menus' => $nav_menus, 'promos' => $promos, 'services' => $services, 'slider_images' => $slider_images, 'specialities' => $specialities));
}
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;
}
</script>
</head>
<body>
<!-- HEADER - MENU -->
<?php
$departments = Department::model()->findAllbyattributes(array('status' => 'ACTIVE'));
$search = new Doctor();
$criterianews = new CDbCriteria();
$criterianews->order = 'id DESC';
$criterianews->limit = 2;
$criterianews2 = new CDbCriteria();
$criterianews2->order = 'RAND()';
$news = News::model()->findByAttributes(array('status' => 'ACTIVE'), $criterianews2);
$twonews = News::model()->findAllByAttributes(array('status' => 'ACTIVE'), $criterianews);
$specialities = Speciality::model()->findAll(array('order' => 'id'));
$especialidades = [];
foreach ($specialities as $i => $speciality) {
$aux = [];
$aux['id'] = $speciality->id;
$n = 'speciality_' . $speciality->id . '_name';
$aux['name'] = Yii::t('departments', $n);
array_push($especialidades, $aux);
}
$list = CHtml::listData($especialidades, 'id', 'name');
$services = Service::model()->findAllbyAttributes(array('type' => 'SERVICE'));
$currentLang = Yii::app()->language;
?>
<header id='head' class="h-metropolitano-int" >
<div class="lenguages-t">
<a <?php
/**
* 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 Speciality the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Speciality::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
