<?php

function totranslit($var) {

        $NpjLettersFrom = "àáâãäåçèêëìíîï?ñòóôöû³";

        $NpjLettersTo   = "abvgdeziklmnoprstufcyi";

        $NpjBiLetters = array( 

      "é" => "jj", "¸" => "jo", "æ" => "zh", "õ" => "kh", "÷" => "ch", 

      "ø" => "sh", "ù" => "shh", "?" => "je", "?" => "ju", "ÿ" => "ja",

      "ú" => "", "ü" => "", "¿" => "yi", "º" => "ye",

                              );



        $NpjCaps  = "ÀÁÂÃÄÅ¨ÆÇÈÉÊËÌÍÎÏ?ÑÒÓÔÕÖ×ØÙÜÚÛ??ß¯ª²";

        $NpjSmall = "àáâãäå¸æçèéêëìíîï?ñòóôõö÷øùüúû??ÿ¿º³";





      $var = str_replace(".php", "", $var);

	  $var = trim(strip_tags($var));

      $var = preg_replace( "/\s+/ms", "-", $var );

      $var = strtr( $var, $NpjCaps, $NpjSmall );

      $var = strtr( $var, $NpjLettersFrom, $NpjLettersTo );

      $var = strtr( $var, $NpjBiLetters );



      $var = preg_replace("/[^a-z0-9\-]+/mi", "", $var);

	  $var=preg_replace('#[\-]+#i', '-', $var);



      if (strlen($var) > 70) {



		$var = substr ($var, 0, 70);



			if (($temp_max = strrpos($var, '-')))  $var = substr ($var, 0, $temp_max);



	  }



  return $var;

}

function curPageURL() {

$pageURL = 'http';



	if ($_SERVER["HTTPS"] == "on") {

		$pageURL .= "s";

	}

$pageURL .= "://";



	if ($_SERVER["SERVER_PORT"] != "80") {

		$pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];

	} else {

		$pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];

	}

	

return $pageURL;

}

function linkDetail($id, $name) {

	global $countrySelect;

	$link = _siteurl.'/'.$countrySelect.'/'.totranslit($name).'_'.$id.'.html';

	

	return $link;

}



function list_categories($type, $countrySelect, $jobSelect) {

global $countries, $lang;

if(in_array($countrySelect, $countries)) { // ¿Será $countries? - $localcategories

$catinc = $countrySelect;

}else {

$catinc = 'US';

}

	include('includes/categories/categories-'.$catinc.'.php');





	if($type == 'dropdown') {



		 echo '<option value="">- '.$lang['select_category'].' -</option>';

		foreach($categories as $category) {

		

		

		echo '<option value="'. $category.'" ';

		echo $category == $jobSelect ? 'selected' : '';

		

		echo '>'. $category.'</option>';

		echo "\n";

		}

	}

}



function list_countries($type, $countrySelect) {



global $countries;

	

	if($type=="dropdown") {

		

	

	

		// echo '<option value = "">- Select a Job Category -</option>';

		foreach($countries as $country => $v) {

		

		

		echo '<option value="'. $country.'"';

		

		echo $v == $countrySelect ? 'selected' : '';

		

		

		echo '>'.$v.'</option>';

		echo "\n";

		}

	

	}elseif($type=="footer") {

	



	

		foreach($countries as $country => $v) {

		

		

		echo '<span class="banderas"><img class="flags" src="/img/flags/'.$v.'.png" alt="'.$seo_url1.' '.$v.'" width="29" height="21" /><a href="http://'.strtolower($country).'.joboseek.com/'. $v.'/" title="'.$seo_url1.' '.$v.'">'.$v.'</a></span>';

		echo "\n";

		}

	

	}



}



function job_list($countrySelect, $browse = true, $one = false) {



global $countries, $lang;



if(in_array($countrySelect, $countries)) {

$catinc = $countrySelect;

}else {

$catinc = 'US'; //default english

}

if($one == true)
{
    asort($countries);
    //
    $dir = '/home/bolsa/public_html/listado/';
    $file = fopen($dir.'listado.txt', 'r+');
    $catinc = fgets($file);
    fclose($file);
    //
    $countries2 = array('Argentina', 'Osterreich', 'Australia', 'Belgie', 'Bolivia','Brasil', 'Canada', 'Chile', 'Deutschland', 'Espana', 'France', 'Ireland', 'Italia', 'Mexico', 'Nederland', 'New-Zealand', 'Portugal', 'Russia', 'UK', 'US');
    sort($categories2);
    $s = array_search($catinc, $countries2);
    $k = $s < 19 ? $s+1 : 0;
    //
    $file = fopen($dir.'listado.txt', 'w+');
    fputs($file, $countries2[$k]);
    fclose($file);
    $site_url = array_keys($countries, $catinc);
    $site_url = 'http://'.strtolower($site_url[0]).'.bolsadeltrabajo.net';
    $countrySelect =  $catinc;
    //
}

include('includes/categories/categories-'.$catinc.'.php');

if($one == true)
{
    sort($categories);
    $file = fopen($dir.'paises/'.$catinc.'.txt', 'r+');
    $catinc2 = fgets($file);
    fclose($file);
    //
    $s = array_search($catinc2, $categories);
    $k = $s < count($categories) ? $s+1 : 0;
    //
    $file = fopen($dir.'paises/'.$catinc.'.txt', 'w+');
    fputs($file, $categories[$k]);
    fclose($file);
    $category =  $catinc2;
    echo $catinc2 . ' --- ' . $k . ' --- '.$categories[$k]; exit;
    //
    file_get_contents($site_url.'/listado/'.$countrySelect.'/'. str_replace(' ', '+', $category).'-'.$lang['seo_url1'].'.html');
}



if($browse) {

	 echo '	<table class="worldwide" width="100%"> 

			<tr> 

				<td valign=top width="25%">';

}

	 

	 $i = 0;

	foreach($categories as $category) {

	

 // echo '<a href="'._siteurl .'/'. str_replace(' ', '_', $category).'-'.$lang['seo_url1'].'-in-'.$countrySelect.'.html">'. $category.' '.$lang['seo_url1'].'</a><br />';

	   

       if($one == true)

       {
        
        echo '<a href="'.$site_url.'/listado/'.$countrySelect.'/'. str_replace(' ', '+', $category).'-'.$lang['seo_url1'].'.html">'. $category.' '.$lang['seo_url1'].'</a><br />'; // Search in sources

       }

       else

       {

        echo '<a href="'._siteurl .'/search-jobs.php?countrySelect='.$countrySelect.'&keyword='.$lang['seo_url1'].'&jobLocation=&jobSelect='. str_replace(' ', '+', $category).'&refineKeyword=&seo_url1='.$lang['seo_url1'].'">'. $category.' '.$lang['seo_url1'].'</a><br />'; // BD

       }

       

       echo "\n";

  

	    $columns = array(21, 42, 63);



		if(in_array($i, $columns) && $browse) {

				echo "</td>\n";

			echo '<td valign=top width="25%">';

		}

	$i++;

	}

	if($browse) echo '</tr></table>';



}



function location_list($countrySelect, $one = false) {

global $lang;

	include('includes/locations/locations-'.$countrySelect.'.php');



	 echo ' <table class="worldwide" width="100%"> 

  <tr> 

    <td valign=top width="25%">';

	 

	 $i = 0;

	foreach($locations as $location) {

	

	$location = str_replace(' ', '_', $location);

	

	//   echo '<a href="'._siteurl .'/'.$lang['seo_url1'].'-in-'.$location.','.$countrySelect.'.html">'.$lang['seo_url1'].' '. str_replace('_', ' ', $location).'</a><br />';

	   if($one == true)

       {

        echo '<a href="'._siteurl .'/'.$countrySelect.'/'.$location.'/-'.$lang['seo_url1'].'.html">'.$lang['seo_url1'].' '. str_replace('_', ' ', $location).'</a><br />';

       }

       else

       {

        echo '<a href="'._siteurl .'/search-jobs.php?countrySelect='.$countrySelect.'&keyword='.$lang['seo_url1'].'&jobLocation='.$location.'&refineKeyword=&seo_url1='.$lang['seo_url1'].'">'.$lang['seo_url1'].' '. str_replace('_', ' ', $location).'</a><br />'; // BD

       }

       echo "\n";

	    $columns = array(15, 30, 45, 60);

		if(in_array($i, $columns)) {

			echo "</td>\n";

			echo '<td valign=top width="25%">';

		}

	$i++;

	}

	echo '</tr></table>';



}

function list_jobtypes() {

global $jobtypes, $lang, $jobLocation, $jobSelect, $countrySelect, $keyword, $refineKeyword;

	

	$i = 1;

	sort($jobtypes);

		 

		foreach($jobtypes as $jobtype) {

		

		echo '<li ';

		

		echo $i > 4 ? ' class="more"' : '';

		

		echo '><a href="'._siteurl.'/search-jobs.php?seo_url1='.$lang['seo_url1'].'&jobLocation='.$jobLocation.'&jobSelect='.$jobSelect.'&countrySelect='.$countrySelect.'&keyword='.$keyword.'&workExp='.$jobtype.'&refineKeyword='.$refineKeyword.'" title="'.$jobtype.' '.$jobSelect.' | '.$jobLocation.' '.$countrySelect.'">'.$jobtype.'</a></li>';

		echo "\n";

		$i++;

		}



}



function location_list_filter($countrySelect) {

global $jobtypes, $lang, $jobLocation, $jobSelect, $countrySelect, $keyword, $refineKeyword;



	include('includes/locations/locations-'.$countrySelect.'.php');



	 echo ' ';

	 

	 $i = 0;

	foreach($locations as $location) {

	

	$location = str_replace(' ', '_', $location);

	

	 //  echo '<li><a href="'._siteurl .'/'.$lang['seo_url1'].'-in-'.$location.','.$countrySelect.'.html">'. str_replace('_', ' ', $location).'</a></li>';

echo '<li><a href="'._siteurl.'/search-jobs.php?seo_url1='.$lang['seo_url1'].'&jobLocation='.$location.'&jobSelect='.$jobSelect.'&countrySelect='.$countrySelect.'&keyword='.$keyword.'&workExp='.$_GET["workExp"].'&refineKeyword='.$refineKeyword.'" title="'.$jobtype.' '.$jobSelect.' | '.$jobLocation.' '.$countrySelect.'">'.$location.' </a></li>';



	   echo "\n";



	$i++;

	}

	echo '';



}



function getAll()

{

    global $c;

    

    $qs = mysqli_fetch_assoc(mysqli_query($c, 'SELECT COUNT(codigo) AS total FROM '._table_));

    

    return $qs['total'];

}



function filter($input) {

 

$strip = array(

    '@<script[^>]*?>.*?</script>@si',   // Strip out javascript

    '@<[\/\!]*?[^<>]*?>@si',            // Strip out HTML tags

    '@<style[^>]*?>.*?</style>@siU'

);

 

    $output = stripslashes(trim(preg_replace(($strip), '', $input)));

	

		$output = preg_replace('/\s+/', ' ', $output);

    return $output;

}



/*

function register_mysearches($query = NULL, $country = NULL, $category = NULL, $results = 'Indefinido')

{

    include_once('setsearches.php');

}

*/





function send_alerts()

{

    global $c;

    

    $q = mysqli_query($c, 'SELECT id, email, keyword, hash, `table`, lastsend FROM _suscriptions WHERE lastsend < \''.(time()-259200).'\' && status = \'1\' ');

    //

    $total = mysqli_num_rows($q);

    $sub = mysqli_fetch_assoc($q);

    mysqli_query($c, $f = 'UPDATE _suscriptions SET lastsend = \''.time().'\' WHERE id = \''.$sub['id'].'\' LIMIT 1');

    //

    while($i <= $total)

    {

        //echo $i;

        $query = mysqli_query($c, 'SELECT title, description, `serial`, death FROM `'.$sub['table'].'` WHERE query = \''.$sub['keyword'].'\' || title LIKE \'%'.$sub['keyword'].'%\' ORDER BY death DESC LIMIT 10');

        //

        if(mysqli_num_rows($query))

        {

            while($data = mysqli_fetch_assoc($query))

            {

                $domainto = strtoupper(substr($sub['table'], 0, 2));

                //$domainfrom = str_ireplace(_subdomain_, $domainto, substr(_siteurl, 0, 15));

                $linknd = 'http://'.$domainto.'.joboseek.com/'.$domainto.'/'.totranslit($data['title']).'_'.$data['serial'].'.html';

                

                $armen .= '<div><a href="'.$linknd.'"><span style="font-weight:bold; color:green; font-size:16px; text-decoration: underline;">'.$data['title'].'</span></a>

          		<span class="datefield">'.date('d/m/y', $data['death']).'</span> 

                <p class="description" style="text-transform: lowercase"> '.strtolower(substr(strip_tags($data['description']), 0, 450 )).'...

                </p></div>';

            }

            //

            $mensaje = '<html>

                    <head>

                      <title>Joboseek</title>

                    </head>

                    <body>

                      <p>'.str_replace('{keyword}', $sub['keyword'], $lang['text_alertas_Nuevas_ofertas']).'</p>

                      '.$armen.'

                    <br />

                    <p> '.str_replace(array('{keyword}', '{link}'), array($sub['keyword'], 'http://'.$domainto.'.joboseek.com/last-searchs.php?suscribe=off&key='.$sub['hash']), $lang['text_alertas_sino_desea']).' </p>

                    </body>

                    </html>';

    

            $ch  = 'MIME-Version: 1.0' . "\r\n";

            $ch .= 'Content-type: text/html; charset=UTF-8' . "\r\n";

            

            if(mail($sub['email'], 'Alertas para ' .$sub['keyword'], $mensaje, $ch))

            {

                unset($armen, $ch);

                sleep(2);

                exit;

            }

            

        }

        

        ++$i;

    }

}