/**
*    Insert code into admin.jobline.php
*    as the last switch case statement
*    approximately line 129
*/

    case \"import\":
        import_jobs();
        break;
    case \"request\":
        request_jobs($fldQuery, $fldLocation);
        break;         


/** 
*    Insert into admin.jobline.php
*    Approximately line 820
*/

function import_jobs() {

    $gid = $my->gid;

    ?>
    <form name=\"import\" action=\"index.php\" method=\"get\">
        <input type=\"hidden\" name=\"option\" value=\"com_jobline\" />
        <input type=\"hidden\" name=\"task\" value=\"request\" />
        Job Type:  <input type=\"text\" name=\"q\" value=\"\" size=\"40\" /> <br />
        Location: &nbsp;<input type=\"text\" name=\"l\" value=\"\" size=\"40\" /> <br /><br />
        <input type=\"submit\" value=\"Submit\" name=\"submit\" />
    </form>
    <?php

    return $q && $l;

}

/** Request Jobs from Indeed.com
 * @param text $fldQuery
 * @param text $fldLocation
 * @return db_res
 * Inserts jobs into DB from Indeed.com; optional query and location params.
 */

function request_jobs($fldQuery, $fldLocation) {

	$gid = $my->gid;

	if (isset($fldQuery) || isset($fldLocation)) {
		urlencode($fldQuery);
		urlencode($fldLocation);
	}

	// Get reference to DB Object
	$db =& JFactory::getDBO();

	$publisherId = \"9284102052512106\";
	$filter = 1;
	$limit = \"30\";

	$baseUrl = \"http://api.indeed.com/ads/apisearch?publisher=\" . $publisherId . \"&q=\" . $fldQuery;
	$baseUrl .= \"&l=\" . $fldLocation . \"&filter=\" . $filter . \"&limit=\" . $limit;

	$results = simplexml_load_file($baseUrl) or die(\"The feed did not load!\");

	if(isset($results)) {

		$i = 0;

		foreach($results->xpath(\'//result\') as $result)	{			/** 		*/

			$i++;

			$title = preg_replace(\"/[^a-zA-Z0-9 .?!$()\\\'\\\"]/\", \"\", $result->jobtitle);
			$company = preg_replace(\"/[^a-zA-Z0-9 .?!$()\\\'\\\"]/\", \"\", $result->company);
			$city = preg_replace(\"/[^a-zA-Z0-9 .?!$()\\\'\\\"]/\", \"\", $result->city);
			$usstate = preg_replace(\"/[^a-zA-Z0-9 .?!$()\\\'\\\"]/\", \"\", $result->state);
			$country = preg_replace(\"/[^a-zA-Z0-9 .?!$()\\\'\\\"]/\", \"\", $result->country);
			$description = preg_replace(\"/[^a-zA-Z0-9 .?!$()\\\'\\\"]/\", \"\", $result->snippet);

			$title = $db->getEscaped($title);
			$company = $db->getEscaped($company);
			$city = $db->getEscaped($city);
			$usstate = $db->getEscaped($usstate);
			$country = $db->getEscaped($country);
			$info = $db->getEscaped($result->url);
            $applyinfo = \"<a href=\'\" . $info . \"\' target=\'_blank\'>{$info}</a>\";
			$apply = $db->getEscaped($applyinfo);
			$description = $db->getEscaped($description);

			$time = time();
			$created = gmdate(\'Y:m:d H:m:i\', $time);

			$query = \"INSERT INTO #__jl_jobposting (title, company, city, usstate, country, applyinfo, description, created, access, state) \" .

					\"VALUES (\'$title\' , \'$company\' , \'$city\' , \'$usstate\' , \'$country\' , \'$apply\' , \'$description\' , \'$created\', \'0\', \'1\' );\";

			$db->setQuery($query);
			$db->query();
		}
        
		echo \"<br><br><h1>{$i} Records were imported from Indeed!</h1>\";
        echo \"<a href=\'index.php?option=com_jobline&task=list\'>Return to Job Postings</a>\";

	} else {
        echo \"Error: \" . mysql_error();
    }
}