public function generateProgress($progress = 0)
{
$user = new User();
$user->username = "******";
$user->email = "*****@*****.**";
$user->password = "******";
$user->save();
$plan = new Plan();
$plan->user_id = $user->id;
$plan->name = 'UnitTestProject';
$plan->description = 'UnitTestProject';
$plan->budget = '0';
$plan->target = '10000';
$plan->expected = '1000';
$plan->period = '10';
$plan->created_at = date('Y-m-d H:i:s', strtotime('-1 month', strtotime(date('Y-m-d'))));
$plan->updated_at = date('Y-m-d H:i:s', strtotime('-1 month', strtotime(date('Y-m-d'))));
$plan->save();
$month = new Monthly();
$month->plan_id = $plan->id;
$month->status = 0;
$month->month = 1;
$month->limit = 1000;
$month->progress = $progress;
$month->save();
return ['plan' => $plan, 'month' => $month, 'user' => $user];
}
/**
* @PATCH("/plans/{plan}", as="admin.plans.update")
* @param Plan $plan
* @param Request $request
* @return \Illuminate\Http\RedirectResponse
*/
public function update(Plan $plan, Request $request)
{
$type = PlansType::findOrFail($request->input('type_id'));
$plan->fill($request->all());
$plan->type()->associate($type);
$plan->update();
return redirect()->route('admin.plans.index');
}
/**
* Store a newly created resource in storage.
*
* @param Deposit $deposit
* @param \Illuminate\Http\Request $request
* @return \Illuminate\Http\Response
*/
public function store(Deposit $deposit, Request $request)
{
if ((int) $request->input('amount') > Auth::user()->balance) {
\Session::flash('message', 'Недостаточно средств!');
return redirect('/profile');
} elseif ($request->input('amount') <= 0) {
\Session::flash('message', 'Введите корректную сумму!');
return back();
} else {
$bank = Banks::where('banks_profiles_id', 2)->first();
$data = $request->all();
$data['days'] = $request->input('days');
$data['percent'] = $request->input('percent');
$data['conclusion'] = Carbon::now()->addDays((int) $request->input('days'));
$user = User::find($request->input('user_id'));
$plan = Plan::find($request->input('currency_id'));
$deposit->fill($data);
$deposit->user()->associate($user);
$deposit->plan()->associate($plan);
$bank->amount += (int) $request->input('amount');
$bank->update();
$user->balance -= (int) $request->input('amount');
$user->update();
$deposit->save();
\Session::flash('message', 'Вы успешно сделали вклад! Для получения информации по вкладам перейдите в "Мои операции"');
return redirect('/profile');
}
}
public function testCreate()
{
$user = $this->generateUser();
$this->visit('/plan')->withSession(['Auth' => $user])->type('UnitTestProject', 'pname')->type('Test', 'pdescription')->type('1000', 'pexpected')->type('10000', 'ptarget')->type('0', 'pbudget')->type('10', 'pmonth')->press('pSave')->seePageIs('/plan');
$plan = Plan::where("name", "=", "UnitTestProject")->first();
$this->assertNotNull($plan);
$plan->delete();
$user->delete();
}
public function actionIndex()
{
$user = Yii::$app->user;
$month_plan = Plan::getMonthPlan($user->id);
$month_account_all = Account::getMonthAccountAll($user->id);
$week_account_all = Account::getWeekAccountAll($user->id);
$month_balance = $month_plan - $month_account_all;
$month_account_income_all = Account::getMonthAccountIncomeAll($user->id);
$month_account_list = Account::getMonthAccountList($user->id);
return $this->render('index', ['month_plan' => $month_plan, 'month_account_all' => $month_account_all, 'month_balance' => $month_balance, 'month_account_income_all' => $month_account_income_all, 'month_account_list' => $month_account_list]);
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$query = Plan::find();
$dataProvider = new ActiveDataProvider(['query' => $query]);
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['id' => $this->id, 'user_id' => $this->user_id, 'start_date' => $this->start_date, 'end_date' => $this->end_date]);
$query->andFilterWhere(['like', 'direction', $this->direction]);
return $dataProvider;
}
/**
* 列出教学计划
* @author FuRongxin
* @date 2016-02-04
* @version 2.0
* @return JSON 教学计划列表
*/
public function listing()
{
$plans = Plan::with(['platform' => function ($query) {
$query->select('dm', 'mc');
}])->with(['property' => function ($query) {
$query->select('dm', 'mc');
}])->with(['course' => function ($query) {
$query->select('kch', 'kcmc', 'kcywmc');
}])->with(['mode' => function ($query) {
$query->select('dm', 'mc');
}])->with(['college' => function ($query) {
$query->select('dw', 'mc');
}])->whereNj(Auth::user()->profile->nj)->whereZy(Auth::user()->profile->zy)->whereZsjj(Auth::user()->profile->zsjj)->orderBy('kch', 'asc');
return Datatables::of($plans)->addColumn('zxs', '{{ $llxs + $syxs }}')->make(true);
}
/**
* 列出选课情况交叉比较信息
* @author FuRongxin
* @date 2016-05-13
* @version 2.1
* @return \Illuminate\Http\Response 选课交叉比较信息
*/
public function match()
{
$credits = [];
$plan_total = 0;
$selected_total = 0;
$score_total = 0;
// 获取教学计划学分
$plans = Plan::with(['course' => function ($query) {
$query->select('kch', 'kcmc', 'kcywmc');
}])->whereNj(Auth::user()->profile->nj)->whereZy(Auth::user()->profile->zy)->whereZsjj(Auth::user()->profile->zsjj)->orderBy('kch', 'asc')->get();
foreach ($plans as $plan) {
$credits[$plan->kch] = ['kch' => $plan->kch, 'kcmc' => $plan->course->kcmc, 'plan_credit' => $plan->zxf, 'selected_credit' => 0, 'score_credit' => 0];
$plan_total += $plan->zxf;
}
// 获取选课学分
$selects = Selcourse::with(['course' => function ($query) {
$query->select('kch', 'kcmc', 'kcywmc');
}])->whereXh(Auth::user()->xh)->orderBy('kch', 'asc')->get();
foreach ($selects as $select) {
if (array_key_exists($select->kch, $credits)) {
$credits[$select->kch]['selected_credit'] = $select->xf;
} else {
$credits[$select->kch] = ['kch' => $select->kch, 'kcmc' => $select->course->kcmc, 'plan_credit' => 0, 'selected_credit' => $select->xf, 'score_credit' => 0];
}
$selected_total += $select->xf;
}
// 获取成绩学分
$scores = Score::with(['course' => function ($query) {
$query->select('kch', 'kcmc', 'kcywmc');
}])->whereXh(Auth::user()->xh)->orderBy('kch', 'asc')->get();
foreach ($scores as $score) {
if (array_key_exists($score->kch, $credits)) {
$credits[$score->kch]['score_credit'] = $score->xf;
} else {
$credits[$select->kch] = ['kch' => $score->kch, 'kcmc' => $score->course->kcmc, 'plan_credit' => 0, 'selected_credit' => 0, 'score_credit' => $score->xf];
}
$score_total += $score->xf;
}
$title = '选课学分交叉对比表';
return view('course.match', compact('title', 'credits', 'plan_total', 'selected_total', 'score_total'));
}
/**
* Bootstrap any application services.
*
* @return void
*/
public function boot()
{
// when a user changes an item ....
Item::updated(function ($item) {
// .... update the 'changer' field on the parent model (plan)
$plan = Plan::find($item->plan_id);
$plan->update(['changer' => Auth::user()->first_name]);
});
/**
* Provide the data of the last update to the list of songs
*/
$lastSongUpdated_at = Song::select('updated_at')->orderby('updated_at', 'desc')->first()->updated_at;
view()->share('lastSongUpdated_at', $lastSongUpdated_at);
// provide the name of the current Main Presenter to all views
view()->share('serverSideMainPresenter', getMainPresenter());
// provide the PATH to the (custom) logos to all views
if (strtolower(env('USE_CUSTOM_LOGOS')) == 'yes') {
view()->share('logoPath', 'images/custom/');
} else {
view()->share('logoPath', 'images/');
}
// provide a list (array) of user-id's with Admin rights to all views (for page feedback messages)
// (the condition is needed in order to avoid an error in artisan when no migration has happened yet!)
if (\Schema::hasTable('users')) {
view()->share('administrators', findAdmins('id'));
}
// detect mobile users
$isMobileUser = false;
$useragent = 'local';
if (isset($_SERVER['HTTP_USER_AGENT'])) {
$useragent = $_SERVER['HTTP_USER_AGENT'];
}
if (preg_match('/(android|bb\\d+|meego).+mobile|avantgo|bada\\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|mobile.+firefox|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\\.(browser|link)|vodafone|wap|windows ce|xda|xiino/i', $useragent) || preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\\-(n|u)|c55\\/|capi|ccwa|cdm\\-|cell|chtm|cldc|cmd\\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\\-s|devi|dica|dmob|do(c|p)o|ds(12|\\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\\-|_)|g1 u|g560|gene|gf\\-5|g\\-mo|go(\\.w|od)|gr(ad|un)|haie|hcit|hd\\-(m|p|t)|hei\\-|hi(pt|ta)|hp( i|ip)|hs\\-c|ht(c(\\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\\-(20|go|ma)|i230|iac( |\\-|\\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\\/)|klon|kpt |kwc\\-|kyo(c|k)|le(no|xi)|lg( g|\\/(k|l|u)|50|54|\\-[a-w])|libw|lynx|m1\\-w|m3ga|m50\\/|ma(te|ui|xo)|mc(01|21|ca)|m\\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\\-2|po(ck|rt|se)|prox|psio|pt\\-g|qa\\-a|qc(07|12|21|32|60|\\-[2-7]|i\\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\\-|oo|p\\-)|sdk\\/|se(c(\\-|0|1)|47|mc|nd|ri)|sgh\\-|shar|sie(\\-|m)|sk\\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\\-|v\\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\\-|tdg\\-|tel(i|m)|tim\\-|t\\-mo|to(pl|sh)|ts(70|m\\-|m3|m5)|tx\\-9|up(\\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\\-|your|zeto|zte\\-/i', substr($useragent, 0, 4))) {
$isMobileUser = true;
}
// provide this to all views
view()->share('isMobileUser', $isMobileUser);
}
/**
* PERMANENTLY DELETE all trashed items of a plan
*
*/
public function deleteAllTrashed($plan_id)
{
$plan = Plan::find($plan_id);
// check if user is leader of the corresponding plan or author/admin
if (!$plan->leader_id == Auth::user()->id || !Auth::user()->isAuthor()) {
flash('Sorry, only plan leader or Author can delete items');
return redirect()->back();
}
// this item should be restored
$items = Item::with('files')->onlyTrashed()->where('plan_id', $plan_id);
if (!$items) {
return false;
}
$items->forceDelete();
flash('All trashed items deleted');
return \Redirect::back();
}
/**
* @return \yii\db\ActiveQuery
*/
public function getPlans()
{
return $this->hasMany(Plan::className(), ['purse_id' => 'id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getPlan()
{
return $this->hasOne(Plan::className(), ['id' => 'plan_id']);
}
/**
* Edit a single team member of a plan
*
* @return \Illuminate\Http\Response
*/
public function edit($plan_id, $id)
{
// get current plan
$plan = Plan::with('teams')->find($plan_id);
// check access rights
if (!Auth::user()->ownsPlan($plan_id)) {
return redirect('home')->with('error', 'You are unauthorized for this request.');
}
// get list of users
$users = User::where('name', '<>', 'n/a')->orderBy('first_name')->get();
// get the resource handle
$team = Team::find($id);
if ($team) {
return view('cspot.team', ['team' => $team, 'plan' => $plan, 'users' => $users, 'userRoles' => json_encode(getUsersRolesAndInstruments())]);
}
$error = 'Wrong team member id!';
return \Redirect::back()->with(['error' => $error]);
}
public function imprimirProfesorxPlan($patronplan = null)
{
if (empty($patronplan)) {
$planes = Plan::all();
} else {
$planes = Plan::where('plan', "LIKE", "%{$patronplan}%")->orderBy('plan')->get();
}
$vista = \View::make('planes.profesorxplanpdf', ['planes' => $planes])->render();
$pdf = \App::make('dompdf.wrapper');
$pdf->loadHTML($vista);
return $pdf->stream('profesorxplanpdf');
}
public function postDelete(Request $request)
{
if ($request->expense != null) {
foreach ($request->expense as $key => $value) {
$finance = Finance::find($value);
if ($finance->type == 0) {
$day = Daily::find($finance->daily_id);
$day->expense -= $finance->amount;
$day->save();
$month = Monthly::find($day->monthly_id);
$month->progress += $finance->amount;
$month->save();
$plan = Plan::find($month->plan_id);
$plan->budget += $finance->amount;
$plan->save();
} else {
$day = Daily::find($finance->daily_id);
$day->income -= $finance->amount;
$day->save();
$month = Monthly::find($day->monthly_id);
$month->progress -= $finance->amount;
$month->save();
$plan = Plan::find($month->plan_id);
$plan->budget -= $finance->amount;
$plan->save();
}
$finance->delete();
Session::forget("successes");
Session::put("successes", ["Delete expense successes fully."]);
}
} else {
Session::forget("successes");
Session::put("successes", ["No item selected!"]);
}
return redirect()->back()->withInput();
}
use yii\helpers\Html;
use yii\widgets\ActiveForm;
use yii\helpers\ArrayHelper;
/* @var $this yii\web\View */
/* @var $model app\models\Cuenta */
/* @var $form yii\widgets\ActiveForm */
?>
<div class="cuenta-form">
<?php
$listContactos = ArrayHelper::map(\app\models\Contacto::findAll(['baja' => 0]), 'id', 'nombres');
?>
<?php
$listPlanes = ArrayHelper::map(\app\models\Plan::findAll(['baja' => 0]), 'id', 'nombre');
?>
<?php
$form = ActiveForm::begin();
?>
<?php
echo $form->field($model, 'id_contacto')->dropDownList($listContactos, ['prompt' => '--SELECCIONE--']);
?>
<?php
echo $form->field($model, 'id_plan')->dropDownList($listPlanes, ['prompt' => '--SELECCIONE--']);
?>
public function postIndex(Request $request)
{
$messages = ["pname.required" => "Plan name is required", "pdescription.required" => "Description is required", "pexpected.required" => "Expected per month is required", "ptarget.required" => "Target for saving is required", "pbudget.required" => "Budget is required", "pmonth.required" => "Period is required", "pname.alpha_num" => "Plan name must be consist of texts and numbers", "pexpected.numeric" => "Expected per month must be consist of only numbers", "ptarget.numeric" => "Target for saving must be consist of only numbers", "pbudget.numeric" => "Budget must be consist of only numbers", "pmonth.numeric" => "Period must be consist of only numbers"];
$validator = Validator::make($request->all(), ['pname' => 'required|alpha_num', 'pdescription' => 'required', 'pexpected' => 'required|numeric', 'ptarget' => 'required|numeric', 'pbudget' => 'required|numeric', 'pmonth' => 'required|numeric|min:1'], $messages);
if ($validator->fails()) {
return redirect()->back()->withErrors($validator)->withInput();
}
if ($request->pdelete != null) {
return redirect('plan/delete');
}
if ($request->pbudget > $request->ptarget) {
$validator->errors()->add('target', 'Budget is more than target!');
return redirect()->back()->withErrors($validator)->withInput();
}
if ($request->pexpected >= $request->ptarget) {
$validator->errors()->add('target', 'Expected per month is more than target!');
return redirect()->back()->withErrors($validator)->withInput();
}
if (!$this->user) {
$validator->errors()->add('user', 'You are not login!');
return redirect('login')->withErrors($validator);
} else {
$plan = $this->user->plans()->where("id", "=", $request->plan_id)->first();
if (!$plan) {
$plan = new Plan();
$plan->budget = $request->pbudget;
}
//$period = ceil(($request->ptarget - $request->pbudget) / $request->pexpected);
$plan->user_id = $this->user->id;
$plan->name = $request->pname;
$plan->description = $request->pdescription;
$plan->period = $request->pmonth;
$plan->target = $request->ptarget;
$plan->expected = $request->pexpected;
$plan->original = $request->pbudget;
$plan->save();
Session::put("Plan", $plan->id);
}
return redirect()->back()->withInput();
}
public function esValido()
{
$socio = Socio::find(Input::get('socios_id'));
$plan = Plan::find(Input::get('planes_id'));
$pagos = Pago::find();
}
public function compose(View $view)
{
$plans_good = Plan::where('type_id', 1)->get();
$plans_bad = Plan::where('type_id', 2)->get();
$view->with('plans1', $plans_good)->with('plans2', $plans_bad);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(PlansRequest $request, $id)
{
foreach ($request->all() as $key => $val) {
if (substr($key, 0, 2) == "p_") {
$tagname = "t_" . substr($key, 2);
$tag = $request->input($tagname);
if (!$tag) {
$tag = null;
}
if ($val) {
$pid = substr($val, 2);
if (substr($val, 0, 1) == "M") {
$ptyp = "App\\Models\\Minister";
} elseif (substr($val, 0, 1) == "P") {
$ptyp = "App\\Models\\Preacher";
} else {
$ptyp = "App\\Models\\Guest";
}
} else {
$pid = null;
$ptyp = null;
}
$kk = array(explode('_', $key));
$plan = Plan::where('society_id', '=', $kk[0][1])->where('service_id', '=', $kk[0][2])->where('planyear', '=', $kk[0][3])->where('planmonth', '=', $kk[0][4])->where('planday', '=', $kk[0][5])->first();
if (count($plan)) {
$plan->tag_id = $tag;
$plan->preachable_id = $pid;
$plan->preachable_type = $ptyp;
if ($tag == null and $pid == null) {
$plan->delete();
} else {
$plan->save();
}
} else {
if ($tag or $pid) {
$newplan = Plan::create(array('society_id' => $kk[0][1], 'service_id' => $kk[0][2], 'planyear' => $kk[0][3], 'planmonth' => $kk[0][4], 'planday' => $kk[0][5], 'preachable_id' => $pid, 'preachable_type' => $ptyp, 'tag_id' => $tag));
}
}
}
}
return Redirect::back()->with('okmessage', 'Plan details have been updated');
}
public function actionPlan()
{
$model = new SignupForm();
$id = $_POST['valor'];
$model1 = Plan::find()->where(['id_Carrera' => $id])->all();
if ($model1 !== null) {
$listaPlanes = ArrayHelper::map($model1, 'id_Plan', 'plan_nombre');
//return $this->renderAjax('signup',['model' =>$model,'model1' => $model1,'id' => $id,'listaPlanes' =>$listaPlanes]);
foreach ($model1 as $lista) {
echo '<option value="' . $lista->id_Plan . '">' . $lista->plan_nombre . '</option>';
}
}
}
public function imprimirSociosconObservacion($numero = null, $nombre = null, $estado = null)
{
$planes = Plan::orderBy('plan', 'asc')->lists('plan', 'id');
if (empty($numero) and empty($nombre) and empty($estado)) {
$socios = Socio::all();
} else {
$socios = Socio::numero($numero)->socioNombre($nombre)->estado($estado)->get();
}
$vista = \View::make('socios.sociosconobservacionpdf', ['socios' => $socios, 'planes' => $planes])->render();
$pdf = \App::make('dompdf.wrapper');
$pdf->loadHTML($vista);
return $pdf->stream('sociosconobservacionpdf');
}
/**
* @return \yii\db\ActiveQuery
*/
public function getIdPlan()
{
return $this->hasOne(Plan::className(), ['id' => 'id_plan']);
}
/**
* Check if a user has rights to modify a plan
* either with Author or higher role
* or as leader or teacher of a plan
*/
public function ownsPlan($plan_id)
{
if (Auth::user()->isAuthor()) {
return true;
}
// find the Plan
$plan = Plan::find($plan_id);
if ($this->id == $plan->leader_id || $this->id == $plan->teacher_id) {
return true;
}
return false;
}
public function getReport(Request $request)
{
if ($this->user != null && Session::has('Plan') && Session::get('Plan') != "") {
$plan = Plan::find(Session::get('Plan'));
$attach["plan"] = $plan;
$attach["Month"] = $plan->months()->get();
$attach["Category"] = Category::where('user_id', '=', $this->user->id)->orWhere('user_id', '=', 0)->get();
$attach['sumIncome'] = Finance::join('category', 'category.id', '=', 'finance.category_id')->join('daily', 'daily.id', '=', 'finance.daily_id')->join('monthly', 'monthly.id', '=', 'daily.monthly_id')->join('plan', 'plan.id', '=', 'monthly.plan_id')->where('plan.id', '=', $plan->id)->where('type', '=', 1)->sum('amount');
$attach['sumExpense'] = Finance::join('category', 'category.id', '=', 'finance.category_id')->join('daily', 'daily.id', '=', 'finance.daily_id')->join('monthly', 'monthly.id', '=', 'daily.monthly_id')->join('plan', 'plan.id', '=', 'monthly.plan_id')->where('plan.id', '=', $plan->id)->where('type', '=', 0)->sum('amount');
if (isset($request->category) && isset($request->month)) {
$cat = $request->category;
$month = $request->month;
$query = Finance::select('finance.name', 'category.name AS category', 'finance.created_at', 'plan.name AS plan', 'finance.type', 'finance.amount')->join('category', 'category.id', '=', 'finance.category_id')->join('daily', 'daily.id', '=', 'finance.daily_id')->join('monthly', 'monthly.id', '=', 'daily.monthly_id')->join('plan', 'plan.id', '=', 'monthly.plan_id');
if ($cat != 0) {
$query->where('category.id', '=', $cat);
}
if ($month != 0) {
$query->where('monthly.id', '=', $month);
}
$query->where('plan.id', '=', $plan->id);
$attach['finances'] = $query->paginate(20);
// $attach['finances'] = Finance::select('finance.name', 'category.name AS category', 'finance.created_at', 'plan.name AS plan', 'finance.type', 'finance.amount')
// ->join('category', 'category.id', '=', 'finance.category_id')
// ->join('daily', 'daily.id', '=', 'finance.daily_id')
// ->join('monthly', 'monthly.id', '=', 'daily.monthly_id')
// ->join('plan', 'plan.id', '=', 'monthly.plan_id')
// ->where('category.id', '=', $cat)
// ->where('monthly.id', '=', $month)
// ->where('plan.i', '=', $plan->id)
// ->paginate(20);
}
return view('home.report', $attach);
} else {
return view('home.report');
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$pago = Pago::find($id);
$planes = Plan::orderBy('plan', 'asc')->get();
$socios = Socio::orderBy('nombre', 'asc')->get();
$plan_sele = $pago->planes_id;
$socio_sele = $pago->socios_id;
return view('pagos.edit', ['pago' => $pago, 'planes' => $planes, 'socios' => $socios, 'plan_sele' => $plan_sele, 'socio_sele' => $socio_sele]);
}
/**
* @POST("get_plan")
* @param Request $request
* @return \Illuminate\Http\JsonResponse
*/
public function get_plan(Request $request)
{
//dd($request->all());
$plan = Plan::where('id', $request->input('plan'))->first()->toArray();
return response()->json($plan);
}
/**
* Finds the Plan model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $id
* @return Plan the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($id)
{
if (($model = Plan::findOne($id)) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
/**
* get date of last time this song was used in a plan
*/
public function getLastTimeUsedAttribute($value)
{
$id = $this->id;
// get list of plans using this song
$plan = Plan::whereHas('items', function ($query) use($id) {
$query->where('song_id', $id)->where('date', '<', Carbon::now());
})->orderBy('date', 'desc')->first();
if ($plan) {
return $plan->date;
}
return null;
}
/**
* RESTORE an item
*
* (the model migth allow soft deletes!)
*
* Make sure the new sequence number fits sequentially into
* the list of sequence numbers of the existing items for a plan
* and that all current sequence numbers are in 1.0 steps
*
* @param object $items
* @param number $new_seq_no
*/
function restoreItem($id)
{
// this item should be restored
$item = Item::onlyTrashed()->find($id);
if (!$item) {
return false;
}
$item->restore();
// get all items of the related plan
$plan = Plan::find($item->plan_id);
$items = $plan->items()->orderBy('seq_no')->get();
// numbering them countering with 1.0
$counter = 1.0;
foreach ($items as $item) {
if ($item->seq_no != $counter) {
$i = Item::find($item->id);
# get the actual DB record
$item->seq_no = $counter;
# update the current selection
$i->seq_no = $counter;
# update the seq_no
$i->save();
# save the record
}
$counter += 1.0;
}
return true;
}
