/**
* function to save the imported organization
* @param object $import_object
* @param object $do_crm_fields
* @param array $data
* @return integer inseted recordid
*/
public function import_save($import_object, $crm_fields, $data)
{
$mapped_fields = $import_object->get_mapped_fields();
$table_entity = 'organization';
$table_entity_address = 'organization_address';
$table_entity_custom = 'organization_custom_fld';
$entity_data_array = array();
$custom_data_array = array();
$addr_data_array = array();
foreach ($crm_fields as $crm_fields) {
$field_name = $crm_fields["field_name"];
$mapped_field_key = array_search($field_name, $mapped_fields);
if ($mapped_field_key !== false) {
$field_value = $data[$mapped_field_key];
$field_value = $import_object->format_data_before_save($crm_fields["field_type"], $field_value);
} else {
$field_value = '';
}
if ($field_name == 'assigned_to') {
$field_name = 'iduser';
$field_value = $_SESSION["do_user"]->iduser;
}
if ($field_name == 'member_of') {
$field_value = $this->map_member_of($field_value);
}
if ($crm_fields["table_name"] == $table_entity && $crm_fields["idblock"] > 0) {
$entity_data_array[$field_name] = $field_value;
}
if ($crm_fields["table_name"] == $table_entity_address && $crm_fields["idblock"] > 0) {
$addr_data_array[$field_name] = $field_value;
}
if ($crm_fields["table_name"] == $table_entity_custom && $crm_fields["idblock"] > 0) {
$custom_data_array[$field_name] = $field_value;
}
}
$this->insert($table_entity, $entity_data_array);
$id_entity = $this->getInsertId();
if ($id_entity > 0) {
//adding the added_on
$q_upd = "\n\t\t\tupdate `" . $this->getTable() . "` \n\t\t\tset `added_on` = ? \n\t\t\twhere `" . $this->primary_key . "` = ?";
$this->query($q_upd, array(date("Y-m-d H:i:s"), $id_entity));
$custom_data_array["idorganization"] = $id_entity;
$addr_data_array["idorganization"] = $id_entity;
$this->insert($table_entity_custom, $custom_data_array);
$this->insert($table_entity_address, $addr_data_array);
$do_data_history = new DataHistory();
$do_data_history->add_history($id_entity, 6, 'add');
$do_data_history->free();
return $id_entity;
} else {
return false;
}
}
/**
* function to map related to (contacts) for potentials while importing
* checks if the contact exists else adds a new contact
* @param string $contact_name
* @return integer idcontacts
*/
public function map_related_to_contacts($contact_name)
{
if (strlen($contact_name) > 2) {
$contact_name = trim($contact_name);
$do_contact = new Contacts();
$qry = "\n\t\t\tselect `idcontacts`\n\t\t\tfrom `contacts`\n\t\t\twhere `deleted` = 0 \n\t\t\tAND iduser = "******"do_user"]->iduser . "\n\t\t\tAND \n\t\t\t(\n\t\t\t\tconcat(firstname,' ',lastname) = ?\n\t\t\t\tor\n\t\t\t\tconcat(lastname,' ',firstname) = ?\n\t\t\t)\n\t\t\t";
$do_contact->query($qry, array($contact_name, $contact_name));
if ($do_contact->getNumRows() > 0) {
$do_contact->next();
return $do_contact->idcontacts;
} else {
$contact_name_explode = explode(" ", $contact_name);
$do_contact->insert("contacts", array("firstname" => CommonUtils::purify_input($contact_name_explode[0]), "lastname" => CommonUtils::purify_input($contact_name_explode[1]), "iduser" => $_SESSION["do_user"]->iduser));
$idcontacts = $do_contact->getInsertId();
//adding the added_on
$q_upd = "\n\t\t\t\tupdate `contacts` \n\t\t\t\tset `added_on` = '" . date("Y-m-d H:i:s") . "'\n\t\t\t\twhere `idcontacts` = " . $idcontacts;
$do_contact->query($q_upd);
$do_contact->insert("contacts_custom_fld", array("idcontacts" => $idcontacts));
$do_contact->insert("contacts_address", array("idcontacts" => $idcontacts));
$do_data_history = new DataHistory();
$do_data_history->add_history($idcontacts, 4, 'add');
$do_data_history->free();
return $idcontacts;
}
}
}
public function map_products_vendor($vendor_name)
{
$security_where = $_SESSION["do_crm_action_permission"]->get_user_where_condition('vendor', 11);
$qry = "select * from `vendor` where `vendor_name` = ? " . $security_where;
$stmt = $this->getDbConnection()->executeQuery($qry, array($vendor_name));
if ($stmt->rowCount() > 0) {
$data = $stmt->fetch();
$idvendor = $data["idvendor"];
return $idvendor;
} else {
if (strlen($vendor_name) > 0) {
$do_vendor = new Vendor();
$data = array("vendor_name" => CommonUtils::purify_input($vendor_name), "iduser" => $_SESSION["do_user"]->iduser, "added_on" => date("Y-m-d H:i:s"));
$do_vendor->insert("vendor", $data);
$idvendor = $do_vendor->getInsertId();
$do_vendor->insert("vendor_address", array("idvendor" => $idvendor));
$do_vendor->insert("vendor_custom_fld", array("idvendor" => $idvendor));
$do_vendor->free();
$do_data_history = new DataHistory();
$do_data_history->add_history($idvendor, 11, 'add');
$do_data_history->free();
return $idvendor;
}
}
}
/**
* 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;
}
}
}
