Javascript Disabled Detected

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

« 1 / 5 »

Unde gasesc borcane mari 5 - litr...

sfat achiziție bicicleta pli...

NVIDIA Shield Programe Romania IP

Se opreste motorul in mers Golf 5

Probleme cu instalator Casa verde

Linie vinetie mana stanga

Opriri și reporniri dese

Protectie soare/vizuala in interior

Tratament pt piele..canapea

Buget 19k-masina noua-sfaturi

Grosime adeziv gresie

TVA doar la valoarea adaugata sau...

Inregistrare ecran

M-am inregistrat in e-factura. Ca...

Voi cum faceți fața ava...

Spital stomatologic sector 4 grat...

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,416
Î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,416
Î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

Bun venit pe Forumul Softpedia!

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