/**
* function to map the ralated to (organization) for potentials while importing
* checks if the organization exists else will add a new one
* @param string $organization_name
* @return integer idorganization
*/
public function map_related_to_organization($organization_name)
{
if (strlen($organization_name) > 2) {
$organization_name = trim($organization_name);
$do_organization = new Organization();
$qry = "\n\t\t\tselect `idorganization` \n\t\t\tfrom `organization` \n\t\t\twhere \n\t\t\t`organization_name` = ?\n\t\t\tAND `deleted` = 0 \n\t\t\tAND `iduser` = " . $_SESSION["do_user"]->iduser;
$do_organization->query($qry, array($organization_name));
if ($do_organization->getNumRows() > 0) {
$do_organization->next();
return $do_organization->idorganization;
} else {
$do_organization->insert("organization", array("organization_name" => CommonUtils::purify_input($organization_name), "iduser" => $_SESSION["do_user"]->iduser));
$idorganization = $do_organization->getInsertId();
//adding the added_on
$q_upd = "\n\t\t\t\tupdate `organization`\n\t\t\t\tset `added_on` = '" . date("Y-m-d H:i:s") . "'\n\t\t\t\twhere `idorganization` = " . $idorganization;
$do_organization->query($q_upd);
$do_organization->insert("organization_custom_fld", array("idorganization" => $idorganization));
$do_organization->insert("organization_address", array("idorganization" => $idorganization));
$do_data_history = new DataHistory();
$do_data_history->add_history($idorganization, 6, 'add');
$do_data_history->free();
return $idorganization;
}
}
}
/**
* function to map organization to contact while importing
* checks if the organization already exists else add a new one
* @param string $organization_name
* @param object $import_object
* @param array $data
* @return integer idorganization
*/
public function map_contact_organization($organization_name, $import_object, $data)
{
$qry = "\n\t\tselect idorganization \n\t\tfrom organization \n\t\twhere organization_name = ?\n\t\tAND deleted = 0\n\t\tAND iduser ="******"do_user"]->iduser;
$stmt = $this->getDbConnection()->executeQuery($qry, array(trim($organization_name)));
if ($stmt->rowCount() > 0) {
$rs = $stmt->fetch();
return $rs["idorganization"];
} else {
if (strlen($organization_name) > 2) {
$mapped_fields = $import_object->get_mapped_fields();
$do_organization = new Organization();
$do_organization->insert("organization", array("organization_name" => CommonUtils::purify_input($organization_name), "iduser" => $_SESSION["do_user"]->iduser));
$idorganization = $do_organization->getInsertId();
$q_upd = "\n\t\t\t\tupdate `organization`\n\t\t\t\tset `added_on` = ?\n\t\t\t\twhere `idorganization` = ?";
$do_organization->query($q_upd, array(date("Y-m-d H:i:s"), $idorganization));
$do_organization->insert("organization_custom_fld", array("idorganization" => $idorganization));
$mapped_fields = $import_object->get_mapped_fields();
if (array_search("cnt_mail_street", $mapped_fields) !== false) {
$org_bill_address = $data[array_search("cnt_mail_street", $mapped_fields)];
} else {
$org_bill_address = '';
}
if (array_search("cnt_mail_pobox", $mapped_fields) !== false) {
$org_bill_pobox = $data[array_search("cnt_mail_pobox", $mapped_fields)];
} else {
$org_bill_pobox = '';
}
if (array_search("cnt_mailing_city", $mapped_fields) !== false) {
$org_bill_city = $data[array_search("cnt_mailing_city", $mapped_fields)];
} else {
$org_bill_city = '';
}
if (array_search("cnt_mailing_state", $mapped_fields) !== false) {
$org_bill_state = $data[array_search("cnt_mailing_state", $mapped_fields)];
} else {
$org_bill_state = '';
}
if (array_search("cnt_mailing_postalcode", $mapped_fields) !== false) {
$org_bill_postalcode = $data[array_search("cnt_mailing_postalcode", $mapped_fields)];
} else {
$org_bill_postalcode = '';
}
if (array_search("cnt_mailing_country", $mapped_fields) !== false) {
$org_bill_country = $data[array_search("cnt_mailing_country", $mapped_fields)];
} else {
$org_bill_country = '';
}
$do_organization->insert("organization_address", array("idorganization" => $idorganization, "org_bill_address" => CommonUtils::purify_input($org_bill_address), "org_bill_pobox" => CommonUtils::purify_input($org_bill_pobox), "org_bill_city" => CommonUtils::purify_input($org_bill_city), "org_bill_state" => CommonUtils::purify_input($org_bill_state), "org_bill_postalcode" => CommonUtils::purify_input($org_bill_postalcode), "org_bill_country" => CommonUtils::purify_input($org_bill_country)));
$do_data_history = new DataHistory();
$do_data_history->add_history($idorganization, 6, 'add');
$do_data_history->free();
return $idorganization;
} else {
return 0;
}
}
}