private function getAuthByType($reg, $authtype, $lang)
{
if ($this->debug) {
echo "Searching for: " . $authtype->type . " in " . $reg->name . "<br>";
}
$auth = Authority::model()->findAll("region_id=:region and type=:type and lang=:lang", array(":region" => $reg->id, ":type" => $authtype->id, ':lang' => $lang));
if (count($auth)) {
foreach ($auth as $au) {
$result = $au;
if ($this->debug) {
echo "Found: " . $au->name . " in " . $reg->name . "<br>";
}
}
} else {
if ($this->debug) {
echo "Not Found: " . $authtype->type . " in " . $reg->name . "<br>";
}
$regP = $reg->parent;
if ($regP != null) {
if ($regP->id > 0) {
$result = $this->getAuthByType($regP, $authtype, $lang);
}
}
}
return $result;
}
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;
}
public function actionRequestForm($id)
{
$lang = $_POST['lang'];
$holetype = $_POST['hole_type'];
$auth = $_POST[$lang . '_auth'];
$to_name = $_POST[$lang . '_to_name'];
$to_address = $_POST[$lang . '_to_address'];
$to_index = $_POST[$lang . '_to_index'];
$from = $_POST[$lang . '_from'];
$postaddress = $_POST[$lang . '_postaddress'];
$signature = $_POST[$lang . '_signature'];
$auth = Authority::model()->findByPk(array('id' => $auth, 'lang' => $lang));
$model = $this->loadModel($id);
$pics = array();
$photos = "";
$ulang = Yii::app()->user->getLanguage();
if ($lang == "ru") {
Yii::app()->setLanguage("ru");
$lang = "ru";
} else {
Yii::app()->setLanguage("uk_ua");
$lang = "ua";
}
$pics = array_keys($_POST['chpk']);
setlocale(LC_ALL, 'ru_RU.UTF-8');
$photos = "";
$pnum = 1;
$images = array();
$model = $this->loadModel($id);
if (count($model->requests_user) > 0) {
$first = 1;
} else {
$first = 0;
}
if ($first != 0) {
$pictures = $hole->pictures_fresh;
} else {
$pictures = $answ->files_img;
$picPath = $model->requests_user[0]->answer->filesFolder . '/';
}
if ($_POST['map_ch'] === "on") {
$photos = $photos . "<tr><td colspan=2>" . Yii::t('holes_view', 'Карта') . ' ' . Yii::t('holes_view', 'PICTURE_TO') . ' №' . $id . '<br><img height="500px" src="http://maps.googleapis.com/maps/api/staticmap?center=' . str_replace(',', '.', $model->LATITUDE) . ',' . str_replace(',', '.', $model->LONGITUDE) . '&zoom=14&size=400x400&markers=color:red%7Clabel:Дефект%7Cicon:http://ukryama.com/images/st1234/' . $model->type->alias . '_' . $model['STATE'] . '.png|' . str_replace(',', '.', $model->LATITUDE) . ',' . str_replace(',', '.', $model->LONGITUDE) . '&sensor=false"></td></tr><tr><td colspan=2 class="smv-spacer"></td></tr>' . "\n";
}
foreach ($model->pictures_fresh as $picture) {
$pid = $picture->id;
foreach ($pics as $pic) {
if ($pic == $pid) {
if (!$first) {
$pfile = $picture->original;
$image = Yii::app()->image->load(Yii::getPathOfAlias('webroot') . $pfile);
if ($image->__get("height") > $image->__get("width")) {
$image->rotate(-90);
$fname = $pfile;
preg_match('/[^?]*/', $fname, $matches);
$string = $matches[0];
$pattern = preg_split('/\\./', $string, -1, PREG_SPLIT_OFFSET_CAPTURE);
$filenamepart = $pattern[count($pattern) - 1][0];
preg_match('/[^?]*/', $filenamepart, $matches);
$lastdot = $pattern[count($pattern) - 1][1];
$filename = substr($string, 0, $lastdot - 1);
$pfile = $filename . ".rotated." . $matches[0];
$image->save(Yii::getPathOfAlias('webroot') . $pfile);
}
if ($request->html) {
$photos = $photos . "<tr><td colspan=2>" . Yii::t('holes_view', 'PICTURE') . ' ' . $pnum . ' ' . Yii::t('holes_view', 'PICTURE_TO') . ' №' . $id . '<br><img height="500px" src="' . $pfile . '"></td></tr><tr><td colspan=2 class="smv-spacer"></td></tr>' . "\n";
} else {
$photos = $photos . "<tr><td colspan=2>" . Yii::t('holes_view', 'PICTURE') . ' ' . $pnum . ' ' . Yii::t('holes_view', 'PICTURE_TO') . ' №' . $id . '<br><img height="500px" src="data:image/jpg;base64,' . base64_encode(file_get_contents(Yii::getPathOfAlias('webroot') . $pfile)) . '"></td></tr><tr><td colspan=2 class="smv-spacer"></td></tr>' . "\n";
}
} else {
$pfile = $picPath . $picture->file_name;
if ($request->html) {
$photos = $photos . "<tr><td colspan=2>" . Yii::t('holes_view', 'PICTURE') . ' ' . $pnum . ' ' . Yii::t('holes_view', 'PICTURE_TO') . ' №' . $id . '<br><img height="500px" src="' . $pfile . '"></td></tr><tr><td colspan=2 class="smv-spacer"></td></tr>' . "\n";
} else {
$photos = $photos . "<tr><td colspan=2>" . Yii::t('holes_view', 'PICTURE') . ' ' . $pnum . ' ' . Yii::t('holes_view', 'PICTURE_TO') . ' №' . $id . '<br><img height="500px" src="data:image/jpg;base64,' . base64_encode(file_get_contents(Yii::getPathOfAlias('webroot') . $pfile)) . '"></td></tr><tr><td colspan=2 class="smv-spacer"></td></tr>' . "\n";
}
}
$pnum++;
}
}
}
$_data = array("ref" => "{$id}", "to_name" => $to_name, "to_address" => $to_address, "from_name" => $from, "from_address" => $postaddress, "when" => strftime("%e " . Yii::t('month', date("n")) . " %Y", $model->DATE_CREATED ? $model->DATE_CREATED : time()), "where" => $model->ADDRESS, "date" => strftime("%e " . Yii::t('month', date("n")) . " %Y", time()), "init" => $signature, "c_photos" => count($pics), "files" => $photos, "map" => 1);
if (!$first) {
$formType = $model->type['alias'];
} else {
$formType = "prosecutor2";
}
if ($_POST['print'] == "HTML") {
header('Content-Type: text/html; charset=utf8', true);
$printer = Yii::app()->Printer;
// echo $printer->printHTML($_data, $formType, $lang);
$name = "{$formType}" . "_{$lang}";
$tplname = YiiBase::getPathOfAlias($printer->params['templates']) . "/dyplates/" . $auth->atype->alias . "_" . $name . ".php";
$css = file_get_contents(YiiBase::getPathOfAlias($printer->params['templates']) . "/dyplates/" . $auth->atype->alias . "_" . $formType . ".css");
$html = $this->renderFile($tplname, $_data, true);
$html = "<style>{$css}</style>\n{$html}";
echo $html;
return;
} else {
//print pdf
$printer = Yii::app()->Printer;
$name = "{$formType}" . "_{$lang}";
$tplname = YiiBase::getPathOfAlias($printer->params['templates']) . "/dyplates/" . $auth->atype->alias . "_" . $name . ".php";
if (file_exists($tplname)) {
$css = file_get_contents(YiiBase::getPathOfAlias($printer->params['templates']) . "/dyplates/" . $auth->atype->alias . "_" . $formType . ".css");
$html = $this->renderFile($tplname, $_data, true);
$outname = "ukryama-" . date("Y-m-d_G-i-s");
echo $printer->printH2P($html, $css, $outname);
return;
}
}
//end print pdf
}
<?php
$this->pageTitle = Yii::app()->params['langtitle'] . $model->name . 'Справочник ГАИ ';
$this->title = CHtml::link('Справочник ГАИ', array('index')) . ' > ' . $model->name;
?>
<?php
if (Yii::app()->getLanguage() == "ru") {
$lang = "ru";
} else {
$lang = "ua";
}
$param = "auth_" . $lang;
// $auth=$model->$param->condition("type=:type",array(":type"=>2));
$auth = Authority::model()->find('region_id=:region and type=2 and lang=:lang', array(':region' => $model->id, ':lang' => $model->lang));
if ($auth) {
?>
<div class="news-detail sprav-detail">
<?php
$this->renderPartial('_view_gibdd', array('data' => $auth));
?>
</div>
<br/><br/>
<?php
}
public function getAuthByType($reg, $authtype, $lang)
{
$result = array();
$auth = Authority::model()->findAll("region_id=:region and type=:type and lang=:lang", array(":region" => $reg->id, ":type" => $authtype, ':lang' => $lang));
// echo "Found ".count($auth)." of ".$authtype->alias." in ".$reg->name."<br>";
if (count($auth)) {
//если в данном регионе найдены органы нужного нам типа, то записываем их в массив и возвращаем его
foreach ($auth as $au) {
// echo "Authority is: ".$au->name."<br>";
array_push($result, $au);
}
} else {
//иначе идем выше по регионам
$regP = $reg->parent;
//запрашиваем родительский регион
if ($regP != null) {
if ($regP->id > 0) {
$result = $this->getAuthByType($regP, $authtype, $lang);
}
}
}
return $result;
}
