public function getPrice($id, $mType, $types, $dates)
{
$dates = date('Y-m-d', strtotime($dates));
$model = Prices::model()->find(array('condition' => 'date(price_date) <= :dates AND just_id = :id AND menu_type = :mType AND types = :types', 'order' => 'price_date DESC', 'limit' => 1, "together" => true, 'params' => array(':id' => $id, ':mType' => $mType, ':types' => $types, ':dates' => $dates)));
if (empty($model)) {
$model2 = Prices::model()->find(array('condition' => 'just_id = :id AND menu_type = :mType AND types = :types', 'order' => 'price_date DESC', 'limit' => 1, "together" => true, 'params' => array(':id' => $id, ':mType' => $mType, ':types' => $types)));
return $model2->price;
} else {
return $model->price;
}
}
echo '<td><span data-set="' . $val . '_3">0грн</span></td>';
}
}
$pack4 = Prices::model()->findByAttributes(array('genre_id' => $val, 'package' => 4));
if (is_object($pack4)) {
$tip = "<div class='tooltip_cost_edit'>редактировать</div><div class='tooltip_cost_title'>" . Genre::getName($val) . "</div>\n <p class='tooltip_cost_text'>Описание услуги: " . $pack4->about . "</p>";
echo '<td><span class="tooltipster" title="' . $tip . '" data-set="' . $val . '_4">' . $pack4->price . 'грн <div class="cost-info"></div></span></td>';
} else {
if (is_object($pack3)) {
$tip = "<div class='tooltip_cost_edit'>редактировать</div><div class='tooltip_cost_title'>" . Genre::getName($val) . "</div>\n <p class='tooltip_cost_text'>Описание услуги: </p>";
echo '<td><span class="tooltipster" title="' . $tip . '" data-set="' . $val . '_4">0грн <div class="cost-info"></div></span></td>';
} else {
echo '<td><span data-set="' . $val . '_4">0грн</span></td>';
}
}
$pack5 = Prices::model()->findByAttributes(array('genre_id' => $val, 'package' => 5));
if (is_object($pack5)) {
$tip = "<div class='tooltip_cost_edit'>редактировать</div><div class='tooltip_cost_title'>" . Genre::getName($val) . "</div>\n <p class='tooltip_cost_text'>Описание услуги: " . $pack5->about . "</p>";
echo '<td><span class="tooltipster" title="' . $tip . '" data-set="' . $val . '_5">' . $pack5->price . 'грн <div class="cost-info"></div></span></td>';
} else {
if (is_object($pack4)) {
$tip = "<div class='tooltip_cost_edit'>редактировать</div><div class='tooltip_cost_title'>" . Genre::getName($val) . "</div>\n <p class='tooltip_cost_text'>Описание услуги: </p>";
echo '<td><span class="tooltipster" title="' . $tip . '" data-set="' . $val . '_5">0грн <div class="cost-info"></div></span></td>';
} else {
echo '<td><span data-set="' . $val . '_5">0грн</span></td>';
}
}
echo '</tr>';
}
?>
</table>
/**
* Deletes a particular model.
* If deletion is successful, the browser will be redirected to the 'admin' page.
* @param integer $id the ID of the model to be deleted
*/
public function actionDelete($id)
{
//$model=$this->loadModel($id);
Prices::model()->deleteAll('upload_file_id =:upload_file_id', array('upload_file_id' => $id));
$this->loadModel($id)->delete();
// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
if (!isset($_GET['ajax'])) {
$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
}
}
public function actionShowform($id)
{
$data = explode('_', $id);
$pack = Prices::model()->findByAttributes(array('genre_id' => $data[0], 'package' => $data[1], 'user_id' => Yii::app()->user->id));
if (Yii::app()->user->role == 2) {
//videooperator
$title = Video::model()->findByAttributes(array('uid' => Yii::app()->user->id, 'id' => $data[0]));
} else {
$title = Portfolio::model()->findByAttributes(array('uid' => Yii::app()->user->id, 'id' => $data[0]));
}
if (is_object($pack)) {
$html = '<form action="/my/prices/update/id/' . $pack->id . '" method="post">';
$html .= '<script>
$(document).ready(function() {
$("#price__price").keydown(function (e) {
// Allow: backspace, delete, tab, escape, enter and .
if ($.inArray(e.keyCode, [46, 8, 9, 27, 13, 110]) !== -1 ||
// Allow: Ctrl+A
(e.keyCode == 65 && e.ctrlKey === true) ||
// Allow: home, end, left, right, down, up
(e.keyCode >= 35 && e.keyCode <= 40)) {
return;
}
// Ensure that it is a number and stop the keypress
if ((e.shiftKey || (e.keyCode < 48 || e.keyCode > 57)) && (e.keyCode < 96 || e.keyCode > 105)) {
e.preventDefault();
}
});
});
</script>';
$html .= '<div class="tooltip_cost_title">' . $title->title . '</div>
<label for="albom__name" class="tool_label" style="margin-top: 25px;">Цена</label>
<input type="text" name="Prices[price]" value="' . $pack->price . '" id="price__price" class="default__input search__hidden__input--city" maxlength="7" title="Это поле обязательно для заполнение" placeholder="500 грн" required="">
<label for="albom__name" class="tool_label">Описание</label>
<textarea name="Prices[about]" id="about__user" cols="25" rows="10" class="default__textarea" placeholder="Описание услуги:">' . $pack->about . '</textarea>
<div class="col-12 text_center" style="margin-top: 25px;">
<div class="btn__group clfx">
<div class="col-179">
<button type="button" class="t-cls cabinet__profile__btn" id="close_tip" onclick="closeTip(\'' . $id . '\')">ОТМЕНА</button>
</div>
<div class="col-179">
<input type="hidden" name="Prices[user_id]" value="' . Yii::app()->user->id . '" />
<input type="hidden" name="Prices[package]" value="' . $data[1] . '" />
<input type="hidden" name="Prices[genre_id]" value="' . $data[0] . '" />
<button type="submit" class="t-cls cabinet__profile__btn cabinet__profile__btn-submit">СОХРАНИТЬ</button>
</div>
</div>
</div>
</form>';
} else {
$html = '<form action="/my/prices/create/" method="post">';
$html .= '<div class="tooltip_cost_title">' . $title->title . '</div>
<label for="albom__name" class="tool_label" style="margin-top: 25px;">Цена</label>
<input type="text" name="Prices[price]" id="albom__name" class="default__input search__hidden__input--city" title="Это поле обязательно для заполнение" placeholder="500 грн" required="">
<label for="albom__name" class="tool_label">Описание</label>
<textarea name="Prices[about]" id="about__user" cols="25" rows="10" class="default__textarea" placeholder="Описание услуги:"></textarea>
<div class="col-12 text_center" style="margin-top: 25px;">
<div class="btn__group clfx">
<div class="col-179">
<button type="button" class="t-cls cabinet__profile__btn" id="close_tip" onclick="closeTip(\'' . $id . '\')">ОТМЕНА</button>
</div>
<div class="col-179">
<input type="hidden" name="Prices[user_id]" value="' . Yii::app()->user->id . '" />
<input type="hidden" name="Prices[package]" value="' . $data[1] . '" />
<input type="hidden" name="Prices[genre_id]" value="' . $data[0] . '" />
<button type="submit" class="t-cls cabinet__profile__btn cabinet__profile__btn-submit">СОХРАНИТЬ</button>
</div>
</div>
</div>
</form>';
}
echo $html;
}
public function actionShowform($id)
{
$data = explode('_', $id);
$pack = Prices::model()->findByAttributes(array('genre_id' => $data[0], 'package' => $data[1], 'user_id' => Yii::app()->user->id));
if (is_object($pack)) {
$html = '<form action="/my/prices/update/id/' . $pack->id . '" method="post">';
$html .= '<div class="tooltip_cost_title">' . Genre::getName($data[0]) . '</div>
<label for="albom__name" class="tool_label" style="margin-top: 25px;">Цена</label>
<input type="text" name="Prices[price]" value="' . $pack->price . '" id="albom__name" class="default__input search__hidden__input--city" title="Это поле обязательно для заполнение" placeholder="500 грн" required="">
<label for="albom__name" class="tool_label">Описание</label>
<textarea name="Prices[about]" id="about__user" cols="25" rows="10" class="default__textarea" placeholder="Описание услуги:">' . $pack->about . '</textarea>
<div class="col-12 text_center" style="margin-top: 25px;">
<div class="btn__group clfx">
<div class="col-179">
<button type="clear" class="t-cls cabinet__profile__btn">ОТМЕНА</button>
</div>
<div class="col-179">
<input type="hidden" name="Prices[user_id]" value="' . Yii::app()->user->id . '" />
<input type="hidden" name="Prices[package]" value="' . $data[1] . '" />
<input type="hidden" name="Prices[genre_id]" value="' . $data[0] . '" />
<button type="submit" class="t-cls cabinet__profile__btn cabinet__profile__btn-submit">СОХРАНИТЬ</button>
</div>
</div>
</div>
</form>';
} else {
$html = '<form action="/prices/create/" method="post">';
$html .= '<div class="tooltip_cost_title">' . Genre::getName($data[0]) . '</div>
<label for="albom__name" class="tool_label" style="margin-top: 25px;">Цена</label>
<input type="text" name="Prices[price]" id="albom__name" class="default__input search__hidden__input--city" title="Это поле обязательно для заполнение" placeholder="500 грн" required="">
<label for="albom__name" class="tool_label">Описание</label>
<textarea name="Prices[about]" id="about__user" cols="25" rows="10" class="default__textarea" placeholder="Описание услуги:"></textarea>
<div class="col-12 text_center" style="margin-top: 25px;">
<div class="btn__group clfx">
<div class="col-179">
<button type="clear" class="t-cls cabinet__profile__btn">ОТМЕНА</button>
</div>
<div class="col-179">
<input type="hidden" name="Prices[user_id]" value="' . Yii::app()->user->id . '" />
<input type="hidden" name="Prices[package]" value="' . $data[1] . '" />
<input type="hidden" name="Prices[genre_id]" value="' . $data[0] . '" />
<button type="submit" class="t-cls cabinet__profile__btn cabinet__profile__btn-submit">СОХРАНИТЬ</button>
</div>
</div>
</div>
</form>';
}
echo $html;
}
/**
* 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 = Prices::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
?>
<?php
echo $form->textField($model, 'DocCustumer', array('id' => "DocCustumer", 'class' => 'span12'));
?>
<?php
echo $form->error($model, 'DocCustumer');
?>
</div>
</div>
<div class="row-fluid">
<div class ="span4">
<?php
$idPrices = $model->SepcialityID;
//$Set = Prices::GetPrice($idPrices);
$model->AcademicSemesterID = Prices::model()->find("SpecialityID = {$idPrices}")->PriceSemesterInNumbers;
echo $form->labelEx($model, 'AcademicSemesterID', array('class' => 'span12'));
?>
<?php
echo $form->textField($model, 'AcademicSemesterID', array('id' => "AcademicSemesterID", 'class' => 'span12', 'readonly' => true));
?>
<?php
echo $form->error($model, 'AcademicSemesterID');
//echo $Set = Prices::GetPrice($idPrices);
?>
</div>
<div class ="span4">
<?php
echo $form->labelEx($model, 'CustomerPaymentDetails');
//,array('class'=>'span3'));
echo '<td><span data-set="' . $val->id . '_3">0</span></td>';
}
}
$pack4 = Prices::model()->findByAttributes(array('genre_id' => $val->id, 'package' => 4, 'user_id' => Yii::app()->user->id));
if (is_object($pack4)) {
$tip = "<span class='close__tip' onClick=close_tip()>X</span><div class='tooltip_cost_edit' id='tip_edit_" . $val->id . "_4'>редактировать</div><div class='tooltip_cost_title'>" . $val->title . "</div>\n <p class='tooltip_cost_text'>Описание услуги: " . $pack4->about . "</p>";
echo '<td><span class="tooltipster" id="tip_' . $val->id . '_4" title="' . $tip . '" data-text="' . $tip . '" data-set="' . $val->id . '_4" onmouseover="show(\'' . $val->id . '_4\')">' . $pack4->price . ' <div class="cost-info"></div></span></td>';
} else {
if (is_object($pack3)) {
$tip = "<span class='close__tip' onClick=close_tip()>X</span><div class='tooltip_cost_edit' id='tip_edit_" . $val->id . "_4'>редактировать</div><div class='tooltip_cost_title'>" . $val->title . "</div>\n <p class='tooltip_cost_text'>Описание услуги: </p>";
echo '<td><span class="tooltipster" id="tip_' . $val->id . '_4" title="' . $tip . '" data-set="' . $val->id . '_4" onmouseover="show(\'' . $val->id . '_4\')">0 <div class="cost-info"></div></span></td>';
} else {
echo '<td><span data-set="' . $val->id . '_4">0</span></td>';
}
}
$pack5 = Prices::model()->findByAttributes(array('genre_id' => $val->id, 'package' => 5, 'user_id' => Yii::app()->user->id));
if (is_object($pack5)) {
$tip = "<span class='close__tip' onClick=close_tip()>X</span><div class='tooltip_cost_edit' id='tip_edit_" . $val->id . "_5'>редактировать</div><div class='tooltip_cost_title'>" . $val->title . "</div>\n <p class='tooltip_cost_text'>Описание услуги: " . $pack5->about . "</p>";
echo '<td><span class="tooltipster" id="tip_' . $val->id . '_5" title="' . $tip . '" data-text="' . $tip . '" data-set="' . $val->id . '_5" onmouseover="show(\'' . $val->id . '_5\')">' . $pack5->price . ' <div class="cost-info"></div></span></td>';
} else {
if (is_object($pack4)) {
$tip = "<span class='close__tip' onClick=close_tip()>X</span><div class='tooltip_cost_edit' id='tip_edit_" . $val->id . "_5'>редактировать</div><div class='tooltip_cost_title'>" . $val->title . "</div>\n <p class='tooltip_cost_text'>Описание услуги: </p>";
echo '<td><span class="tooltipster" id="tip_' . $val->id . '_5" title="' . $tip . '" data-set="' . $val->id . '_5" onmouseover="show(\'' . $val->id . '_5\')">0 <div class="cost-info"></div></span></td>';
} else {
echo '<td><span data-set="' . $val->id . '_5">0</span></td>';
}
}
echo '</tr>';
//endif;
}
?>
