/**
* Copy resume to same site or another site.
*
* @param integer Candidate ID.
* @param integer Site ID.
* @return true/false.
*/
public function copyResume($candidateID, $toCandidateID, $siteID)
{
$arrResume = $this->getAllResumesFields($candidateID);
foreach ($arrResume as $resume) {
unset($resume["attachment_id"]);
$resume["site_id"] = $siteID;
$file = $resume["directory_name"] . $resume["stored_filename"];
$arrPatIhnfo = pathinfo($file);
$resume["original_filename"] = $arrPatIhnfo["filename"] . "_copy.{$arrPatIhnfo["extension"]}";
$resume["stored_filename"] = $arrPatIhnfo["filename"] . "_copy.{$arrPatIhnfo["extension"]}";
if (file_exists("{$resume["directory_name"]}{$arrPatIhnfo["filename"]}.{$arrPatIhnfo["extension"]}")) {
copy("{$resume["directory_name"]}{$arrPatIhnfo["filename"]}.{$arrPatIhnfo["extension"]}", "{$arrPatIhnfo["directory_name"]}{$arrPatIhnfo["filename"]}_copy.{$arrPatIhnfo["extension"]}");
}
$resume["text"] = addslashes($resume["text"]);
$resume["data_item_id"] = $toCandidateID;
$objSQL = new ClsNaanalSQL("INSERT");
$objSQL->addTable("attachment");
foreach ($resume as $field => $data) {
$objSQL->addValue($field, $data);
}
$sql = $objSQL->render();
$this->_db->query($sql);
}
return true;
}
function loadAuieoExtraField()
{
$con=DatabaseConnection::getInstance();
$DB= $con->getConnection();
$DB->setQuery("select * from extra_field_settings");
$arrExtraField=$DB->getAllAssoc();
foreach($arrExtraField as $arrData)
{
$objSQL=new ClsNaanalSQL("INSERT");
$objSQL->addTable("auieo_fields");
$objSQL->addValue("data_item_type", $arrData["data_item_type"]);
$objSQL->addValue("uitype", $arrData["extra_field_type"]);
$field_name = cleanToVariableName($arrData["field_name"]);
$field_name = strtolower($field_name);
$objSQL->addValue("fieldname", $field_name);
$objSQL->addValue("fieldlabel", $arrData["field_name"]);
$objSQL->addValue("field_options", $arrData["extra_field_options"]);
$objSQL->addValue("position", $arrData["position"]);
$maximumlength=255;
$fieldType="VARCHAR(255)";
if($arrData["extra_field_type"]==2)
{
$maximumlength=0;
$fieldType="TEXT";
}
else if($arrData["extra_field_type"]==3)
{
$maximumlength=1;
$fieldType="INT(1)";
}
else if($arrData["extra_field_type"]==4)
{
$fieldType="DATETIME";
}
$objSQL->addValue("maximumlength", $maximumlength);
$objSQL->addValue("site_id",$arrData["site_id"]);
$arrFieldSQL=$objSQL->render();
/**
* ALTER IGNORE TABLE `extra_field_settings` ADD COLUMN `is_extra` int(1) default 0;
ALTER IGNORE TABLE `extra_field_settings` ADD COLUMN `presence` varchar(255) default 0;
ALTER IGNORE TABLE `extra_field_settings` ADD COLUMN `fieldlabel` varchar(255) default NULL;
ALTER IGNORE TABLE `extra_field_settings` ADD COLUMN `defaultvalue` TEXT default NULL;
ALTER IGNORE TABLE `extra_field_settings` ADD COLUMN `maximumlength` INT(11) DEFAULT '0' ;
ALTER IGNORE TABLE `extra_field_settings` ADD COLUMN `blockid` INT(11) DEFAULT '0' ;
ALTER IGNORE TABLE `extra_field_settings` ADD COLUMN `helpinfo` TEXT default NULL;
*/
$table="";
if($arrData["data_item_type"]==100)
{
$table="candidate";
}
else if($arrData["data_item_type"]==200)
{
$table="company";
}
else if($arrData["data_item_type"]==300)
{
$table="contact";
}
else if($arrData["data_item_type"]==400)
{
$table="joborder";
}
$arrSQL[]="ALTER IGNORE TABLE `{$table}` ADD COLUMN `{$field_name}` {$fieldType} default NULL";
//$arrSQL[]=$arrFieldSQL;
}
return $arrSQL;
}
