function getStatusComboList($selectedvalue = '')
{
$temp_array = getPicklist('ticketstatus');
$status_combo = "<option value=''>" . getTranslatedString('LBL_ALL') . "</option>";
foreach ($temp_array as $index => $val) {
$select = '';
if ($val == $selectedvalue) {
$select = ' selected';
}
$status_combo .= '<option value="' . $val . '"' . $select . '>' . getTranslatedString($val) . '</option>';
}
return $status_combo;
}
function getHints($search, $db)
{
$hints = array();
$search = strtolower($search);
$len = strlen($search);
//$query = "SELECT * FROM Picklist";
//$query = "SELECT * FROM picklist WHERE funtie LIKE '$search'";
$result = "";
if (!($result = getPicklist($db))) {
echo "Fout in query";
//echo $db;
} else {
$i = 0;
while (list($id, $functie) = mysql_fetch_row($result)) {
if (stristr($search, substr($functie, 0, $len)) && strlen($functie) >= strlen($search)) {
$hints[$i] = $functie;
$i++;
}
}
}
return $hints;
}
function search($search, $db, $type)
{
$functies = getHints($search, $db);
$querys = array();
if ($type == "R") {
foreach ($functies as $functie) {
$querys[] = "SELECT * FROM Resources_goed WHERE Functies = (SELECT ID FROM Picklist WHERE functie LIKE \"" . $functie . "\")";
//echo "SELECT * FROM Resources_goed WHERE Functies = (SELECT ID FROM Picklist WHERE functie LIKE \"" . $functie . "\")";
}
} else {
//echo "Projects";
$Picklist = getPicklist($db);
while (list($id, $functie) = mysql_fetch_row($Picklist)) {
if (stristr($search, substr($functie, 0, strlen($search))) && strlen($functie) >= strlen($search)) {
$query = "SELECT * FROM projecten INNER JOIN functies ON ID = functie_ID WHERE ";
for ($i = 1; $i <= 10; $i++) {
if ($i != 10) {
$query .= "Functie{$i} = {$id} OR ";
} else {
$query .= "Functie{$i} = {$id}";
}
}
$querys[] = $query;
//echo $query;
}
}
}
$results = array();
foreach ($querys as $query) {
if (!($result = mysql_query($query, $db))) {
echo "Error in query {$query}";
} else {
$results[] = $result;
//echo $result;
}
}
return $results;
}
/** function used to save the records into database
* @param array $rows - array of total rows of the csv file
* @param array $rows1 - rows to be saved
* @param object $focus - object of the corresponding import module
* @param int $ret_field_count - total number of fields(columns) available in the csv file
* @param int $col_pos_to_field - field position in the mapped array
* @param int $start - starting row count value to import
* @param int $recordcount - count of records to be import ie., number of records to import
* @param string $module - import module
* @param int $totalnoofrows - total number of rows available
* @param int $skip_required_count - number of records skipped
This function will redirect to the ImportStep3 if the available records is greater than the record count (ie., number of records import in a single loop) otherwise (total records less than 500) then it will be redirected to import step last
*/
function InsertImportRecords($rows, $rows1, $focus, $ret_field_count, $col_pos_to_field, $start, $recordcount, $module, $totalnoofrows, $skip_required_count)
{
global $current_user;
global $adb;
global $mod_strings;
global $dup_ow_count;
global $process_fields;
// MWC ** Getting vtiger_users
$users_groups_list = array();
$dup_count = 0;
$count = 0;
$dup_ow_count = 0;
$process_fields = 'false';
if ($start == 0) {
$_SESSION['totalrows'] = $rows;
$_SESSION['return_field_count'] = $ret_field_count;
$_SESSION['column_position_to_field'] = $col_pos_to_field;
}
$ii = $start;
// go thru each row, process and save()
foreach ($rows1 as $row) {
$adb->println("Going to Save the row " . $ii . " =====> ");
$adb->println($row);
global $mod_strings;
$do_save = 1;
//MWC
$my_userid = $current_user->id;
//If we want to set default values for some fields for each entity then we have to set here
if ($module == 'Products' || $module == 'Services') {
//discontinued is not null. if we unmap active, NULL will be inserted and query will fail
$focus->column_fields['discontinued'] = 'on';
}
for ($field_count = 0; $field_count < $ret_field_count; $field_count++) {
p("col_pos[" . $field_count . "]=" . $col_pos_to_field[$field_count]);
if (isset($col_pos_to_field[$field_count])) {
p("set =" . $field_count);
if (!isset($row[$field_count])) {
continue;
}
p("setting");
// TODO: add check for user input
// addslashes, striptags, etc..
$field = $col_pos_to_field[$field_count];
//picklist function is added to avoid duplicate picklist entries
$pick_orginal_val = getPicklist($field, $row[$field_count]);
if ($pick_orginal_val != null) {
$focus->column_fields[$field] = $pick_orginal_val;
} elseif ($field == "assignedto" || $field == "assigned_user_id") {
//Here we are assigning the user id in column fields, so in function assign_user (ImportLead.php and ImportProduct.php files) we should use the id instead of user name when query the user
//or we can use $focus->column_fields['smownerid'] = $users_groups_list[$row[$field_count]];
$row[$field_count] = trim($row[$field_count]);
if (empty($users_groups_list[$row[$field_count]])) {
$id = getUserId_Ol($row[$field_count]);
if (empty($id)) {
$id = getGrpId($row[$field_count]);
}
$users_groups_list[trim($row[$field_count])] = $id;
}
$focus->column_fields[$field] = $users_groups_list[$row[$field_count]];
p("setting my_userid={$my_userid} for user="******"Setting " . $field . "=" . $row[$field_count]);
}
}
}
if ($focus->column_fields['notify_owner'] == '') {
$focus->column_fields['notify_owner'] = '0';
}
if ($focus->column_fields['reference'] == '') {
$focus->column_fields['reference'] = '0';
}
if ($focus->column_fields['emailoptout'] == '') {
$focus->column_fields['emailoptout'] = '0';
}
if ($focus->column_fields['donotcall'] == '') {
$focus->column_fields['donotcall'] = '0';
}
if ($focus->column_fields['discontinued'] == '') {
$focus->column_fields['discontinued'] = '0';
}
if ($focus->column_fields['active'] == '') {
$focus->column_fields['active'] = '0';
}
p("setting done");
p("do save before req vtiger_fields=" . $do_save);
$adb->println($focus->required_fields);
foreach ($focus->required_fields as $field => $notused) {
$fv = trim($focus->column_fields[$field]);
if (!isset($fv) || $fv == '') {
// Leads Import does not allow an empty lastname because the link is created on the lastname
// Without lastname the Lead could not be opened.
// But what if the import file has only company and telefone information?
// It would be stupid to skip all the companies which don't have a contact person yet!
// So we set lastname ="?????" and the user can later enter a name.
// So the lastname is still mandatory but may be empty.
if ($field == 'lastname' && $module == 'Leads') {
$focus->column_fields[$field] = '?????';
} else {
p("fv " . $field . " not set");
$do_save = 0;
$skip_required_count++;
break;
}
}
}
if (!isset($focus->column_fields["assigned_user_id"]) || $focus->column_fields["assigned_user_id"] === '' || $focus->column_fields["assigned_user_id"] === NULL) {
$focus->column_fields["assigned_user_id"] = $my_userid;
}
//added for duplicate handling
if (is_record_exist($module, $focus, $col_pos_to_field)) {
if ($do_save != 0) {
$do_save = 0;
$dup_count++;
}
}
p("do save=" . $do_save);
if ($do_save) {
p("saving..");
if (!isset($focus->column_fields["assigned_user_id"]) || $focus->column_fields["assigned_user_id"] == '') {
//$focus->column_fields["assigned_user_id"] = $current_user->id;
//MWC
$focus->column_fields["assigned_user_id"] = $my_userid;
}
//handle uitype 10
foreach ($focus->importable_fields as $fieldname => $uitype) {
$uitype = $focus->importable_fields[$fieldname];
if ($uitype == 10) {
//added to handle security permissions for related modules :: for e.g. Accounts/Contacts in Potentials
if (method_exists($focus, "add_related_to")) {
if (!$focus->add_related_to($module, $fieldname)) {
if (array_key_exists($fieldname, $focus->required_fields)) {
$do_save = 0;
$skip_required_count++;
continue 2;
}
}
}
}
}
// now do any special processing for ex., map account with contact and potential
if ($process_fields == 'false') {
$focus->process_special_fields();
}
$focus->saveentity($module);
//$focus->saveentity($module);
$return_id = $focus->id;
$last_import = new UsersLastImport();
$last_import->assigned_user_id = $current_user->id;
$last_import->bean_type = $_REQUEST['module'];
$last_import->bean_id = $focus->id;
$last_import->save();
$count++;
}
$ii++;
}
$_REQUEST['count'] = $ii;
if (isset($_REQUEST['module'])) {
$modulename = vtlib_purify($_REQUEST['module']);
}
$end = $start + $recordcount;
$START = $start + $recordcount;
$RECORDCOUNT = $recordcount;
$dup_check_type = $_REQUEST['dup_type'];
$auto_dup_type = $_REQUEST['auto_type'];
if ($end >= $totalnoofrows) {
$module = 'Import';
//$_REQUEST['module'];
$action = 'ImportSteplast';
//exit;
$imported_records = $totalnoofrows - $skip_required_count;
if ($imported_records == $totalnoofrows) {
$skip_required_count = 0;
}
if ($dup_check_type == "auto") {
if ($auto_dup_type == "ignore") {
$dup_info = $mod_strings['Duplicate_Records_Skipped_Info'] . $dup_count;
$imported_records -= $dup_count;
} else {
if ($auto_dup_type == "overwrite") {
$dup_info = $mod_strings['Duplicate_Records_Overwrite_Info'] . $dup_ow_count;
$imported_records -= $dup_ow_count;
}
}
} else {
$dup_info = "";
}
if ($imported_records < 0) {
$imported_records = 0;
}
$message = urlencode("<b>" . $mod_strings['LBL_SUCCESS'] . "</b>" . "<br><br>" . $mod_strings['LBL_SUCCESS_1'] . " {$imported_records} " . $mod_strings['of'] . ' ' . $totalnoofrows . "<br><br>" . $mod_strings['LBL_SKIPPED_1'] . " {$skip_required_count} <br><br>" . $dup_info);
} else {
$module = 'Import';
$action = 'ImportStep3';
}
?>
<script>
setTimeout("b()",1000);
function b()
{
document.location.href="index.php?action=<?php
echo $action;
?>
&module=<?php
echo $module;
?>
&modulename=<?php
echo $modulename;
?>
&startval=<?php
echo $end;
?>
&recordcount=<?php
echo $RECORDCOUNT;
?>
&noofrows=<?php
echo $totalnoofrows;
?>
&message=<?php
echo $message;
?>
&skipped_record_count=<?php
echo $skip_required_count;
?>
&parenttab=<?php
echo vtlib_purify($_SESSION['import_parenttab']);
?>
&dup_type=<?php
echo $dup_check_type;
?>
&auto_type=<?php
echo $auto_dup_type;
?>
";
}
</script>
<?php
$_SESSION['import_display_message'] = '<br>' . $start . ' ' . $mod_strings['to'] . ' ' . $end . ' ' . $mod_strings['of'] . ' ' . $totalnoofrows . ' ' . $mod_strings['are_imported_succesfully'];
//return $_SESSION['import_display_message'];
}
</td>
</tr>
<tr>
<td class="small">
<table border="0" cellspacing="0" cellpadding="0" width="95%" align="center" bgcolor="white">
<tbody>
<tr>
<td colspan="4" class="detailedViewHeader" style="background:#dddcdd url(images/inner.gif) bottom repeat-x;border:1px solid #DDDDDD;padding:12px;color:#000000;">
<label>
<span class="lbl"><b><?php
echo getTranslatedString('TICKET_CATEGORY');
?>
</b></span>
</label>
<?php
$category_array = getPicklist('ticketcategories');
echo getComboList('search_ticketcategory', $category_array, ' ');
?>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td class="small">
<table border="0" cellspacing="0" cellpadding="0" width="95%" align="center" bgcolor="white">
<tbody>
<tr>
<td colspan="4" class="detailedViewHeader" style="background:#dddcdd url(images/inner.gif) bottom repeat-x;border:1px solid #DDDDDD;padding:12px;color:#000000;">
<label>
<aside class="right-side">
<section class="content-header" style="box-shadow:none;">
<div class="row-pad">
<div class="col-sm-10">
<div class="btn-group">
<button type="button" class="btn btn-default dropdown-toggle ticket_status_btn" data-toggle="dropdown">
Status <span class="caret"></span>
</button>
<ul class="dropdown-menu ticket_status">
<li><a href="#"><?php
echo getTranslatedString('LBL_ALL');
?>
</a></li>
<?php
$temp_array = getPicklist('ticketstatus');
foreach ($temp_array as $index => $val) {
$select = '';
if ($val == $selectedvalue) {
$select = ' selected';
}
echo '<li><a href = "#">' . getTranslatedString($val) . '</a></li>';
}
?>
</ul>
</div>
<?php
$show = $client->call('show_all', array('module' => 'HelpDesk'), $Server_Path, $Server_Path);
if ($show == 'true') {
?>
<div class="btn-group">
/** function used to save the records into database
* @param array $rows - array of total rows of the csv file
* @param array $rows1 - rows to be saved
* @param object $focus - object of the corresponding import module
* @param int $ret_field_count - total number of fields(columns) available in the csv file
* @param int $col_pos_to_field - field position in the mapped array
* @param int $start - starting row count value to import
* @param int $recordcount - count of records to be import ie., number of records to import
* @param string $module - import module
* @param int $totalnoofrows - total number of rows available
* @param int $skip_required_count - number of records skipped
This function will redirect to the ImportStep3 if the available records is greater than the record count (ie., number of records import in a single loop) otherwise (total records less than 500) then it will be redirected to import step last
*/
function InsertImportRecords($rows, $rows1, $focus, $ret_field_count, $col_pos_to_field, $start, $recordcount, $module, $totalnoofrows, $skip_required_count)
{
global $current_user;
global $adb;
global $mod_strings;
global $dup_ow_count;
global $process_fields;
$acc_config = Accounting::loadConfigParams();
// MWC ** Getting vtiger_users
$temp = get_user_array(FALSE);
foreach ($temp as $key => $data) {
$users_groups_list[$data] = $key;
}
$temp = get_group_array(FALSE);
foreach ($temp as $key => $data) {
$users_groups_list[$data] = $key;
}
p(print_r(users_groups_list, 1));
$adb->println("Users List : ");
$adb->println($users_groups_list);
$dup_count = 0;
$count = 0;
$dup_ow_count = 0;
$process_fields = 'false';
if ($start == 0) {
$_SESSION['totalrows'] = $rows;
$_SESSION['return_field_count'] = $ret_field_count;
$_SESSION['column_position_to_field'] = $col_pos_to_field;
}
$ii = $start;
// go thru each row, process and save()
$lastacc = "";
$bMultiple = false;
$rows2 = array();
$payments = array();
$sub = 0;
$ref_idx = "";
foreach ($col_pos_to_field as $idx => $fld) {
if ($fld == "accounting_id") {
$ref_idx = $idx;
break;
}
}
$ref_idx = 0;
foreach ($rows1 as $row) {
if (array_key_exists($row[0], $payments) == false) {
$bMultiple = false;
} else {
$bMultiple = true;
}
/*
if ($row[0] == $lastacc) {
$bMultiple = true;
} else {
$bMultiple = false;
}
$lastacc = $row[0];
*/
if ($bMultiple == false) {
array_push($rows2, $row);
$payments[$row[0]] = array();
} else {
$sub++;
}
$idx = 1;
$paid = $row[$ret_field_count - $idx++];
if ($acc_config["associnvoice"] == "true") {
$associnv = $row[$ret_field_count - $idx++];
}
$paymentmethod = $row[$ret_field_count - $idx++];
if ($acc_config["showvat"] == "true") {
$tax = $row[$ret_field_count - $idx++];
}
$amount = $row[$ret_field_count - $idx++];
$paymentdate = $row[$ret_field_count - $idx++];
$paymentduedate = $row[$ret_field_count - $idx++];
$ref = $row[$ret_field_count - $idx++];
$invid = '';
$assocmodule = '';
$assocdisplay = '';
if ($associnv != "") {
//check the module of the field
$arr = array();
$arr = explode("::::", $associnv);
$assocmodule = $arr[0];
$assocdisplay = $arr[1];
$focus1 = CRMEntity::getInstance($assocmodule);
$entityNameArr = getEntityField($assocmodule);
$entityName = $entityNameArr['fieldname'];
$query = "SELECT vtiger_crmentity.deleted, {$focus1->table_name}.*\n\t\t\t\t\t\tFROM {$focus1->table_name}\n\t\t\t\t\t\tINNER JOIN vtiger_crmentity ON vtiger_crmentity.crmid={$focus1->table_name}.{$focus1->table_index}\n\t\t\t\t\t\t\twhere {$entityName}=? and vtiger_crmentity.deleted=0";
$result = $adb->pquery($query, array($assocdisplay));
$invid = $adb->query_result($result, 0, $focus1->table_index);
}
$payment = array('ref' => $ref, 'paymentduedate' => $paymentduedate, 'paymentdate' => $paymentdate, 'amount' => $amount, 'paymenttax' => $tax, 'paymentmethod' => $paymentmethod, 'associnv' => $invid, 'associnv_display' => $assocdisplay, 'paymentassoc_mod' => $assocmodule, 'paid' => $paid);
array_push($payments[$row[0]], $payment);
}
$totalnoofrows -= $sub;
$rows1 = $rows2;
$recordcount = count($rows1);
foreach ($rows1 as $row) {
$adb->println("Going to Save the row " . $ii . " =====> ");
$adb->println($row);
global $mod_strings;
$do_save = 1;
//MWC
$my_userid = $current_user->id;
//If we want to set default values for some fields for each entity then we have to set here
if ($module == 'Products' || $module == 'Services') {
//discontinued is not null. if we unmap active, NULL will be inserted and query will fail
$focus->column_fields['discontinued'] = 'on';
}
for ($field_count = 0; $field_count < $ret_field_count; $field_count++) {
p("col_pos[" . $field_count . "]=" . $col_pos_to_field[$field_count]);
if (isset($col_pos_to_field[$field_count])) {
p("set =" . $field_count);
if (!isset($row[$field_count])) {
continue;
}
p("setting");
// TODO: add check for user input
// addslashes, striptags, etc..
$field = $col_pos_to_field[$field_count];
//picklist function is added to avoid duplicate picklist entries
$pick_orginal_val = getPicklist($field, $row[$field_count]);
if ($pick_orginal_val != null) {
$focus->column_fields[$field] = $pick_orginal_val;
} elseif ($field == "assignedto" || $field == "assigned_user_id") {
//Here we are assigning the user id in column fields, so in function assign_user (ImportLead.php and ImportProduct.php files) we should use the id instead of user name when query the user
//or we can use $focus->column_fields['smownerid'] = $users_groups_list[$row[$field_count]];
$imported_user = $current_user->id;
$q = "SELECT groupid FROM vtiger_groups WHERE groupname=?";
$res = $adb->pquery($q, array(trim($row[$field_count])));
if ($adb->num_rows($res) > 0) {
$imported_user = $adb->query_result($res, 0, "groupid");
} else {
$q = "SELECT id FROM vtiger_users WHERE user_name=?";
$res = $adb->pquery($q, array(trim($row[$field_count])));
if ($adb->num_rows($res) == 0) {
$imported_user = $adb->query_result($res, 0, "id");
}
}
$focus->column_fields[$field] = $imported_user;
p("setting my_userid={$my_userid} for user="******"Setting " . $field . "=" . $row[$field_count]);
}
}
}
if ($focus->column_fields['notify_owner'] == '') {
$focus->column_fields['notify_owner'] = '0';
}
if ($focus->column_fields['reference'] == '') {
$focus->column_fields['reference'] = '0';
}
if ($focus->column_fields['emailoptout'] == '') {
$focus->column_fields['emailoptout'] = '0';
}
if ($focus->column_fields['donotcall'] == '') {
$focus->column_fields['donotcall'] = '0';
}
if ($focus->column_fields['discontinued'] == '') {
$focus->column_fields['discontinued'] = '0';
}
if ($focus->column_fields['active'] == '') {
$focus->column_fields['active'] = '0';
}
p("setting done");
p("do save before req vtiger_fields=" . $do_save);
$adb->println($focus->required_fields);
foreach ($focus->required_fields as $field => $notused) {
$fv = trim($focus->column_fields[$field]);
if (!isset($fv) || $fv == '') {
// Leads Import does not allow an empty lastname because the link is created on the lastname
// Without lastname the Lead could not be opened.
// But what if the import file has only company and telefone information?
// It would be stupid to skip all the companies which don't have a contact person yet!
// So we set lastname ="?????" and the user can later enter a name.
// So the lastname is still mandatory but may be empty.
if ($field == 'lastname' && $module == 'Leads') {
$focus->column_fields[$field] = '?????';
} else {
p("fv " . $field . " not set");
$do_save = 0;
$skip_required_count++;
break;
}
}
}
if (!isset($focus->column_fields["assigned_user_id"]) || $focus->column_fields["assigned_user_id"] === '' || $focus->column_fields["assigned_user_id"] === NULL) {
$focus->column_fields["assigned_user_id"] = $my_userid;
}
//added for duplicate handling
if (is_record_exist($module, $focus)) {
if ($do_save != 0) {
$do_save = 0;
$dup_count++;
}
}
p("do save=" . $do_save);
if ($do_save) {
p("saving..");
if (!isset($focus->column_fields["assigned_user_id"]) || $focus->column_fields["assigned_user_id"] == '') {
//$focus->column_fields["assigned_user_id"] = $current_user->id;
//MWC
$focus->column_fields["assigned_user_id"] = $my_userid;
}
//handle uitype 10
foreach ($focus->importable_fields as $fieldname => $uitype) {
$uitype = $focus->importable_fields[$fieldname];
if ($uitype == 10) {
//added to handle security permissions for related modules :: for e.g. Accounts/Contacts in Potentials
if (method_exists($focus, "add_related_to")) {
if (!$focus->add_related_to($module, $fieldname)) {
if (array_key_exists($fieldname, $focus->required_fields)) {
$do_save = 0;
$skip_required_count++;
continue 2;
}
}
}
}
}
// now do any special processing for ex., map account with contact and potential
if ($process_fields == 'false') {
$focus->process_special_fields();
}
$focus->saveentity($module);
//$focus->saveentity($module);
$return_id = $focus->id;
// $focus->column_fields['accounting_id']
$sql = "INSERT INTO vtiger_accounting_payments (idtransaction, amount," . ($acc_config["showvat"] == "true" ? "tax," : "") . " paymentduedate, paymentdate, paid, ref," . ($acc_config["associnvoice"] == "true" ? "associnv,assoc_display,assoc_mod," : "") . " paymentmethod) VALUES (" . ($acc_config["showvat"] == "true" ? "?," : "") . ($acc_config["associnvoice"] == "true" ? "?,?,?," : "") . "?, ?, ?, ?, ?, ?, ?)";
foreach ($payments[$row[0]] as $payment) {
if ($acc_config["associnvoice"] == "true" && $acc_config["showvat"] == "true") {
$data_arr = array($return_id, $payment['amount'], $payment['paymenttax'], $payment['paymentduedate'], $payment['paymentdate'], $payment['paid'], $payment['ref'], $payment['associnv'], $payment['associnv_display'], $payment['paymentassoc_mod'], $payment['paymentmethod']);
} else {
if ($acc_config["associnvoice"] == "true" && $acc_config["showvat"] == "false") {
$data_arr = array($return_id, $payment['amount'], $payment['paymentduedate'], $payment['paymentdate'], $payment['paid'], $payment['ref'], $payment['associnv'], $payment['associnv_display'], $payment['paymentassoc_mod'], $payment['paymentmethod']);
} else {
if ($acc_config["associnvoice"] == "false" && $acc_config["showvat"] == "true") {
$data_arr = array($return_id, $payment['amount'], $payment['paymenttax'], $payment['paymentduedate'], $payment['paymentdate'], $payment['paid'], $payment['ref'], $payment['paymentmethod']);
} else {
if ($acc_config["associnvoice"] == "false" && $acc_config["showvat"] == "false") {
$data_arr = array($return_id, $payment['amount'], $payment['paymentduedate'], $payment['paymentdate'], $payment['paid'], $payment['ref'], $payment['paymentmethod']);
}
}
}
}
foreach ($data_arr as &$param) {
if (!isset($param)) {
$param = "";
}
}
$res = $adb->pquery($sql, $data_arr);
}
$last_import = new UsersLastImport();
$last_import->assigned_user_id = $current_user->id;
$last_import->bean_type = $_REQUEST['module'];
$last_import->bean_id = $focus->id;
$last_import->save();
$count++;
}
$ii++;
}
$_REQUEST['count'] = $ii;
if (isset($_REQUEST['module'])) {
$modulename = vtlib_purify($_REQUEST['module']);
}
$end = $start + $recordcount;
$START = $start + $recordcount;
$RECORDCOUNT = $recordcount;
$dup_check_type = $_REQUEST['dup_type'];
$auto_dup_type = $_REQUEST['auto_type'];
if ($end >= $totalnoofrows) {
$module = 'Import';
//$_REQUEST['module'];
$action = 'ImportSteplast';
//exit;
$imported_records = $totalnoofrows - $skip_required_count;
if ($imported_records == $totalnoofrows) {
$skip_required_count = 0;
}
if ($dup_check_type == "auto") {
if ($auto_dup_type == "ignore") {
$dup_info = $mod_strings['Duplicate_Records_Skipped_Info'] . $dup_count;
$imported_records -= $dup_count;
} else {
if ($auto_dup_type == "overwrite") {
$dup_info = $mod_strings['Duplicate_Records_Overwrite_Info'] . $dup_ow_count;
$imported_records -= $dup_ow_count;
}
}
} else {
$dup_info = "";
}
if ($imported_records < 0) {
$imported_records = 0;
}
$message = urlencode("<b>" . $mod_strings['LBL_SUCCESS'] . "</b>" . "<br><br>" . $mod_strings['LBL_SUCCESS_1'] . " {$imported_records} " . $mod_strings['of'] . ' ' . $totalnoofrows . "<br><br>" . $mod_strings['LBL_SKIPPED_1'] . " {$skip_required_count} <br><br>" . $dup_info);
} else {
$module = 'Import';
$action = 'ImportStep3';
}
?>
<script>
setTimeout("b()",1000);
function b()
{
document.location.href="index.php?action=<?php
echo $action;
?>
&module=<?php
echo $module;
?>
&modulename=<?php
echo $modulename;
?>
&startval=<?php
echo $end;
?>
&recordcount=<?php
echo $RECORDCOUNT;
?>
&noofrows=<?php
echo $totalnoofrows;
?>
&message=<?php
echo $message;
?>
&skipped_record_count=<?php
echo $skip_required_count;
?>
&parenttab=<?php
echo vtlib_purify($_SESSION['import_parenttab']);
?>
&dup_type=<?php
echo $dup_check_type;
?>
&auto_type=<?php
echo $auto_dup_type;
?>
";
}
</script>
<?php
$_SESSION['import_display_message'] = '<br>' . $start . ' ' . $mod_strings['to'] . ' ' . $end . ' ' . $mod_strings['of'] . ' ' . $totalnoofrows . ' ' . $mod_strings['are_imported_succesfully'];
//return $_SESSION['import_display_message'];
}
