Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

« 1 / 5 »

Hotel cu restaurant si Demipensiu...

Croaziera in Mediterana de Vest 1...

Copilot are pica pe Vladimir Putin

MicroSoft Edge: Cum pun Google in...

I-auziti voi! - nu vor romani...

Colon iritabil

Perioada de gratie inexistenta

Cel mai ieftin TV LED mic

Reverse proxy si htaccess pe Raps...

Statie de epurare sau fosa septic...

"enerlux p" afisaj interm...

Adaptor usb3.1gigabit vs Adaptor ...

View New Content

PHP afisare lista dependenta de alta lista

Last Updated: Jul 05 2022 15:22, Started by d3v1l500 , Jul 05 2022 10:35

Please log in to reply

5 replies to this topic

#1
d3v1l500

Posted 05 July 2022 - 10:35

New Member

Grup: Junior Members
Posts: 23
Înscris: 26.04.2017

Ajutor... incerc sa fac o pagina in care sa introduc strazile unei tari... ca sa adaug strazi am nevoie de liste cu tari... bazat pe tara sa-mi arate judetele... bazat pe judet sa-mi arate localitati bazat pe localitati sa-mi arate strazile... nu reusesc sa fac aceste liste dependente de celelalte... decat sa le afisez am reusit..

tabla cu judete arata asa
id, nume_judet, id_tara
unde toate judetele au nr 4 la id_tara unde nr 4 = id-ul romaniei din tabela tari..

Ajutati-ma si pe mine ca la prosti ca nu mai stiu ce sa fac si cum sa fac...

Spoiler

Strazi.php

<?php
namespace App\Controllers;
use App\Helpers\SystemLogger;
use App\Models\Files;
use App\Models\Tari;
use App\Models\Judete;
use App\Models\Localitati;
use App\Models\Sate;
use Core\ArrayForm;
use Core\ArrayUtility;
use Core\Controller;
use Core\DebuggerUtility;
use Core\Request;
use Core\Session;
use Core\Validation;
use Core\View;
class Strazi extends Controller
{
public function list()
{
	 $page = Request::hasArgument('page', 'GET') ? Request::getArgument('page', 'GET') : 1;
	 $perPage = 30;
	 $columns = ['*'];
	 $pageName = 'page';

	 $strazi = \App\Models\Strazi::query();
	 $strazi = $strazi->orderByDesc('created_at');
	 if (Request::hasArgument('nume_strada') && !empty(Request::getArgument('nume_strada'))) {
		 $keywords = Request::getArgument('nume_strada');
		 if (explode(',', $keywords)) {
			 foreach (explode(',', $keywords) as $keyword) {
				 $keyword = '%' . $keyword . '%';
				 $strazi = $strazi->orwhere('nume_strada', 'like', $keyword);
			 }
		 } else {
			 $keywords = '%' . $keywords . '%';
			 $strazi = $strazi->orwhere('nume_strada', 'like', $keywords);
		 }
	 }
	 if (Request::hasArgument('sort') && !empty(Request::getArgument('sort'))) {
		 $orderBy = Request::getArgument('sort');
		 switch ($orderBy) {
			 case 'desc':
				 $strazi = $strazi->orderBy('created_at', 'desc');
				 break;
			 case 'asc':
				 $strazi = $strazi->orderBy('created_at', 'asc');
				 break;
			 default:
				 $strazi = $strazi->orderBy('created_at', 'desc');
		 }
	 }
	 $strazi = $strazi->paginate($perPage, $columns, $pageName, $page)->appends(Request::getQueryString(['page']));

	 View::render('admin/strazi',
		 [
			 'pageTitle' => 'Străzi / Listă Străzi',
			 'pageHeader' => 'Baza de Date Străzi',
			 'strazi' => $strazi->items(),
			 'nextPageUrl' => $strazi->nextPageUrl(),
			 'prevPageUrl' => $strazi->previousPageUrl(),
			 'lastPage' => $strazi->lastPage(),
			 'perPage' => $strazi->perPage(),
			 'total' => $strazi->total(),
			 'sort' => Request::getArgument('sort'),
			 'nume_strada' => Request::getArgument('nume_strada'),
			 'currentPageInput' => $page
		 ]);
}
public function add()
{
	 $tari = Tari::all()->toArray();
	 $judete = Judete::all()->toArray();
$localitati = Localitati::all()->toArray();
$sate = Sate::all()->toArray();
	 $tariSelect = [];
	 $tariSelect[''] = 'Selecteaza Țara';
	 if($tari)
	 {
		 foreach ($tari as $tara)
		 {
			 $tariSelect[$tara['id']] = $tara['nume_tara'];
		 }
	 }
$judetSelected = [];
	 $judetSelected[''] = 'Selectează judeţul';
	 if(Session::getParam('form-add-strazi')['id_judet'])
	 {
		 $judet = Judete::where('id', '=', Session::getParam('form-add-strazi')['id_judet'])->get(['id','nume_judet'])->first();
		 if($judet)
		 {
			 $judetSelected[$judet['id']] = $judet['nume_judet'];
		 }
	 }
	 $judeteSelect = [];
	 $judeteSelect[''] = 'Selecteaza Judetul';
	
	 if($judete)
	 {
		 foreach ($judete as $judet)
		 {
			 $judeteSelect[$judet['id']] = $judet['nume_judet'];
		 }
	 }
	 $localitatiSelect = [];
	 $localitatiSelect[''] = 'Selecteaza Localitatea';
	
	 if($localitati)
	 {
		 foreach ($localitati as $localitate)
		 {
			 $localitatiSelect[$localitate['id']] = $localitate['nume_localitate'];
		 }
	 }
	 $sateSelect = [];
	 $sateSelect[''] = 'Selecteaza Satul';
	
	 if($sate)
	 {
		 foreach ($sate as $sat)
		 {
			 $sateSelect[$sat['id']] = $sat['nume_sat'];
		 }
	 }

	 $form =
		 [
			 'action' => $this->appUrl.'/admin/strazi/save',
			 'method' => 'POST',
			 'enctype' => 'multipart/form-data',
			 'display' => 'table'
		 ];
	 $fields =
		 [
			 [
				 'label' => 'Țara',
				 'name' => 'id_tara',
				 'id' => 'id_tara',
				 'type' => 'select',
				 'class' => 'form-control form-control-sm',
				 'options' => $tariSelect,
				 'data-live-search' => 'true',
				 'data-post-endpoint' => $this->appUrl . '/ajax/judete',
				 'defaultOption' => Session::getParam('form-add-strazi')['id_tara']
			 ],
			 [
				 'label' => 'Județ',
				 'name' => 'id_judet',
				 'id' => 'id_judet',
				 'type' => 'select',
				 'class' => 'form-control form-control-sm',
				 'options' => $judetSelected,
				 'data-live-search' => 'true',
				 'data-post-endpoint' => $this->appUrl . '/ajax/orase',
				 'defaultOption' => Session::getParam('form-add-strazi')['id_judet']
			 ],
			 [
				 'label' => 'Localitate',
				 'name' => 'id_localitate',
				 'id' => 'id_localitate',
				 'type' => 'select',
				 'class' => 'form-control form-control-sm',
				 'options' => $localitatiSelect,
				 'data-live-search' => 'true',
				 'data-post-endpoint' => $this->appUrl . '/ajax/localitati',
				 'defaultOption' => Session::getParam('form-add-strazi')['id_localitate']
			 ],

			 [
				 'label' => 'Sat',
				 'name' => 'id_sat',
				 'id' => 'id_sat',
				 'type' => 'select',
				 'class' => 'form-control form-control-sm',
				 'options' => $sateSelect,
				 'data-live-search' => 'true',
				 'data-post-endpoint' => $this->appUrl . '/ajax/sate',
				 'defaultOption' => Session::getParam('form-add-strazi')['id_sat']
			 ],
			 [
				 'label' => 'Nume Strada',
				 'name' => 'nume_strada',
				 'id' => 'nume_strada',
				 'placeholder' => 'ex: 32E',
				 'class' => 'form-control form-control-sm',
				 'value' => Session::getParam('form-add-strazi')['nume_strada']
			 ],
			 [
				 'label' => 'OFP',
				 'name' => 'ofp',
				 'id' => 'ofp',
				 'placeholder' => 'ex: 32E',
				 'class' => 'form-control form-control-sm',
				 'value' => Session::getParam('form-add-strazi')['ofp']
			 ],
			 [
				 'label' => 'Cod poștal',
				 'name' => 'cod_postal',
				 'id' => 'cod_postal',
				 'placeholder' => 'ex: 107244',
				 'class' => 'form-control form-control-sm',
				 'value' => Session::getParam('form-add-strazi')['cod_postal']
			 ],
			 [
				 'label' => 'Cod poștal nou',
				 'name' => 'cod_postal_nou',
				 'id' => 'cod_postal_nou',
				 'placeholder' => 'ex: 1242',
				 'class' => 'form-control form-control-sm',
				 'value' => Session::getParam('form-add-strazi')['cod_postal_nou']
			 ],

			 [
				 'id' => 'save',
				 'name' => 'save',
				 'type' => 'submit',
				 'class' => 'btn btn-success btn-sm',
				 'value' => 'Adaugă strada'
			 ]
		 ];
		 View::render('admin/add_strazi',
		 [
			 'pageTitle' => 'Strazi / Adaugă strada',
			 'pageHeader' => 'Crează strada',
			 'form' => ArrayForm::build($form,$fields)
		 ]);
}
/**
	 * @throws \ReflectionException
	 */
public function save()
{
	 if(Request::hasArgument('save','POST'))
	 {
		 $error = null;
		 $data = Request::post();
		 unset($data['save']);
		 /**
			 * Map form params to session in case we need
			 * to correct something
			 */
		 Session::sendTheseToSession
		 (
			 [
				 'form-add-strazi' => $data
			 ]
		 );

		 $fileId = 0;
		 /**
			 * Add elev entry
			 */
		 $rules =
			 [
				 'nume_strada' => ['required'],
				 'id_tara' => ['required'],
				 'id_judet' => ['required'],
	 'id_localitate' => ['required']
			 ];
		 $errors =
			 [
				 'nume_strada' => 'Câmpul este obligatoriu',
				 'id_tara' => 'Câmpul este obligatoriu',
				 'id_judet' => 'Câmpul este obligatoriu',
	 'id_localitate' => 'Câmpul este obligatoriu',
			 ];
		 $validate = Validation::validate($rules,$errors);
		 if($validate['status'])
		 {
			 /**
				 * Begin saving data
				 */
			 if(\App\Models\Strazi::all()->where('nume_strada','=',Request::getArgument('nume_strada','POST'))->count() < 1000)
			 {
				 try{
					 $create = \App\Models\Strazi::create($data);
					 SystemLogger::log('strazi','O strada a fost adaugata! :'. ArrayUtility::arrayToList($data));
					 Session::unsetSession('form-add-strazi');
				 }
				 catch (\Exception $e)
				 {
					 $error = $e->getMessage();
				 }
			 }
			 else
			 {
				 $error = 'Exista deja o strada cu numele introdus!';
			 }
		 }
		 else
		 {
			 $error = Validation::renderErrors($validate['error']);
		 }
		 View::render('admin/save_strazi',
			 [
				 'pageTitle' => 'Strazi / Adaugă strada',
				 'pageHeader' => 'Crează strada',
				 'error' => $error
			 ]);
	 }
}
/**
	 * @param $request
	 */
public function view($request)
{
	 $id = (int) $request;
	 $data = \App\Models\Strazi::all()->where('id', '=', $id)->first();

	 if($data)
	 {
		
		 $tari = Tari::all()->toArray();
		 $judete = Judete::all()->toArray();
$localitati = Localitati::all()->toArray();
$Sate = Sate::all()->toArray();

		 $tariSelect = [];
		 $tariSelect[''] = 'Selecteaza Țara';

		 if($tari)
		 {
			 foreach ($tari as $tara)
			 {
				 $tariSelect[$tara['id']] = $tara['nume_tara'];
			 }
		 }
	 $judeteSelect = [];
	 $judeteSelect[''] = 'Selecteaza Judetul';
	
		 if($judete)
		 {
			 foreach ($judete as $judet)
			 {
				 $judeteSelect[$judet['id']] = $judet['nume_judet'];
			 }
		 }
	 $localitatiSelect = [];
	 $localitatiSelect[''] = 'Selecteaza Localitatea';
	
		 if($localitati)
		 {
			 foreach ($localitati as $localitate)
			 {
				 $localitatiSelect[$localitate['id']] = $localitate['nume_localitate'];
			 }
		 }
	 $sateSelect = [];
	 $sateSelect[''] = 'Selecteaza Satul';
	
		 if($sate)
		 {
			 foreach ($sate as $sat)
			 {
				 $sateSelect[$sat['id']] = $sat['nume_sat'];
			 }
		 }

		 $form =
			 [
				 'action' => $this->appUrl.'/admin/strazi/update/'.$id,
				 'method' => 'POST',
				 'enctype' => 'multipart/form-data',
				 'display' => 'table'
			 ];
		 $fields =
			 [
				 [
					 'label' => 'Țara ',
					 'name' => 'id_tara',
					 'id' => 'id_tara',
					 'type' => 'select',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'options' => $tariSelect,
					 'data-live-search' => 'true',
					 'data-post-endpoint' => $this->appUrl . '/ajax/tari',
					 'defaultOption' => $data->id_tara,
					 'readonly' => 'readonly'
				 ],

				 [
					 'label' => 'Județ ',
					 'name' => 'id_judet',
					 'id' => 'id_judet',
					 'type' => 'select',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'options' => $judeteSelect,
					 'data-live-search' => 'true',
					 'data-post-endpoint' => $this->appUrl . '/ajax/judete',
					 'defaultOption' => $data->id_judet,
					 'readonly' => 'readonly'
				 ],
				 [
					 'label' => 'Localitate ',
					 'name' => 'id_localitate',
					 'id' => 'id_localitate',
					 'type' => 'select',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'options' => $localitatiSelect,
					 'data-live-search' => 'true',
					 'data-post-endpoint' => $this->appUrl . '/ajax/localitati',
					 'defaultOption' => $data->id_localitate,
					 'readonly' => 'readonly'
				 ],
				 [
					 'label' => 'Sat ',
					 'name' => 'id_sat',
					 'id' => 'id_sat',
					 'type' => 'select',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'options' => $sateSelect,
					 'data-live-search' => 'true',
					 'data-post-endpoint' => $this->appUrl . '/ajax/sate',
					 'defaultOption' => $data->id_sat,
					 'readonly' => 'readonly'
				 ],
	
				 [
					 'label' => 'Nume Strada ',
					 'name' => 'nume_strada',
					 'id' => 'nume_strada',
					 'class' => 'form-control form-control-sm',
					 'value' => $data->nume_strada,
					 'readonly' => 'readonly'
				 ],
				 [
					 'label' => 'OFP ',
					 'name' => 'ofp',
					 'id' => 'ofp',
					 'class' => 'form-control form-control-sm',
					 'value' => $data->ofp,
					 'readonly' => 'readonly'
				 ],
				 [
					 'label' => 'Cod poștal ',
					 'name' => 'cod_postal',
					 'id' => 'cod_postal',
					 'class' => 'form-control form-control-sm',
					 'value' => $data->cod_postal,
					 'readonly' => 'readonly'
				 ],
				 [
					 'label' => 'Cod poștal nou ',
					 'name' => 'cod_postal_nou',
					 'id' => 'cod_postal_nou',
					 'class' => 'form-control form-control-sm',
					 'value' => $data->cod_postal_nou,
					 'readonly' => 'readonly'
				 ]
			 ];
		 View::render('admin/view_strazi',
			 [
				 'pageTitle' => 'Strazi / Detalii Strazi',
				 'pageHeader' => 'Detalii Strazi',
				 'form' => ArrayForm::build($form,$fields),
				 'data' => $data,
				 'id' => $id
			 ]);
	 }
	 else
	 {
		 Request::redirect($this->appUrl.'/admin/strazi');
	 }
}
/**
	 * @param $request
	 */
public function edit($request)
{
	 $id = (int) $request;
	 $data = \App\Models\Strazi::all()->where('id', '=', $id)->first();

	 if($data)
	 {
		
		 $tari = Tari::all()->toArray();
		 $judete = Judete::all()->toArray();
$localitati = Localitati::all()->toArray();
$sate = Sate::all()->toArray();

		 $tariSelect = [];
		 $tariSelect[''] = 'Selecteaza Țara';

		 if($tari)
		 {
			 foreach ($tari as $tara)
			 {
				 $tariSelect[$tara['id']] = $tara['nume_tara'];
			 }
		 }

		 $judeteSelect = [];
		 $judeteSelect[''] = 'Selecteaza Judetul';
	
		 if($judete)
		 {
			 foreach ($judete as $judet)
			 {
				 $judeteSelect[$judet['id']] = $judet['nume_judet'];
			 }
		 }
	 $localitatiSelect = [];
	 $localitatiSelect[''] = 'Selecteaza Localitatea';
		 if($localitati)
		 {
			 foreach ($localitati as $localitate)
			 {
				 $localitatiSelect[$localitate['id']] = $localitate['nume_localitate'];
			 }
		 }
	 $sateSelect = [];
	 $sateSelect[''] = 'Selecteaza Satul';
		 if($sate)
		 {
			 foreach ($sate as $sat)
			 {
				 $lsateSelect[$sat['id']] = $sat['nume_sat'];
			 }
		 }

		 $form =
			 [
				 'action' => $this->appUrl.'/admin/strazi/update/'.$id,
				 'method' => 'POST',
				 'enctype' => 'multipart/form-data',
				 'display' => 'table'
			 ];
		 $fields =
			 [
				 [
					 'label' => 'Țara',
					 'name' => 'id_tara',
					 'id' => 'id_tara',
					 'type' => 'select',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'options' => $tariSelect,
					 'data-live-search' => 'true',
					 'data-post-endpoint' => $this->appUrl . '/ajax/tari',
					 'defaultOption' => $data->id_tara
				 ],
				
				 [
					 'label' => 'Județ',
					 'name' => 'id_judet',
					 'id' => 'id_judet',
					 'type' => 'select',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'options' => $judeteSelect,
					 'data-live-search' => 'true',
					 'data-post-endpoint' => $this->appUrl . '/ajax/judete',
					 'defaultOption' => $data->id_judet
				 ],
				 [
					 'label' => 'Localitate',
					 'name' => 'id_localitate',
					 'id' => 'id_localitate',
					 'type' => 'select',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'options' => $localitatiSelect,
					 'data-live-search' => 'true',
					 'data-post-endpoint' => $this->appUrl . '/ajax/localitati',
					 'defaultOption' => $data->id_localitate
				 ],
				 [
					 'label' => 'Sat',
					 'name' => 'id_sat',
					 'id' => 'id_sat',
					 'type' => 'select',
					 'class' => 'form-control form-control-sm',
					 'options' => $sateSelect,
					 'data-live-search' => 'true',
					 'data-post-endpoint' => $this->appUrl . '/ajax/sate',
					 'defaultOption' => $data->id_sate
				 ],
	
				 [
					 'label' => 'Nume Strada *',
					 'name' => 'nume_strada',
					 'id' => 'nume_strada',
					 'placeholder' => 'ex: Tudor Vladimirescu',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'value' => $data->nume_strada
				 ],
			
				 [
					 'label' => 'OFP',
					 'name' => 'ofp',
					 'id' => 'ofp',
					 'placeholder' => 'ex: 23E',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'value' => $data->ofp
				 ],
				 [
					 'label' => 'Cod poștal',
					 'name' => 'cod_postal',
					 'id' => 'cod_postal',
					 'placeholder' => 'ex: 107244',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'value' => $data->cod_postal
				 ],
				 [
					 'label' => 'Cod poștal nou',
					 'name' => 'cod_postal_nou',
					 'id' => 'cod_postal_nou',
					 'placeholder' => 'ex: 1244',
					 'class' => 'form-control form-control-sm',
					 'required' => 'required',
					 'value' => $data->cod_postal_nou
				 ],
				 [
					 'id' => 'update',
					 'value' => 'Modifică',
					 'name' => 'update',
					 'type' => 'submit',
					 'class' => 'btn btn-primary btn-sm'
				 ]
			 ];
		 View::render('admin/edit_strazi',
			 [
				 'pageTitle' => 'Strazi / Editează strada',
				 'pageHeader' => 'Editează strada',
				 'form' => ArrayForm::build($form,$fields),
				 'data' => $data,
				 'id' => $id
			 ]);
	 }
	 else
	 {
		 Request::redirect($this->appUrl.'/admin/strazi');
	 }
}
/**
	 * @param $request
	 */
	 public function update($request)
{
	 $id = (int) $request;
	 if(\App\Models\Strazi::where('id','=',$id)->count() == 1)
	 {
		 $error = null;
		 $data = Request::post();
		 unset($data['update']);
		 unset($data['discipline']);
		 $fileId = 0;

		 /**
			 * Add profesor entry
			 */
		 $rules =
		 [
			 'nume_strada' => ['required'],
			 'id_tara' => ['required'],
			 'id_judet' => ['required'],
'id_localitate' => ['required']
		 ];
	 $errors =
		 [
			 'nume_strada' => 'Câmpul este obligatoriu',
			 'id_tara' => 'Câmpul este obligatoriu',
			 'id_judet' => 'Câmpul este obligatoriu',
'id_localitate' => 'Câmpul este obligatoriu'
		 ];
		 $validate = Validation::validate($rules,$errors);
		 if($validate['status'])
		 {
			 /**
				 * Begin updating data
				 */
				 try{
					 $update = \App\Models\Strazi::where('id','=',$id)->update($data);
					 SystemLogger::log('strazi','O strada cu id-ul '.$id.' a fost editata :'. ArrayUtility::arrayToList($data));
					 if($fileId != 0)
					 {
						 \App\Models\Strazi::where('id','=',$id)->update(['fotografie' => $fileId]);
					 }
				 }
				 catch (\Exception $e)
				 {
					 $error = $e->getMessage();
				 }
		 }
		 else
		 {
			 $error = Validation::renderErrors($validate['error']);
		 }
		 View::render('admin/update_strazi',
			 [
				 'pageTitle' => 'Strazi / Editează Strada',
				 'pageHeader' => 'Editează Strada',
				 'error' => $error,
				 'id' => $id
			 ]);
	 }
	 else
	 {
		 Request::redirect($this->appUrl.'/admin/strazi');
	 }
}

/**
	 * @param $request
	 */
public function remove($request)
{
	 $id = (int)$request;
	 $error = null;
	 if (!\App\Models\Strazi::all()->where('id', $id)->first()) {
		 $error = 'Nu s-a gasit strada cu id-ul specificat!';
	 }
	 View::render('admin/remove_strazi', [
		 'pageHeader' => 'Strazi',
		 'pageTitle' => 'Strazi / Șterge Strada',
		 'id' => $id,
		 'error' => $error
	 ]);
}
/**
	 * @param $request
	 */
public function delete($request)
{
	 $id = (int)$request;
	 $error = null;
	 if (\App\Models\Strazi::all()->where('id', $id)->first()) {
		 try {
			 \App\Models\Strazi::where('id', $id)->delete();
			 SystemLogger::log('Strazi', 'Strada cu id-ul: ' . $id . ' a fost ștearsa.');
		 } catch (\Exception $e) {
			 $error = $e->getMessage();
		 }
	 } else {
		 $error = 'Nu s-a gasit nici o strada cu id-ul introdus!!';
	 }
	 View::render('admin/delete_strazi', [
		 'pageHeader' => 'Strazi',
		 'pageTitle' => 'Strazi / Șterge strada',
		 'id' => $id,
		 'error' => $error
	 ]);
}
}

Models Tari

<?php
namespace App\Models;
use Core\Model;
class Tari extends Model
{
protected $table = "tari";
protected $fillable = ["nume_tara", "nume_capitala", "updated_at", "created_at"];

public function judete()
{
	 return $this->hasMany(Judete::class, 'id_judet', 'id');
}
}
?>

Models Ajax

<?php
namespace App\Controllers;
use Core\Controller;
use Core\Request;
use Core\IlluminateDb;
class Ajax extends Controller
{
public function judete()
{
	 $id_tara = Request::hasArgument('id_tara', 'POST') ? Request::getArgument('id_tara', 'POST') : null;
	 $judete = IlluminateDb::table('judete')->where('id_tara', '=', $id_tara)->get(['id', 'nume_judet'])->toJson();
	 echo $judete;
}
/**
	 * @return string
	 */
public function clase()
{
	 $scoala = Request::hasArgument('scoala_id', 'POST') ? Request::getArgument('scoala_id', 'POST') : null;
	 $scoli = IlluminateDb::table('clase')->where('scoala','=',$scoala)->get(['id','nume'])->toJson();
	 return $scoli;
}
/**
	 * @return string
	 */
public function elevi()
{
	 $clasa = Request::hasArgument('clasa','POST') ? Request::getArgument('clasa','POST'):null;
	 $elevi = IlluminateDb::table('elevi')->where('clasa','=',$clasa)->get(['id','cnp','nume','prenume','nr_matricol'])->toJson();
	 return $elevi;
}


}

Models Judete

<?php
namespace App\Models;
use Core\Model;
class Judete extends Model
{
/**
	 * @var string
	 */
protected $table = "judete";
/**
	 * @var string[]
	 */
protected $fillable =
	 [
		 "nume_judet",
		 "id_tara"
	 ];
/**
	 * @return \Illuminate\Database\Eloquent\Relations\HasOne
	 */
public function tara()
{
	 return $this->hasOne(Tari::class, 'id', 'id_tara');
}
/**
	 * @return \Illuminate\Database\Eloquent\Relations\HasOne
	 */
public function getTara()
{
	 return $this->hasOne(Tari::class, 'id', 'id_tara');
}
}
?>

Edited by MarianG, 05 July 2022 - 12:24.
spoilers

#2
MarianG

Posted 05 July 2022 - 11:32

be that as it may

Grup: Moderators
Posts: 31,445
Înscris: 10.08.2005

REGULAMENT

ajutor.png 12.53K 23 downloads

Tu ai o problema de design.
Nu era nevoie sa prezinti tot codul

ai o Clasa Tara care contine Orase, Orase contine Judete, Judete contine Localitati, Localitati contine Strazi
Fiecare Clasa trebuie sa contina o metoda de listare
Nici nu stim exact la ce sa ne asteptam cand rulam codul.

PoC.png 17.39K 24 downloads

#3
d3v1l500

Posted 05 July 2022 - 11:54

New Member

Grup: Junior Members
Posts: 23
Înscris: 26.04.2017

ok.. eu am pus tot codul ca poate imi scapa ceva... dar il post simplifica...

clasele au metoda de afisare din punctul meu de vedere..

Asta-i codul cu form-ul in care bag datele strazilor...

Spoiler

<?php
namespace App\Controllers;
use App\Helpers\SystemLogger;
use App\Models\Files;
use App\Models\Tari;
use App\Models\Judete;
use App\Models\Localitati;
use App\Models\Sate;
use Core\ArrayForm;
use Core\ArrayUtility;
use Core\Controller;
use Core\DebuggerUtility;
use Core\Request;
use Core\Session;
use Core\Validation;
use Core\View;
class Strazi extends Controller
{
public function add()
{
	 $tari = Tari::all()->toArray();
	 $judete = Judete::all()->toArray();
$localitati = Localitati::all()->toArray();
$sate = Sate::all()->toArray();
	 $tariSelect = [];
	 $tariSelect[''] = 'Selecteaza Țara';
	 if($tari)
	 {
		 foreach ($tari as $tara)
		 {
			 $tariSelect[$tara['id']] = $tara['nume_tara'];
		 }
	 }
$judetSelected = [];
	 $judetSelected[''] = 'Selectează judeţul';
	 if(Session::getParam('form-add-strazi')['id_judet'])
	 {
		 $judet = Judete::where('id', '=', Session::getParam('form-add-strazi')['id_judet'])->get(['id','nume_judet'])->first();
		 if($judet)
		 {
			 $judetSelected[$judet['id']] = $judet['nume_judet'];
		 }
	 }
	 $judeteSelect = [];
	 $judeteSelect[''] = 'Selecteaza Judetul';
	
	 if($judete)
	 {
		 foreach ($judete as $judet)
		 {
			 //$judeteSelect[$judet['id']] = $judet['nume_judet'];
		 }
	 }
	 $localitatiSelect = [];
	 $localitatiSelect[''] = 'Selecteaza Localitatea';
	
	 if($localitati)
	 {
		 foreach ($localitati as $localitate)
		 {
			 $localitatiSelect[$localitate['id']] = $localitate['nume_localitate'];
		 }
	 }
	 $sateSelect = [];
	 $sateSelect[''] = 'Selecteaza Satul';
	
	 if($sate)
	 {
		 foreach ($sate as $sat)
		 {
			 $sateSelect[$sat['id']] = $sat['nume_sat'];
		 }
	 }

	 $form =
		 [
			 'action' => $this->appUrl.'/admin/strazi/save',
			 'method' => 'POST',
			 'enctype' => 'multipart/form-data',
			 'display' => 'table'
		 ];
	 $fields =
		 [
			 [
				 'label' => 'Țara',
				 'name' => 'id_tara',
				 'id' => 'id_tara',
				 'type' => 'select',
				 'class' => 'form-control form-control-sm',
				 'options' => $tariSelect,
				 'data-live-search' => 'true',
				 'data-post-endpoint' => $this->appUrl . '/ajax/judete',
				 'defaultOption' => Session::getParam('form-add-strazi')['id_tara']
			 ],
			 [
				 'label' => 'Județ',
				 'name' => 'id_judet',
				 'id' => 'id_judet',
				 'type' => 'select',
				 'class' => 'form-control form-control-sm',
				 'options' => $judetSelected,
				 'data-live-search' => 'true',
				 'data-post-endpoint' => $this->appUrl . '/ajax/orase',
				 'defaultOption' => Session::getParam('form-add-strazi')['id_judet']
			 ],
			 [
				 'label' => 'Localitate',
				 'name' => 'id_localitate',
				 'id' => 'id_localitate',
				 'type' => 'select',
				 'class' => 'form-control form-control-sm',
				 //'options' => $localitatiSelect,
				 'data-live-search' => 'true',
				 'data-post-endpoint' => $this->appUrl . '/ajax/localitati',
				 'defaultOption' => Session::getParam('form-add-strazi')['id_localitate']
			 ],

			 [
				 'label' => 'Sat',
				 'name' => 'id_sat',
				 'id' => 'id_sat',
				 'type' => 'select',
				 'class' => 'form-control form-control-sm',
				 //'options' => $sateSelect,
				 'data-live-search' => 'true',
				 'data-post-endpoint' => $this->appUrl . '/ajax/sate',
				 'defaultOption' => Session::getParam('form-add-strazi')['id_sat']
			 ],
			 [
				 'label' => 'Nume Strada',
				 'name' => 'nume_strada',
				 'id' => 'nume_strada',
				 'placeholder' => 'ex: 32E',
				 'class' => 'form-control form-control-sm',
				 'value' => Session::getParam('form-add-strazi')['nume_strada']
			 ],
			 [
				 'label' => 'OFP',
				 'name' => 'ofp',
				 'id' => 'ofp',
				 'placeholder' => 'ex: 32E',
				 'class' => 'form-control form-control-sm',
				 'value' => Session::getParam('form-add-strazi')['ofp']
			 ],
			 [
				 'label' => 'Cod poștal',
				 'name' => 'cod_postal',
				 'id' => 'cod_postal',
				 'placeholder' => 'ex: 107244',
				 'class' => 'form-control form-control-sm',
				 'value' => Session::getParam('form-add-strazi')['cod_postal']
			 ],
			 [
				 'label' => 'Cod poștal nou',
				 'name' => 'cod_postal_nou',
				 'id' => 'cod_postal_nou',
				 'placeholder' => 'ex: 1242',
				 'class' => 'form-control form-control-sm',
				 'value' => Session::getParam('form-add-strazi')['cod_postal_nou']
			 ],

			 [
				 'id' => 'save',
				 'name' => 'save',
				 'type' => 'submit',
				 'class' => 'btn btn-success btn-sm',
				 'value' => 'Adaugă strada'
			 ]
		 ];
		 View::render('admin/add_strazi',
		 [
			 'pageTitle' => 'Strazi / Adaugă strada',
			 'pageHeader' => 'Crează strada',
			 'form' => ArrayForm::build($form,$fields)
		 ]);
}

Aici sunt initialiate listele pentru afisare...

	 $tari = Tari::all()->toArray();
	 $judete = Judete::all()->toArray();
$localitati = Localitati::all()->toArray();
$sate = Sate::all()->toArray();
	 $tariSelect = [];
	 $tariSelect[''] = 'Selecteaza Țara';
	 if($tari)
	 {
		 foreach ($tari as $tara)
		 {
			 $tariSelect[$tara['id']] = $tara['nume_tara'];
		 }
	 }
	
	 if($judete)
	 {
		 foreach ($judete as $judet)
		 {
			 //$judeteSelect[$judet['id']] = $judet['nume_judet'];
		 }
	 }
	 $localitatiSelect = [];
	 $localitatiSelect[''] = 'Selecteaza Localitatea';
	
	 if($localitati)
	 {
		 foreach ($localitati as $localitate)
		 {
			 $localitatiSelect[$localitate['id']] = $localitate['nume_localitate'];
		 }
	 }
	 $sateSelect = [];
	 $sateSelect[''] = 'Selecteaza Satul';
	
	 if($sate)
	 {
		 foreach ($sate as $sat)
		 {
			 $sateSelect[$sat['id']] = $sat['nume_sat'];
		 }
	 }

iar aici incerc sa fac lista cu judete dependenta de lista cu tari...

$judetSelected = [];
	 $judetSelected[''] = 'Selectează judeţul';
	 if(Session::getParam('form-add-strazi')['id_judet'])
	 {
		 $judet = Judete::where('id', '=', Session::getParam('form-add-strazi')['id_judet'])->get(['id','nume_judet'])->first();
		 if($judet)
		 {
			 $judetSelected[$judet['id']] = $judet['nume_judet'];
		 }
	 }
	 $judeteSelect = [];
	 $judeteSelect[''] = 'Selecteaza Judetul';

Edited by MarianG, 05 July 2022 - 12:25.
fara quote, cu spoiler

#4
MarianG

Posted 05 July 2022 - 12:28

be that as it may

Grup: Moderators
Posts: 31,445
Înscris: 10.08.2005

Ideea unui Proof-Of-Concept este sa ne arati cum functioneaza, sau unde esueaza
Daca ai scapat ceva, iti dai seama pe masura de scrii codul

#5
d3v1l500

Posted 05 July 2022 - 13:16

New Member

Grup: Junior Members
Posts: 23
Înscris: 26.04.2017

MarianG, on 05 iulie 2022 - 12:28, said:

Ideea unui Proof-Of-Concept este sa ne arati cum functioneaza, sau unde esueaza
Daca ai scapat ceva, iti dai seama pe masura de scrii codul

deci... problema este aici...

		$judete_list = [];
		$judete_list[] = ['Selecteaza judet'];
		//$judete = Judete::where('id_tara', '=', Session::getParam('form-add-strazi')['id_tara'])->get(['id','nume_judet'])->first();
		$judete = Judete::all()->where('id_tara', '=', 4)->toArray();
		if ($judete) {
			foreach ($judete as $judet) {
				$judete_list[$judet['id']] = $judet['nume_judet'];
			}
		}

daca las

//$judete = Judete::where('id_tara', '=', Session::getParam('form-add-strazi')['id_tara'])->get(['id','nume_judet'])->first();

nu-mi ia id-ul din lista cu tari ca sa-l compare cu id_tara al judetului ...

daca ii pun id-ul singur merge...

$judete = Judete::all()->where('id_tara', '=', 4)->toArray();

nu inteleg unde si ce gresesc...!

#6
PeRuZzI

Posted 05 July 2022 - 15:22

Member

Grup: Members
Posts: 443
Înscris: 30.12.2005

Daca zici ca atunci cand pui manual id-ul functioneaza, e clar o problema de aici

Session::getParam('form-add-strazi')['id_tara']

Verifica daca aia iti intoarce ce vrei tu.

Si apoi, vad ca atunci cand pui id-ul manual folosesti alta sintaxa, verifica si aia.

Edited by PeRuZzI, 05 July 2022 - 15:23.

Anunturi

Neurochirurgie minim invazivă

"Primum non nocere" este ideea ce a deschis drumul medicinei spre minim invaziv.

Avansul tehnologic extraordinar din ultimele decenii a permis dezvoltarea tuturor domeniilor medicinei. Microscopul operator, neuronavigația, tehnicile anestezice avansate permit intervenții chirurgicale tot mai precise, tot mai sigure. Neurochirurgia minim invazivă, sau prin "gaura cheii", oferă pacienților posibilitatea de a se opera cu riscuri minime, fie ele neurologice, infecțioase, medicale sau estetice.

www.neurohope.ro

Back to Incepatori

▶ 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

© 2001-2024 Softpedia. All rights reserved. Softpedia® and the Softpedia logo are registered trademarks of SoftNews Net SRL.
Ora implicita a Forumului Softpedia este ora standard a Romaniei (GMT+2). Mai multe informatii →
⚠ Postarile afisate pe Forumul Softpedia reprezinta o opinie subiectiva a membrilor care le-au publicat si nu a SoftNews Net SRL.

PHP afisare lista dependenta de alta lista

#1 d3v1l500 Posted 05 July 2022 - 10:35

#2 MarianG Posted 05 July 2022 - 11:32

#3 d3v1l500 Posted 05 July 2022 - 11:54

#4 MarianG Posted 05 July 2022 - 12:28

#5 d3v1l500 Posted 05 July 2022 - 13:16

#6 PeRuZzI Posted 05 July 2022 - 15:22

Anunturi

▶ 0 user(s) are reading this topic

Sign In

#1
d3v1l500

Posted 05 July 2022 - 10:35

#2
MarianG

Posted 05 July 2022 - 11:32

#3
d3v1l500

Posted 05 July 2022 - 11:54

#4
MarianG

Posted 05 July 2022 - 12:28

#5
d3v1l500

Posted 05 July 2022 - 13:16

#6
PeRuZzI

Posted 05 July 2022 - 15:22