<?php
//v.1.2.5.3tmp ... verificare si afisare
//v.1.2.5.2 continuare, mai complet
//v.1.2.5.1 in [September 07, 2011 ] = afisare activitati si din menu 3-4 Conturi-Contacte ... primele lucruri, ver.tmp


//v.1.2.4.2 in [September 05, 2011 ] = corectare bug 15.3 adauga (la SELECT) WHERE ... relatie='prospecti'
//v.1.2.4.1 in [September 02, 2011 ] = din v1.2.2
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	
	session_start();
	
	header("Content-Type: text/xml; charset=utf-8");

$NgloArrStr_listaLicentelorUserilor_ClientuluiFirmei=array();//cheia va fi codLicenta, valoarea va fi numele utilizatorul (din cap.3.2)
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	
if(client_cu_licenta_activa()) {
	$entitati_principale = array('prospecti', 'conturi', 'contacte', 'oportunitati','activitati');
	
	$sql_detalii_client = "select * from Clienti where codUser = ...
	$res_detalii_client = mysql_query($sql_detalii_client, $link_bd_crm);
	$detalii_client = mysql_fetch_array($res_detalii_client);
	
	$sql_verif_afisare_ent_proprii =  "select * from ...
	$res_verif_afisare_ent_proprii = mysql_query($sql_verif_afisare_ent_proprii, $link_bd_user);	
	$verif_afisare_ent_proprii = mysql_fetch_array($res_verif_afisare_ent_proprii);
	if($verif_afisare_ent_proprii['Valoare'] == 'da')
		$filtru_entitati_proprii = " AND " . ucfirst($_GET['pagina']) ...
	else
		$filtru_entitati_proprii = "";
	
	if(isset($_GET['ordonare']) and $_GET['ordonare'] != ''){
		$ordonare = $_GET['ordonare'];
	}
	else{
		$ordonare = '';
	}
	
	if(isset($_GET['cautare']) and $_GET['cautare'] != ''){
		$cautare = $_GET['cautare'];
	}
	else{
		$cautare = '';
	}
	
	if(isset($_GET['cod']) and $_GET['cod'] != '' and (in_array($_GET['pagina'], $entitati_principale))) {
		
		$sql_detalii_dir = "select * from Directoare where CodDirector = '".$_GET['cod']."'";
		$res_detalii_dir = mysql_query($sql_detalii_dir, $link_bd_user);
		$verif_num_row = mysql_num_rows($res_detalii_dir);
		$detalii_director = mysql_fetch_array($res_detalii_dir);
		
		$arrdirs = array($detalii_director['CodDirector']);
		$cdirs = " AND (" . ucfirst($_GET['pagina']) . ".CodDirector = '".$detalii_director['CodDirector']."'";
		
		while($cdir = array_pop($arrdirs)){
			$sql_detalii_dir2 = "select * from Directoare where CodDirectorParinte = '".$cdir."' and codClient = '".$_SESSION['uid']."'";
			$res_detalii_dir2 = mysql_query($sql_detalii_dir2, $link_bd_user);
			while($detalii_director2 = mysql_fetch_array($res_detalii_dir2)){
				if($cdirs != ''){ $cdirs .= " OR ";	}
				$cdirs .= ucfirst($_GET['pagina']) . ".CodDirector = '".$detalii_director2['CodDirector']."'";
				array_push($arrdirs, $detalii_director2['CodDirector']);	
			}
		}
		$cdirs .= ") ";	
	}
	if(in_array($_GET['pagina'], $entitati_principale)) {
		
		if($_GET['pagina'] == 'prospecti') {
			$denumire_optiune_ordonare = 'ordonare_prospecti';
			$ordonare_implicita = ' ORDER BY Prospecti.CodProspect';
			$denumire_optiune_campuri_vizibile = 'campuri_vizibile_prospecti';
			$campuri_vizibile_implicit = "Cod,Companie,Nume,Functie,Mobil,Email,Stare,Rating";
		}
		else if($_GET['pagina'] == 'conturi') {
			$denumire_optiune_ordonare = 'ordonare_conturi';
			$ordonare_implicita = ' ORDER BY Conturi.CodCont';
			$denumire_optiune_campuri_vizibile = 'campuri_vizibile_conturi';
			$campuri_vizibile_implicit = "Cod,Companie,Telefon,Nume,Functie,Mobil,Email";
		}
		else if($_GET['pagina'] == 'contacte') {
			$denumire_optiune_ordonare = 'ordonare_contacte';
			$ordonare_implicita = ' ORDER BY Contacte.CodContact';
			$denumire_optiune_campuri_vizibile = 'campuri_vizibile_contacte';
			$campuri_vizibile_implicit = "Cod,Nume,Functie,Companie,Telefon,Mobil,Email";
		}
		else if('activitati' == $_GET['pagina']) {
			$denumire_optiune_ordonare = 'ordonare_activitati';
			$ordonare_implicita = ' ORDER BY Activitati.CodActivitate';
			$denumire_optiune_campuri_vizibile = 'campuri_vizibile_activitati';
			$campuri_vizibile_implicit = "Cod,Responsabil,Data inregistrarii,Data scadentei,Descriere,Companie,Nume,Mobil";
			//campuri ce se vor afisa	1nr.crt	2cod (codpcco???)	3responsabil (nu codul ci numele)	4tipActivitate	5dataInregistrarii	6dataScadentei	7descriere	8joinProspecti.Companie	9numePers	10telefon	11Fax	12mobil	13email
		}
		
		/////////////////////////////////////////////////////////////////////////////////////////////////////
		//(N) cap.1 setez in tbOptiuniLicente noua ordonare a tabelului DACA utilizatorul a dat clic pe capul/antetul de tabel in ACEASTA sesiune de lucru! 
		//(N) Daca NU a dat click pe capul/antetul de tabel atunci ia din "history" (inainte de ultimul logout cum a fost ordonat tabelul) ... vezi "urmatoarea sectiune de cs"
		$sql_verif_ordonare =  "select * from OptiuniLicente where codLicenta = '".$_SESSION['ulicenta']."' and Denumire = '".$denumire_optiune_ordonare."'";
		$res_verif_ordonare = mysql_query($sql_verif_ordonare, $link_bd_user);
		$verif_num_rows_ordonare = mysql_num_rows($res_verif_ordonare);	
		
		if(('' != $ordonare) and (1 == $verif_num_rows_ordonare)){//(N) fac update in tbOptiuniLicente			
			$sql_update_ordonare = "UPDATE OptiuniLicente SET Valoare = '".$ordonare."' WHERE codLicenta = '".$_SESSION['ulicenta']."' AND Denumire = '".$denumire_optiune_ordonare."'";
			$res_update_ordonare = mysql_query($sql_update_ordonare, $link_bd_user);
		}
		else if($ordonare != '' and $verif_num_rows_ordonare == 0){//(N) daca NU a fost "apelata ordonarea dupa un camp" (clic pe capul de tabel) niciodata pana acum, si acum deja "am fost deja click-uit pe capul de tabel atunci fac insert in tbLicente, se va efectua doar o singura data!
			$sql_insert_ordonare = "INSERT INTO OptiuniLicente (codLicenta, Denumire, Valoare) VALUES ('".$_SESSION['ulicenta']."', '".$denumire_optiune_ordonare."', '".$ordonare."')";
			$res_insert_ordonare = mysql_query($sql_insert_ordonare, $link_bd_user);
		}

		//(N) cap1.2 intreb in "history" (inainte de ultimul logout), in tbOptiuniLicente cum am fost ordonat, ca sa stiu ce icoana sa pun ASC/DESC
		$res_verif_ordonare = mysql_query($sql_verif_ordonare, $link_bd_user);
		$verif_ordonare = mysql_fetch_array($res_verif_ordonare);
		
		$op = split(" ", $verif_ordonare['Valoare']);
		$ordonare_camp = $op[0];
		$ordonare_directie = $op[1];
		if($ordonare_directie == "ASC"){
			$ordonare_icon = '<img src="crm/imagini/sort_asc.png" title="Sortare crescatoare" alt="/\" style="width:12px;" />';
		}
		else if($ordonare_directie == "DESC"){
			$ordonare_icon = '<img src="crm/imagini/sort_desc.png" title="Sortare descrescatoare" alt="\/" style="width:12px;" />';
		}
		else{
			$ordonare_icon = '';			
		}
		
		if($verif_ordonare['Valoare'] != '')
			$ordonare_entitate = " ORDER BY ".$verif_ordonare['Valoare'];
		else
			$ordonare_entitate = $ordonare_implicita;
		
		$sql_verif_campuri_vizibile =  "select * from ...
		$res_verif_campuri_vizibile = mysql_query($sql_verif_campuri_vizibile, $link_bd_user);	
		$verif_num_rows_campuri_vizibile = mysql_num_rows($res_verif_campuri_vizibile);
		$verif_campuri_vizibile = mysql_fetch_array($res_verif_campuri_vizibile);
		
		if($verif_num_rows_campuri_vizibile == 1 and $verif_campuri_vizibile['Valoare'] != ''){
			$campuri_vizibile_entitate = explode(",", $verif_campuri_vizibile['Valoare']);
		}
		else if($verif_num_rows_campuri_vizibile == 0){
			$campuri_vizibile_entitate = explode(",", $campuri_vizibile_implicit);
		}
		else{
			$campuri_vizibile_entitate = explode(",", $campuri_vizibile_implicit);
		}
	}
	
	if($_GET['pagina'] == 'home') {
		echo '
		  <div style="text-align: right; color: #1D516D; padding-right: 25px;">
		    <span style="font-size: 14px; font-weight: bold; ">
	          '.$detalii_client['Firma'].' - '.$_SESSION['user'].'
		    </span><br>
		    '.date('d.m.Y').'
		  </div>
		  
		  <div id="sectiuni_home">
		    <div class="sectiuni_home_box">
              <div class="sectiuni_home_box_t">'.'Actiuni'.'</div>
              <div class="sectiuni_home_box_v">
                <div id="actiuni" name="actiuni">
                  
                  <div id="lista_actiuni" name="lista_actiuni" style="height:305px; overflow-y: scroll; ">
                  </div>
                  
                  <textarea id="mesaj_post" name="mesaj_post" style="height: 30px; width: 99%;" ></textarea>
                  <button type="button" name="Posteaza" id="Posteaza" value="Posteaza" class="btn" align="right" onclick="post();" ><span><span>&nbsp&nbsp&nbspPosteaza&nbsp&nbsp&nbsp</span></span></button>
                  
                </div>
              </div>
            </div>
            <div class="sectiuni_home_box">
              <div class="sectiuni_home_box_t">'.'Activitati'.'</div>
               <div class="sectiuni_home_box_v">
                <div id="activitati" name="activitati">
              
                </div>
              </div>
            </div>
		  </div>
		  <div id="sectiuni_home">
		    <div class="sectiuni_home_box">
              <div class="sectiuni_home_box_t">'.'Noutati'.'</div>
               <div class="sectiuni_home_box_v">
                <div id="noutati" name="noutati">
              
                </div>
              </div>
            </div>
            <div class="sectiuni_home_box">
              <div class="sectiuni_home_box_t">'.'Calendar'.'</div>
               <div class="sectiuni_home_box_v">
                <div id="calendar" name="calendar">
              
                </div>
              </div>
            </div>
		  </div>

		';
	}
	else if($_GET['pagina'] == 'activitati') {
		$chk_onclick = 'onclick="operatii_elem_chk_toate_dev(this.name)"'; //!!!
		$tabel_rand_meniu_con = 'oncontextmenu=\'meniu_contextual_corp_crm("'.$lista.'", "'.$_GET['pagina'].'", "'.$_GET['cod'].'", "", ""); return false;\'';
		//(N) cap.2 afisez capul de tabel, <th> ... pun etichetele pt.campuri si icoana pt.asc/desc sau "nimic" dupa care este ordonat tabelul
		echo '
			<table width="100%" border="1" cellpadding="" cellspacing="0" >
			<tbody>
			  <tr name="crm_cap_tabel" id="crm_cap_tabel" '.$tabel_rand_meniu_con.'>
				
				<th width="3%"><strong>Nr</strong></th>';
			  	if(in_array("Cod", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Activitati.CodActivitate' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.CodActivitate DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.CodActivitate ASC\');">';
			      echo '<strong>Cod</strong>';
			  	  if('Activitati.CodActivitate' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Responsabil", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Activitati.Responsabil' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.Responsabil DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.Responsabil ASC\');">';
			      echo '<strong>Responsabil</strong>';
			  	  if('Activitati.Responsabil' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Tip", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Activitati.TipActivitate' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.TipActivitate DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.TipActivitate ASC\');">';
			      echo '<strong>Tip</strong>';
			  	  if('Activitati.TipActivitate' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Data inregistrarii", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Activitati.DataInregistrarii' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.DataInregistrarii DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.DataInregistrarii ASC\');">';
			      echo '<strong>Data inregistrarii</strong>';
			  	  if('Activitati.DataInregistrarii' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Data scadentei", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Activitati.DataScadenta' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.DataScadenta DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.DataScadenta ASC\');">';
			      echo '<strong>Data scadentei</strong>';
			  	  if('Activitati.DataScadenta' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Descriere", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Activitati.Descriere' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.Descriere DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Activitati.Descriere ASC\');">';
			      echo '<strong>Descriere</strong>';
			  	  if('Activitati.Descriere' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Companie", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Prospecti.Companie' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Companie DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Companie ASC\');">';
			      echo '<strong>Companie</strong>';
			  	  if('Prospecti.Companie' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Nume", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Prospecti.Nume' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Nume DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Nume ASC\');">';
			      echo '<strong>Nume</strong>';
			  	  if('Prospecti.Nume' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Telefon", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Prospecti.Telefon' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Telefon DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Telefon ASC\');">';
			      echo '<strong>Telefon</strong>';
			  	  if('Prospecti.Telefon' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Fax", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Prospecti.Fax' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Fax DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Fax ASC\');">';
			      echo '<strong>Fax</strong>';
			  	  if('Prospecti.Fax' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Mobil", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Prospecti.Mobil' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Mobil DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Mobil ASC\');">';
			      echo '<strong>Mobil</strong>';
			  	  if('Prospecti.Mobil' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Email", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Prospecti.Email' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Email DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Email ASC\');">';
			      echo '<strong>Email</strong>';
			  	  if('Prospecti.Email' == $ordonare_camp) echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	
				//(N) afisez (in capul de tabel) si "bifa" de la sfarsitul tabelului ... "selectare rand"
			  	echo '
				<th width="20"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="op_chk_toate_dev" id="op_chk_toate_dev" '.$chk_onclick.'></input></span></th>
				
			  </tr>
			 ';
		
		$_SESSION['corpdevpoz'] = 0;
		
		
		////////////////////////////////////////////////////////////////////////////////////////////////////
		//(N) cap.3 construiesc SELECT-ul (sa obtin si lista de useri cu licente avand "acelasi client")
		//(N) cap.3.1 obtin lista de licente
		$Nloc_uid= $_SESSION['uid'];//obtin id-ul clientuluiFirmei (NU a utilizatorului!)
		$sql_licente ="SELECT codLicenta,user ...
		$res_licente = mysql_query($sql_licente, $link_bd_crm);
		if (!$res_licente) {
			die('N_fis1_rand281 Invalid query= ' . mysql_error());
		}
		$NlocStrLicente='';
		while($NtmpRand283 = mysql_fetch_array($res_licente)){
			$NgloArrStr_listaLicentelorUserilor_ClientuluiFirmei [$NtmpRand283[0]] = $NtmpRand283[1];//key=licenta, value=nume user
		}
		//echo ("<br> (N289) NgloArrStr_listaLicentelorUserilor_ClientuluiFirmei="); print_r($NgloArrStr_listaLicentelorUserilor_ClientuluiFirmei);
		//echo "<br> (N291) lista licente prin string(implode)=" . implode(",",array_keys($NgloArrStr_listaLicentelorUserilor_ClientuluiFirmei)) . " si values=" . implode(",",$NgloArrStr_listaLicentelorUserilor_ClientuluiFirmei);

		$sql_WhereActivitatiResponsabilIN = " AND Activitati.Responsabil IN ('" . implode("','",array_keys($NgloArrStr_listaLicentelorUserilor_ClientuluiFirmei)) . "')" . " " . $filtru_entitati_proprii . $cdirs ; //(N) aici va veni si UNION pe contacte si conturi si ?oportunitati? - sa modifici si Relati = 'contacte' ... 
			// (v.1.2.5.1) ATENTIE! Am scos . $ordonare_entitate si voi pune la sfarsit!
		
		$sql_activitati = "SELECT Activitati.*,Prospecti.Companie,Prospecti.Nume, Prospecti.Telefon,Prospecti.Fax,Prospecti.Mobil,Prospecti.Email FROM Activitati INNER JOIN Prospecti ON Activitati.CodPCCO=Prospecti.CodProspect WHERE ...
		//pentru comentarii la SELECT vezi fisierul "8.7.2 union part 3 conturi.sql"
		
		// pe part.2 "relatie contacte" sunt 3 cazuri 1.1, 1.2 si 2.1
		// caz 1.1 
		// trebuie sa elimin pe cei cu contact principal (erau 8 rezultate in total)
		//... le voi pune tel si faxul de companie ... cpCodActi=2,3,21,27,28 
		$sql_activitati .= "union all select Activitati.*,Conturi.Companie,Contacte.Nume ,Contacte.Telefon ,Contacte.Fax ,Contacte.Mobil ,Contacte.Email from Activitati,Contacte,Conturi where Activitati.Relatie ='contacte' and Activitati.CodPCCO = Contacte.CodContact and ...


		// caz 1.2 
		// trebuie sa pun la cei cu contact principal (2 rez cu cpCodActi=29,32)
		//... tel si faxul de la companie
		$sql_activitati .= "union all select Activitati.*,Conturi.Companie,Contacte.Nume ,Conturi.Telefon ,Conturi.Fax ,Contacte.Mobil ,Contacte.Email from Activitati,Contacte,Conturi where Activitati.Relatie ='contacte' and Activitati.CodPCCO = Contacte.CodContact and Contacte.CodCont = Conturi.CodCont and Conturi.CodContactPrincipal = Contacte.CodContact " .  ...


		// caz 2.1 
		// trebuie sa pun la cei fara companie (=0), codActi=30
		//... "fara companie asociata" 
		$sql_activitati .= "union all select Activitati.*,'fara companie asociata',Contacte.Nume, Contacte.Telefon ,Contacte.Fax ,Contacte.Mobil ,Contacte.Email from Activitati,Contacte "; // NU am nevoie de informatii din tbConturi!
		$sql_activitati .= "where ...

		// pe part.3 "relatie conturi"
		// trebuie sa obtin nume,mobil si email la contact principal (catre cont)
		$sql_activitati .= "union all select Activitati.*,Conturi.Companie,Contacte.Nume ,Conturi.Telefon ,Conturi.Fax ,Contacte.Mobil ,Contacte.Email from Activitati,Conturi,Contacte where Activitati.Relatie ='conturi' and Activitati.CodPCCO = Conturi.CodCont and ...

		
		//ordonarea in SELECT o fac FARA nume tabel.nume camp, insa in tbOptiuniLicente scriu cu nume tabel
		$tmpOp = split(" ", $ordonare_entitate);
		$tmpOrdonare_camp = $tmpOp[3];//ex: tbProspecti.Companie, 0 si 1 sunt order by, s-a adaugat pe undeva inca un spatiu!
		$tmpOrdonare_directie = $tmpOp[4];//ex: ASC sau DESC
		//echo "<br> (N368)" . $tmpOrdonare_camp . $tmpOrdonare_directie .$ordonare_entitate;
			//desfac tmpOrdonare_camp in doua, dupa "."
			//$tmpSplit2 = split (".", $tmpOrdonare_camp);
			//$tmpNumeTb = $tmpSplit2[0];//numele tablului, ex: tbProspecti
			//$tmpNumeCp = $tmpSplit2[1];//numele campului, ex: cpCompanie
		//echo "<br> (N373)"; print_r( $tmpSplit2); echo $tmpNumeCp;
		//$sql_activitati .= $ordonare_entitate;//ex: order by Mobil (trebuie sa scoti nume tabel din fata, fiindca este cu union!
		
		$NtmpMystring = $tmpOrdonare_camp;$NtmpFindme   = '.';
		$NtmpPos = strpos($NtmpMystring, $NtmpFindme);
		$tmpNumeCp = substr($tmpOrdonare_camp,$NtmpPos+1);
		// Note our use of ===.  Simply == would not work as expected
		// because the position of 'a' was the 0th (first) character.
		$sql_activitati .= " order by " . $tmpNumeCp . " " . $tmpOrdonare_directie;
		
		
		echo "<br> (N 385) sql_activitati=" . $sql_activitati;
		$res_activitati = mysql_query($sql_activitati, $link_bd_user);
		
		//(N) cap.4 afisez fiecare rand, apeland functia tabel_crm_rand
		$nr_rand = 0;
		while($rand_activitate = mysql_fetch_array($res_activitati)) {
		 	$nr_rand++; //echo "<br> N" . $nr_rand;
			echo tabel_crm_rand($rand_activitate, $nr_rand, $campuri_vizibile_entitate);
		}
		
		echo '
			</tbody>
			</table>
			';
		//echo $sql_prospecti;
	}
	else if($_GET['pagina'] == 'note') {
		echo 'Pagina note';
	}
	else if($_GET['pagina'] == 'rapoarte') {
		echo 'Pagina rapoarte';
	}
	else if($_GET['pagina'] == 'prospecti') {
	
		$chk_onclick = 'onclick="operatii_elem_chk_toate_dev(this.name)"'; //!!!
		$tabel_rand_meniu_con = 'oncontextmenu=\'meniu_contextual_corp_crm("'.$lista.'", "'.$_GET['pagina'].'", "'.$_GET['cod'].'", "", ""); return false;\'';
		
		echo '
			<table width="100%" border="1" cellpadding="" cellspacing="0" >
			<tbody>
			  <tr name="crm_cap_tabel" id="crm_cap_tabel" '.$tabel_rand_meniu_con.'>
				
				<th width="3%"><strong>Nr</strong></th>';
			  	if(in_array("Cod", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Prospecti.CodProspect' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.CodProspect DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.CodProspect ASC\');">';
			      echo '<strong>Cod</strong>';
			  	  if($ordonare_camp == 'Prospecti.CodProspect') echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Director", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Prospecti.CodDirector' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.CodDirector DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.CodDirector ASC\');">';
			      echo '<strong>Director</strong>';
			  	  if($ordonare_camp == 'Prospecti.CodDirector') echo $ordonare_icon;
			      echo '</th>';
			  	}
				if(in_array("Companie", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Prospecti.Companie' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Companie DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Companie ASC\');">';
			  	  echo '<strong>Companie</strong>';
			  	  if($ordonare_camp == 'Prospecti.Companie') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Nume", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Prospecti.Nume' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Nume DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Nume ASC\');">';
			  	  echo '<strong>Nume</strong>';
			  	  if($ordonare_camp == 'Prospecti.Nume') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Functie", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Prospecti.Functie' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Functie DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Functie ASC\');">';
			  	  echo '<strong>Functie</strong>';
			  	  if($ordonare_camp == 'Prospecti.Functie') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Domeniu", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Prospecti.Domeniu' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Domeniu DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Domeniu ASC\');">';
			  	  echo '<strong>Domeniu</strong>';
			  	  if($ordonare_camp == 'Prospecti.Domeniu') echo $ordonare_icon;
			      echo '</th>';
				} 
				if(in_array("Cifra afaceri", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Prospecti.CifraAfaceri' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.CifraAfaceri DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.CifraAfaceri ASC\');">';
			  	  echo '<strong>Cifra afaceri</strong>';
			  	  if($ordonare_camp == 'Prospecti.CifraAfaceri') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Angajati", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Prospecti.Angajati' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Angajati DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Angajati ASC\');">';
			  	  echo '<strong>Angajati</strong>';
			  	  if($ordonare_camp == 'Prospecti.Angajati') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Website", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Prospecti.Website' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Website DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Website ASC\');">';
			  	  echo '<strong>Website</strong>';
			  	  if($ordonare_camp == 'Prospecti.Website') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Telefon", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Prospecti.Telefon' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Telefon DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Telefon ASC\');">';
			  	  echo '<strong>Telefon</strong>';
			  	  if($ordonare_camp == 'Prospecti.Telefon') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Fax", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.Fax' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Fax DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Fax ASC\');">';
			  	  echo '<strong>Fax</strong>';
			  	  if($ordonare_camp == 'Prospecti.Fax') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Mobil", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.Mobil' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Mobil DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Mobil ASC\');">';
			  	  echo '<strong>Mobil</strong>';
			  	  if($ordonare_camp == 'Prospecti.Mobil') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Email", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.Email' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Email DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Email ASC\');">';
			  	  echo '<strong>Email</strong>';
			  	  if($ordonare_camp == 'Prospecti.Email') echo $ordonare_icon;
			      echo '</th>'; 
				}
				if(in_array("Strada", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.Strada' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Strada DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Strada ASC\');">';
			  	  echo '<strong>Strada</strong>';
			  	  if($ordonare_camp == 'Prospecti.Strada') echo $ordonare_icon;
			      echo '</th>'; 
				}
				if(in_array("Oras", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.Oras' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Oras DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Oras ASC\');">';
			  	  echo '<strong>Oras</strong>';
			  	  if($ordonare_camp == 'Prospecti.Oras') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Cod postal", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.CodPostal' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.CodPostal DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.CodPostal ASC\');">';
			  	  echo '<strong>Cod postal</strong>';
			  	  if($ordonare_camp == 'Prospecti.CodPostal') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Judet", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.Judet' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Judet DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Judet ASC\');">';
			  	  echo '<strong>Judet</strong>';
			  	  if($ordonare_camp == 'Prospecti.Judet') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Tara", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.Tara' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Tara DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.Tara ASC\');">';
			  	  echo '<strong>Tara</strong>';
			  	  if($ordonare_camp == 'Prospecti.Tara') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Stare", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.StareProspect' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.StareProspect DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.StareProspect ASC\');">';
			  	  echo '<strong>Stare</strong>';
			  	  if($ordonare_camp == 'Prospecti.StareProspect') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Rating", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.RatingProspect' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.RatingProspect DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.RatingProspect ASC\');">';
			  	  echo '<strong>Rating</strong>';
			  	  if($ordonare_camp == 'Prospecti.RatingProspect') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Sursa informare", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Prospecti.SursaInformare' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.SursaInformare DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Prospecti.SursaInformare ASC\');">';
			  	  echo '<strong>Sursa</strong>';
			  	  if($ordonare_camp == 'Prospecti.SursaInformare') echo $ordonare_icon;
			      echo '</th>';
				}
				echo '
				<th width="20"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="op_chk_toate_dev" id="op_chk_toate_dev" '.$chk_onclick.'></input></span></th>
				
			  </tr>
			 ';
		
		$_SESSION['corpdevpoz'] = 0;
		
		if($cautare != ''){
		}
		else{
			$sql_prospecti = "SELECT * FROM Prospecti WHERE codClient = '".$_SESSION['uid']."' ".$filtru_entitati_proprii.$cdirs.$ordonare_entitate;
		}
		$res_prospecti = mysql_query($sql_prospecti, $link_bd_user);
		
		$nr_rand = 0;
		while($rand_prospect = mysql_fetch_array($res_prospecti)) {			
		 	$nr_rand++;
			echo tabel_crm_rand($rand_prospect, $nr_rand, $campuri_vizibile_entitate);
		}
		
		echo '
			</tbody>
			</table>
			';
			
		//echo $sql_prospecti;
	}
	else if($_GET['pagina'] == 'conturi') {
		
		$chk_onclick = 'onclick="operatii_elem_chk_toate_dev(this.name)"'; //!!!
		$tabel_rand_meniu_con = 'oncontextmenu=\'meniu_contextual_corp_crm("'.$lista.'", "'.$_GET['pagina'].'", "'.$_GET['cod'].'", "", ""); return false;\'';
		
		echo '
			<table width="100%" border="1" cellpadding="" cellspacing="0" >
			<tbody>
			  <tr name="crm_cap_tabel" id="crm_cap_tabel" '.$tabel_rand_meniu_con.'>
				<th width="3%"><strong>Nr</strong></th>';
			  	if(in_array("Cod", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Conturi.CodCont' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CodCont DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CodCont ASC\');">';
			      echo '<strong>Cod</strong>';
			  	  if($ordonare_camp == 'Conturi.CodCont') echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Director", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Conturi.CodDirector' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CodDirector DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CodDirector ASC\');">';
			      echo '<strong>Director</strong>';
			  	  if($ordonare_camp == 'Conturi.CodDirector') echo $ordonare_icon;
			      echo '</th>';
			  	}
				if(in_array("Companie", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Conturi.Companie' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Companie DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Companie ASC\');">';
			  	  echo '<strong>Companie</strong>';
			  	  if($ordonare_camp == 'Conturi.Companie') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Domeniu", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Conturi.Domeniu' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Domeniu DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Domeniu ASC\');">';
			  	  echo '<strong>Domeniu</strong>';
			  	  if($ordonare_camp == 'Conturi.Domeniu') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Website", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Conturi.Website' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Website DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Website ASC\');">';
			  	  echo '<strong>Website</strong>';
			  	  if($ordonare_camp == 'Conturi.Website') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Strada", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Conturi.Strada' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Strada DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Strada ASC\');">';
			  	  echo '<strong>Strada</strong>';
			  	  if($ordonare_camp == 'Conturi.Strada') echo $ordonare_icon;
			      echo '</th>';
				} 
				if(in_array("Oras", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Conturi.Oras' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Oras DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Oras ASC\');">';
			  	  echo '<strong>Oras</strong>';
			  	  if($ordonare_camp == 'Conturi.Oras') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Cod postal", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Conturi.CodPostal' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CodPostal DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CodPostal ASC\');">';
			  	  echo '<strong>Cod postal</strong>';
			  	  if($ordonare_camp == 'Conturi.CodPostal') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Judet", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Conturi.Judet' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Judet DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Judet ASC\');">';
			  	  echo '<strong>Judet</strong>';
			  	  if($ordonare_camp == 'Conturi.Judet') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Tara", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Conturi.Tara' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Tara DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Tara ASC\');">';
			  	  echo '<strong>Tara</strong>';
			  	  if($ordonare_camp == 'Conturi.Tara') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Telefon", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Conturi.Telefon' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Telefon DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Telefon ASC\');">';
			  	  echo '<strong>Telefon</strong>';
			  	  if($ordonare_camp == 'Conturi.Telefon') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Fax", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Conturi.Fax' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Fax DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Fax ASC\');">';
			  	  echo '<strong>Fax</strong>';
			  	  if($ordonare_camp == 'Conturi.Fax') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Banca", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Conturi.Banca' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Banca DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Banca ASC\');">';
			  	  echo '<strong>Banca</strong>';
			  	  if($ordonare_camp == 'Conturi.Banca') echo $ordonare_icon;
			      echo '</th>';
				}
				
				if(in_array("Cont banca", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Conturi.ContBanca' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.ContBanca DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.ContBanca ASC\');">';
			  	  echo '<strong>Cont Banca</strong>';
			  	  if($ordonare_camp == 'Conturi.ContBanca') echo $ordonare_icon;
			      echo '</th>'; 
				}
				if(in_array("C.U.I.", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Conturi.CUI' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CUI DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CUI ASC\');">';
			  	  echo '<strong>C.U.I.</strong>';
			  	  if($ordonare_camp == 'Conturi.CUI') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Nr. Reg. Com.", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Conturi.NrRegCom' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.NrRegCom DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.NrRegCom ASC\');">';
			  	  echo '<strong>Nr. Reg. Com.</strong>';
			  	  if($ordonare_camp == 'Conturi.NrRegCom') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Cifra afaceri", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Conturi.CifraAfaceri' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CifraAfaceri DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.CifraAfaceri ASC\');">';
			  	  echo '<strong>Cifra afaceri</strong>';
			  	  if($ordonare_camp == 'Conturi.CifraAfaceri') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Angajati", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Conturi.Angajati' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Angajati DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Angajati ASC\');">';
			  	  echo '<strong>Angajati</strong>';
			  	  if($ordonare_camp == 'Conturi.Angajati') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Nume", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Nume' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Nume DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Nume ASC\');">';
			  	  echo '<strong>Contact principal</strong>';
			  	  if($ordonare_camp == 'Contacte.Nume') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Functie", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Functie' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Functie DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Functie ASC\');">';
			  	  echo '<strong>Functie</strong>';
			  	  if($ordonare_camp == 'Contacte.Functie') echo $ordonare_icon;
			      echo '</th>'; 
				}
				if(in_array("Mobil", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Mobil' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Mobil DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Mobil ASC\');">';
			  	  echo '<strong>Mobil</strong>';
			  	  if($ordonare_camp == 'Contacte.Mobil') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Email", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Email' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Email DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Email ASC\');">';
			  	  echo '<strong>Email</strong>';
			  	  if($ordonare_camp == 'Contacte.Email') echo $ordonare_icon;
			      echo '</th>'; 
				}
				if(in_array("Sursa informare", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.SursaInformare' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.SursaInformare DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.SursaInformare ASC\');">';
			  	  echo '<strong>Sursa</strong>';
			  	  if($ordonare_camp == 'Contacte.SursaInformare') echo $ordonare_icon;
			      echo '</th>';
				}
				echo '
				<th width="20"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="op_chk_toate_dev" id="op_chk_toate_dev" '.$chk_onclick.'></input></span></th>
			  </tr>
			';
		
		$_SESSION['corpdevpoz'] = 0;
		
		if($cautare != ''){
		}
		else{
		}		
		$res_conturi = mysql_query($sql_conturi, $link_bd_user);
		
		$nr_rand = 0;
		while($rand_cont = mysql_fetch_array($res_conturi)) {			
		 	$nr_rand++;
			echo tabel_crm_rand($rand_cont, $nr_rand, $campuri_vizibile_entitate);
		}		
	 
		echo '
			</tbody>
			</table>';
	}
	else if($_GET['pagina'] == 'contacte') {
		
		$chk_onclick = 'onclick="operatii_elem_chk_toate_dev(this.name)"'; //!!!
		$tabel_rand_meniu_con = 'oncontextmenu=\'meniu_contextual_corp_crm("'.$lista.'", "'.$_GET['pagina'].'", "'.$_GET['cod'].'", "", ""); return false;\'';
		
		echo '
			<table width="100%" border="1" cellpadding="" cellspacing="0" >
			<tbody>
			  <tr name="crm_cap_tabel" id="crm_cap_tabel" '.$tabel_rand_meniu_con.'>
				<th width="3%"><strong>Nr</strong></th>';
			  	if(in_array("Cod", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Contacte.CodContact' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.CodContact DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.CodContact ASC\');">';
			      echo '<strong>Cod</strong>';
			  	  if($ordonare_camp == 'Contacte.CodContact') echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Director", $campuri_vizibile_entitate)){
			  	  if($ordonare_camp == 'Contacte.CodDirector' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.CodDirector DESC\');">';
			      else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.CodDirector ASC\');">';
			      echo '<strong>Director</strong>';
			  	  if($ordonare_camp == 'Contacte.CodDirector') echo $ordonare_icon;
			      echo '</th>';
			  	}
			  	if(in_array("Nume", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Nume' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Nume DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Nume ASC\');">';
			  	  echo '<strong>Nume</strong>';
			  	  if($ordonare_camp == 'Contacte.Nume') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Functie", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Functie' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Functie DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Functie ASC\');">';
			  	  echo '<strong>Functie</strong>';
			  	  if($ordonare_camp == 'Contacte.Functie') echo $ordonare_icon;
			      echo '</th>'; 
				}
				if(in_array("Companie", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Conturi.Companie' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Companie DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Conturi.Companie ASC\');">';
			  	  echo '<strong>Companie</strong>';
			  	  if($ordonare_camp == 'Conturi.Companie') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Cnp", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Contacte.Cnp' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Cnp DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Cnp ASC\');">';
			  	  echo '<strong>CNP</strong>';
			  	  if($ordonare_camp == 'Contacte.Cnp') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Strada", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Contacte.Strada' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Strada DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Strada ASC\');">';
			  	  echo '<strong>Strada</strong>';
			  	  if($ordonare_camp == 'Contacte.Strada') echo $ordonare_icon;
			      echo '</th>';
				} 
				if(in_array("Oras", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Oras' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Oras DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Oras ASC\');">';
			  	  echo '<strong>Oras</strong>';
			  	  if($ordonare_camp == 'Contacte.Oras') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Cod postal", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.CodPostal' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.CodPostal DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.CodPostal ASC\');">';
			  	  echo '<strong>Cod postal</strong>';
			  	  if($ordonare_camp == 'Contacte.CodPostal') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Judet", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Judet' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Judet DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Judet ASC\');">';
			  	  echo '<strong>Judet</strong>';
			  	  if($ordonare_camp == 'Contacte.Judet') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Tara", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Tara' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Tara DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Tara ASC\');">';
			  	  echo '<strong>Tara</strong>';
			  	  if($ordonare_camp == 'Contacte.Tara') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Telefon", $campuri_vizibile_entitate)){
				  if($ordonare_camp == 'Contacte.Telefon' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Telefon DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Telefon ASC\');">';
			  	  echo '<strong>Telefon</strong>';
			  	  if($ordonare_camp == 'Contacte.Telefon') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Fax", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Fax' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Fax DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Fax ASC\');">';
			  	  echo '<strong>Fax</strong>';
			  	  if($ordonare_camp == 'Contacte.Fax') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Mobil", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Mobil' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Mobil DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Mobil ASC\');">';
			  	  echo '<strong>Mobil</strong>';
			  	  if($ordonare_camp == 'Contacte.Mobil') echo $ordonare_icon;
			      echo '</th>';
				}
				if(in_array("Email", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.Email' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Email DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.Email ASC\');">';
			  	  echo '<strong>Email</strong>';
			  	  if($ordonare_camp == 'Contacte.Email') echo $ordonare_icon;
			      echo '</th>'; 
				}
				if(in_array("Sursa informare", $campuri_vizibile_entitate)){ 
				  if($ordonare_camp == 'Contacte.SursaInformare' and $ordonare_directie == 'ASC') echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.SursaInformare DESC\');">';
			  	  else echo '<th onclick="javascript:sortare(\''.$_GET['cod'].'\', \'Contacte.SursaInformare ASC\');">';
			  	  echo '<strong>Sursa</strong>';
			  	  if($ordonare_camp == 'Contacte.SursaInformare') echo $ordonare_icon;
			      echo '</th>';
				}
	
				echo '
				<th width="20"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="op_chk_toate_dev" id="op_chk_toate_dev" '.$chk_onclick.'></input></span></th>
			  </tr>
			 ';
		
		$_SESSION['corpdevpoz'] = 0;
	 		
		if($cautare != ''){
		}
		else{
			$sql_contacte = "SELECT Contacte.* FROM Contacte WHERE Contacte.codClient = '".$_SESSION['uid']."'".$filtru_entitati_proprii.$cdirs.$ordonare_entitate;
		}
		
		$res_contacte = mysql_query($sql_contacte, $link_bd_user);
		
		$nr_rand = 0;
		while($rand_contact = mysql_fetch_array($res_contacte)) {			
		 	$nr_rand++;
			echo tabel_crm_rand($rand_contact, $nr_rand, $campuri_vizibile_entitate);
		}		
	 
		echo '
			</tbody>
			</table>';
	}
	else if($_GET['pagina'] == 'oportunitati') {
		
		$chk_onclick = 'onclick="operatii_elem_chk_toate_dev(this.name)"'; //!!!
		$tabel_rand_meniu_con = '';
		
		echo '
			<table width="100%" border="1" cellpadding="" cellspacing="0" >
			<tbody>
			  <tr name="crm_cap_tabel" id="crm_cap_tabel" '.$tabel_rand_meniu_con.'>
				<th width="3%"><strong>Nr</strong></th>
				<th width="7%"><strong>Cod</strong></th>
				<th width="20%"><strong>Denumire</strong></th>
				<th width="20%"><strong>Referitoare la</strong></th>
				<th width="15%"><strong>Stare</strong></th>
				<th width="10%"><strong>Probabilitate</strong></th>
				<th width="10%"><strong>Suma</strong></th>
				<th width="15%"><strong>Data scadenta</strong></th>
				<th width="20"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="op_chk_toate_dev" id="op_chk_toate_dev" '.$chk_onclick.'></input></span></th>
			  </tr>
			 ';
		
		$_SESSION['corpdevpoz'] = 0;
	 
		$sql_oportunitati = "SELECT * FROM Oportunitati WHERE codClient = '".$_SESSION['uid']."'".$filtru_entitati_proprii.$cdirs;
		$res_oportunitati = mysql_query($sql_oportunitati, $link_bd_user);
		
		$nr_rand = 0;
		while($rand_oportunitate = mysql_fetch_array($res_oportunitati)) {			
		 	$nr_rand++;
			echo tabel_crm_rand($rand_oportunitate, $nr_rand);
		}			 
			 
		echo '
			</tbody>
			</table>';
	}
	else {
		echo '	
			<table width="100%" border="1" cellpadding="" cellspacing="0" >
			<tbody>
			  <tr name="crm_cap_tabel" id="crm_cap_tabel">
			  
				<th ><strong>tabel '.$_GET['pagina'].', director '.$_GET['cod'].'</strong></th>
				
			  </tr>
			</tbody>
			</table>';
	}
	
}//sfarsit verificare functie - client_cu_licenta_activa

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////
function tabel_crm_rand($rand_corp_crm, $nr_rand, $campuri_vizibile){
	global $link_bd_user;
	global $mysqli_user;
	global $NgloArrStr_listaLicentelorUserilor_ClientuluiFirmei;
	
	$sql_detalii_dir = "select * from Directoare where CodDirector = '".$rand_corp_crm['CodDirector']."'";
	$res_detalii_dir = mysql_query($sql_detalii_dir, $link_bd_user);
	$detalii_director= mysql_fetch_array($res_detalii_dir);
	
	$tabel_rand = '';
	
	if($_GET['pagina'] == 'prospecti') {
		$stare_arr = array("","Deschis","Contactat","Calificat","Necalificat");
		$rating_arr = array("","Scazut","Mediu","Ridicat");
		
		$_SESSION['corpdevpoz']++;
		
		$nume_clasa_nr_rand = 'corpdevpoz-'.$_SESSION['corpdevpoz'].'';
		$nume_clasa_cod_rand = 'codrand-'.$rand_corp_crm['CodProspect'].'';
		
		$rand_bg_culoare = 'bgcolor="#ffffcc"';
		$rand_name_id = 'entitate-'.$rand_corp_crm['CodProspect'].'-'.$_SESSION['corpdevpoz'].'';
		$rand_clasa = 'articol rand_corpdev '.$nume_clasa_nr_rand.' '.$nume_clasa_cod_rand.'';
		$tip_element = 'entitate';
		$tabel_rand_meniu_con = 'oncontextmenu=\'meniu_contextual_corp_crm("'.$lista.'", "'.$_GET['pagina'].'", "'.$_GET['cod'].'", "'.$rand_name_id.'", "'.$tip_element.'"); return false;\'';
		$nume_operatii_chk = 'OpEntitate-'.$rand_corp_crm['CodProspect'].'-'.$_SESSION['corpdevpoz'].''; //operatii chk
		$operatii_chk_dev = 'operatii_chk_dev';
		$chk_onclick = 'onclick=\'chk_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'", "chk");\'';
		$rand_onclick = 'onclick=\'rand_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'");\'';
		$rand_ondblclick = 'ondblclick=\'fereastra_prospecti_ad_ed("gen","'.$_GET['cod'].'","editare","1","");\'';
		//rand corp crm		
		$tabel_rand = 
		'<tr '.$rand_bg_culoare.' id="'.$rand_name_id.'" name="'.$rand_name_id.'" class="'.$rand_clasa.'" '.$tabel_rand_meniu_con.' '.$rand_onclick.' '.$rand_ondblclick.'>
			<td width="3%">'.$nr_rand.'</td>';
			if(in_array("Cod", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CodProspect'].'</td>'; }
			if(in_array("Director", $campuri_vizibile)){ $tabel_rand .= '<td>'.$detalii_director['NumeDirector'].'</td>'; }
			if(in_array("Companie", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Companie'].'</td>'; }
			if(in_array("Nume", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Nume'].'</td>'; }
			if(in_array("Functie", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Functie'].'</td>'; }
			if(in_array("Domeniu", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Domeniu'].'</td>'; }
			if(in_array("Cifra afaceri", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CifraAfaceri'].'</td>'; }
			if(in_array("Angajati", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Angajati'].'</td>'; }
			if(in_array("Website", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Website'].'</td>'; }
			if(in_array("Telefon", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Telefon'].'</td>'; }
			if(in_array("Fax", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Fax'].'</td>'; }
			if(in_array("Mobil", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Mobil'].'</td>'; }
			if(in_array("Email", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Email'].'</td>'; }
			if(in_array("Strada", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Strada'].'</td>'; }
			if(in_array("Oras", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Oras'].'</td>'; }
			if(in_array("Cod postal", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CodPostal'].'</td>'; }
			if(in_array("Judet", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Judet'].'</td>'; }
			if(in_array("Tara", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Tara'].'</td>'; }
			if(in_array("Stare", $campuri_vizibile)){ $tabel_rand .= '<td>'.$stare_arr[$rand_corp_crm['StareProspect']].'</td>'; }
			if(in_array("Rating", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rating_arr[$rand_corp_crm['RatingProspect']].'</td>'; }
			if(in_array("Sursa informare", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['SursaInformare'].'</td>'; }
			$tabel_rand .= '<td align="center"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="'.$nume_operatii_chk.'" id="'.$nume_operatii_chk.'" class="operatii_chk '.$operatii_chk_dev.'" '.$chk_onclick.'></input></span></td>
		</tr>';				
	}

	else if($_GET['pagina'] == 'conturi') {	
		$_SESSION['corpdevpoz']++;
		
		//$link = '<a href="index.php?pag=contacte&o=contact&co='.$rand_corp_crm['CodContactPrincipal'].'&cd='.$detalii_director['CodDirector'].'" class="crm_link">'.$rand_corp_crm['Nume'].'</a>';
		
		$nume_clasa_nr_rand = 'corpdevpoz-'.$_SESSION['corpdevpoz'].'';
		$nume_clasa_cod_rand = 'codrand-'.$rand_corp_crm['CodCont'].'';
		
		$rand_bg_culoare = 'bgcolor="#ffffcc"';
		$rand_name_id = 'entitate-'.$rand_corp_crm['CodCont'].'-'.$_SESSION['corpdevpoz'].'';
		$rand_clasa = 'articol rand_corpdev '.$nume_clasa_nr_rand.' '.$nume_clasa_cod_rand.'';
		$tip_element = 'entitate';
		$tabel_rand_meniu_con = 'oncontextmenu=\'meniu_contextual_corp_crm("'.$lista.'", "'.$_GET['pagina'].'", "'.$_GET['cod'].'", "'.$rand_name_id.'", "'.$tip_element.'"); return false;\'';
		$nume_operatii_chk = 'OpEntitate-'.$rand_corp_crm['CodCont'].'-'.$_SESSION['corpdevpoz'].''; //operatii chk
		$operatii_chk_dev = 'operatii_chk_dev';
		$chk_onclick = 'onclick=\'chk_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'", "chk");\'';
		$rand_onclick = 'onclick=\'rand_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'");\'';
		$rand_ondblclick = 'ondblclick=\'fereastra_conturi_ad_ed("gen","'.$_GET['cod'].'","editare","1","");\'';
		//rand corp crm		
		$tabel_rand =
		'<tr '.$rand_bg_culoare.' id="'.$rand_name_id.'" name="'.$rand_name_id.'" class="'.$rand_clasa.'" '.$tabel_rand_meniu_con.' '.$rand_onclick.' '.$rand_ondblclick.'>
			<td width="3%">'.$nr_rand.'</td>';
			if(in_array("Cod", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CodCont'].'</td>'; }
			if(in_array("Director", $campuri_vizibile)){ $tabel_rand .= '<td>'.$detalii_director['NumeDirector'].'</td>'; }
			if(in_array("Companie", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Companie'].'</td>'; }
			if(in_array("Domeniu", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Domeniu'].'</td>'; }
			if(in_array("Website", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Website'].'</td>'; }
			if(in_array("Strada", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Strada'].'</td>'; }
			if(in_array("Oras", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Oras'].'</td>'; }
			if(in_array("Cod postal", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CodPostal'].'</td>'; }
			if(in_array("Judet", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Judet'].'</td>'; }
			if(in_array("Tara", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Tara'].'</td>'; }
			if(in_array("Telefon", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Telefon'].'</td>'; }
			if(in_array("Fax", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Fax'].'</td>'; }
			if(in_array("Banca", $campuri_vizibile)){ $tabel_rand .= '<td>'.$stare_arr[$rand_corp_crm['Banca']].'</td>'; }
			if(in_array("Cont banca", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rating_arr[$rand_corp_crm['ContBanca']].'</td>'; }
			if(in_array("C.U.I.", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CUI'].'</td>'; }
			if(in_array("Nr. Reg. Com.", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['NrRegCom'].'</td>'; }
			if(in_array("Cifra afaceri", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CifraAfaceri'].'</td>'; }
			if(in_array("Angajati", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Angajati'].'</td>'; }
			if(in_array("Nume", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Nume'].'</td>'; }
			if(in_array("Functie", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Functie'].'</td>'; }
			if(in_array("Mobil", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Mobil'].'</td>'; }
			if(in_array("Email", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Email'].'</td>'; }
			if(in_array("Sursa informare", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['SursaInformare'].'</td>'; }
			$tabel_rand .= '<td align="center"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="'.$nume_operatii_chk.'" id="'.$nume_operatii_chk.'" class="operatii_chk '.$operatii_chk_dev.'" '.$chk_onclick.'></input></span></td>
		</tr>';
	}
	
	else if($_GET['pagina'] == 'contacte') {
		
		if($rand_corp_crm['CodCont'] != '' or $rand_corp_crm['CodCont'] != '0') {
			$sql_detalii_cont = "select Companie from Conturi where CodCont = '".$rand_corp_crm['CodCont']."'";
			$res_detalii_cont = mysql_query($sql_detalii_cont, $link_bd_user);
			$detalii_cont= mysql_fetch_array($res_detalii_cont);
		}
		
		$_SESSION['corpdevpoz']++;
		
		$nume_clasa_nr_rand = 'corpdevpoz-'.$_SESSION['corpdevpoz'].'';
		$nume_clasa_cod_rand = 'codrand-'.$rand_corp_crm['CodContact'].'';
		
		$rand_bg_culoare = 'bgcolor="#ffffcc"';
		$rand_name_id = 'entitate-'.$rand_corp_crm['CodContact'].'-'.$_SESSION['corpdevpoz'].'';
		$rand_clasa = 'articol rand_corpdev '.$nume_clasa_nr_rand.' '.$nume_clasa_cod_rand.'';
		$tip_element = 'entitate';
		$tabel_rand_meniu_con = 'oncontextmenu=\'meniu_contextual_corp_crm("'.$lista.'", "'.$_GET['pagina'].'", "'.$_GET['cod'].'", "'.$rand_name_id.'", "'.$tip_element.'"); return false;\'';
		$nume_operatii_chk = 'OpEntitate-'.$rand_corp_crm['CodContact'].'-'.$_SESSION['corpdevpoz'].''; //operatii chk
		$operatii_chk_dev = 'operatii_chk_dev';
		$chk_onclick = 'onclick=\'chk_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'", "chk");\'';
		$rand_onclick = 'onclick=\'rand_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'");\'';
		$rand_ondblclick = 'ondblclick=\'fereastra_contacte_ad_ed("gen","'.$_GET['cod'].'","editare","","1","");\'';		
		//rand corp crm		
		$tabel_rand =
		'<tr '.$rand_bg_culoare.' id="'.$rand_name_id.'" name="'.$rand_name_id.'" class="'.$rand_clasa.'" '.$tabel_rand_meniu_con.' '.$rand_onclick.' '.$rand_ondblclick.'>
			<td width="3%" id="drag-'.$rand_name_id.'" name="drag-'.$rand_name_id.'" style="cursor: move;">'.$nr_rand.'</td>';
			
			if(in_array("Cod", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CodContact'].'</td>'; }
			if(in_array("Director", $campuri_vizibile)){ $tabel_rand .= '<td>'.$detalii_director['NumeDirector'].'</td>'; }
			if(in_array("Nume", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Nume'].'</td>'; }
			if(in_array("Functie", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Functie'].'</td>'; }
			if(in_array("Companie", $campuri_vizibile)){ $tabel_rand .= '<td>'.$detalii_cont['Companie'].'</td>'; }
			if(in_array("Cnp", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Cnp'].'</td>'; }
			if(in_array("Strada", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Strada'].'</td>'; }
			if(in_array("Oras", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Oras'].'</td>'; }
			if(in_array("Cod postal", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CodPostal'].'</td>'; }
			if(in_array("Judet", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Judet'].'</td>'; }
			if(in_array("Tara", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Tara'].'</td>'; }
			if(in_array("Telefon", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Telefon'].'</td>'; }
			if(in_array("Fax", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Fax'].'</td>'; }
			if(in_array("Mobil", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Mobil'].'</td>'; }
			if(in_array("Email", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Email'].'</td>'; }
			if(in_array("Sursa informare", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['SursaInformare'].'</td>'; }	
			
			$tabel_rand .= ' <td align="center"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="'.$nume_operatii_chk.'" id="'.$nume_operatii_chk.'" class="operatii_chk '.$operatii_chk_dev.'" '.$chk_onclick.'></input></span></td>
		</tr>';
	}
	
	else if($_GET['pagina'] == 'oportunitati') {
		$_SESSION['corpdevpoz']++;
		
		$nume_clasa_nr_rand = 'corpdevpoz-'.$_SESSION['corpdevpoz'].'';
		$nume_clasa_cod_rand = 'codrand-'.$rand_corp_crm['CodOportunitate'].'';
		
		$rand_bg_culoare = 'bgcolor="#ffffcc"';
		$rand_name_id = 'entitate-'.$rand_corp_crm['CodOportunitate'].'-'.$_SESSION['corpdevpoz'].'';
		$rand_clasa = 'articol rand_corpdev '.$nume_clasa_nr_rand.' '.$nume_clasa_cod_rand.'';
		$tabel_rand_meniu_con = 'oncontextmenu=\'\'';
		//$tabel_rand_meniu_con = 'oncontextmenu=\'meniu_contextual_corp_deviz("'.$lista.'", "'.$_GET['pagina'].'", "'.$_GET['cod'].'", "'.$rand_name_id.'", "'.$tip_element.'"); return false;\'';
		$tip_element = 'entitate';
		$nume_operatii_chk = 'OpEntitate-'.$rand_corp_crm['CodOportunitate'].'-'.$_SESSION['corpdevpoz'].''; //operatii chk
		$operatii_chk_dev = 'operatii_chk_dev';
		$chk_onclick = 'onclick=\'chk_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'", "chk");\'';
		$rand_onclick = 'onclick=\'rand_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'");\'';

		$cc = '';
		
		if($rand_corp_crm['Relatie'] == 'contacte') {
			$sql_cc = "SELECT * FROM Contacte WHERE CodContact = '".$rand_corp_crm['CodCC']."'";
			$res_cc = mysql_query($sql_cc, $link_bd_user);
			if(mysql_num_rows($res_cc) == 1) {
				$rand_cc = mysql_fetch_assoc($res_cc);
				//$cc = $rand_cc['Nume']." ".$rand_cc['Prenume'];
			}
		}
		else if($rand_corp_crm['Relatie'] == 'conturi') {
			$sql_cc = "SELECT * FROM Conturi WHERE CodCont = '".$rand_corp_crm['CodCC']."'";
			$res_cc = mysql_query($sql_cc, $link_bd_user);
			if(mysql_num_rows($res_cc) == 1) {
				$rand_cc = mysql_fetch_assoc($res_cc);
				//$cc = $rand_cc['Companie'];
			}
		}
		
		if($rand_corp_crm['Relatie'] == 'contacte')
			$cc = $rand_cc['Nume']." ".$rand_cc['Prenume'];
		else if($rand_corp_crm['Relatie'] == 'conturi')
			$cc = $rand_cc['Companie'];
		
		//rand corp crm		
		$tabel_rand =
		'<tr '.$rand_bg_culoare.' id="'.$rand_name_id.'" name="'.$rand_name_id.'" class="'.$rand_clasa.'" '.$tabel_rand_meniu_con.' '.$rand_onclick.'>
			<td width="3%" id="drag-'.$rand_name_id.'" name="drag-'.$rand_name_id.'" style="cursor: move;">'.$nr_rand.'</td>
			<td width="7%">'.$rand_corp_crm['CodOportunitate'].'</td>
			<td width="20%">'.$rand_corp_crm['NumeOportunitate'].'</td>
			<td width="20%">'.$cc.'</td>
			<td width="15%">'.$rand_corp_crm['Stare'].'</td>
			<td width="10%">'.$rand_corp_crm['Probabilitate'].'</td>
			<td width="10%">'.$rand_corp_crm['Suma'].'</td>
			<td width="15%">'.$rand_corp_crm['DataScadenta'].'</td>
			<td align="center"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="'.$nume_operatii_chk.'" id="'.$nume_operatii_chk.'" class="operatii_chk '.$operatii_chk_dev.'" '.$chk_onclick.'></input></span></td>
		</tr>';
	}
	if('activitati' == $_GET['pagina']) {
		
		$_SESSION['corpdevpoz']++;
		
		$nume_clasa_nr_rand = 'corpdevpoz-'.$_SESSION['corpdevpoz'].'';
		$nume_clasa_cod_rand = 'codrand-'.$rand_corp_crm['CodActivitate'].'';
		
		$rand_bg_culoare = 'bgcolor="#ffffcc"';
		$rand_name_id = 'entitate-'.$rand_corp_crm['CodActivitate'].'-'.$_SESSION['corpdevpoz'].'';
		$rand_clasa = 'articol rand_corpdev '.$nume_clasa_nr_rand.' '.$nume_clasa_cod_rand.'';
		$tip_element = 'entitate';
		$tabel_rand_meniu_con = 'oncontextmenu=\'meniu_contextual_corp_crm("'.$lista.'", "'.$_GET['pagina'].'", "'.$_GET['cod'].'", "'.$rand_name_id.'", "'.$tip_element.'"); return false;\'';
		$nume_operatii_chk = 'OpEntitate-'.$rand_corp_crm['CodActivitate'].'-'.$_SESSION['corpdevpoz'].''; //operatii chk//(N) era CodProspect
		$operatii_chk_dev = 'operatii_chk_dev';
		$chk_onclick = 'onclick=\'chk_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'", "chk");\'';
		$rand_onclick = 'onclick=\'rand_activare_selectie("'.$rand_name_id.'", "'.$nume_operatii_chk.'", "'.$tip_element.'");\'';
		$rand_ondblclick = 'ondblclick=\'fereastra_activitati_ad_ed("gen","'.$_GET['cod'].'","editare","1","");\'';
		
		//(N) vei obtine numele userilor ... deocamdata doar codurile lor
		
		//rand corp crm		
		$tabel_rand = 
		'<tr '.$rand_bg_culoare.' id="'.$rand_name_id.'" name="'.$rand_name_id.'" class="'.$rand_clasa.'" '.$tabel_rand_meniu_con.' '.$rand_onclick.' '.$rand_ondblclick.'>
			<td width="3%">'.$nr_rand.'</td>';
			if(in_array("Cod", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['CodActivitate'].'</td>'; }
			//if(in_array("Responsabil", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Responsabil'].'</td>'; }//codul userului
			if(in_array("Responsabil", $campuri_vizibile)){ $tabel_rand .= '<td>' . $NgloArrStr_listaLicentelorUserilor_ClientuluiFirmei[$rand_corp_crm['Responsabil']] . '</td>'; }//!!! atentie, ia dupa key din gloArr_...
			if(in_array("Tip", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['TipActivitate'].'</td>'; }
			if(in_array("Data inregistrarii", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['DataInregistrarii'].'</td>'; }
			if(in_array("Data scadentei", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['DataScadenta'].'</td>'; }
			if(in_array("Descriere", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Descriere'].'</td>'; }
			if(in_array("Companie", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Companie'].'</td>'; }
			if(in_array("Nume", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Nume'].'</td>'; }
			if(in_array("Telefon", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Telefon'].'</td>'; }
			if(in_array("Fax", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Fax'].'</td>'; }
			if(in_array("Mobil", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Mobil'].'</td>'; }
			if(in_array("Email", $campuri_vizibile)){ $tabel_rand .= '<td>'.$rand_corp_crm['Email'].'</td>'; }
			$tabel_rand .= '<td align="center"><span title="'.$_SESSION['text']['7'].'"><input type="checkbox" name="'.$nume_operatii_chk.'" id="'.$nume_operatii_chk.'" class="operatii_chk '.$operatii_chk_dev.'" '.$chk_onclick.'></input></span></td>
		</tr>';				
	}//de la if activitati
	
	
	return $tabel_rand; 
}
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////

?>