<?php
$addr = array();
$addr['lastname'] = getIfSet($rec, 0);
$addr['firstname'] = getIfSet($rec, 1);
$addr['company'] = "";
// tbd at export
$date_parts = explode(".", getIfSet($rec, 2));
if (count($date_parts) == 3) {
$addr['bday'] = ltrim($date_parts[0], "0");
$addr['bmonth'] = MonthToName($date_parts[1]);
$addr['byear'] = $date_parts[2];
}
$addr['address'] = getIfSet($rec, 3) . "\n" . getIfSet($rec, 4) . " " . getIfSet($rec, 5);
$addr['home'] = getIfSet($rec, 6);
$addr['mobile'] = getIfSet($rec, 7);
$addr['work'] = getIfSet($rec, 9);
$addr['fax'] = getIfSet($rec, 10);
$addr['email'] = getIfSet($rec, 8);
$addr['email2'] = getIfSet($rec, 11);
$addr['address2'] = str_replace(", ", "\n", getIfSet($rec, 12));
$addr['phone2'] = getIfSet($rec, 13);
function dev_NewChannelPrinter(&$e)
{
dev_GenericEventPrinter("NewChan", getIfSet($e, 'ChannelStateDesc'), getIfSet($e, 'Uniqueid'), '--', getIfSet($e, 'Channel'), '--', $e["CallerIDNum"], getIfSet($e, 'Exten'));
}
</form>
<br><br>
<i>Sample (.csv, .xls): <a href="import_sample.csv">import_sample.csv</a></i>
<?php
} else {
if ($_FILES["file"]["error"] > 0 || $read_only) {
echo "Error: " . $_FILES["file"]["error"] . "<br />";
} else {
$file_tmp_name = $_FILES["file"]["tmp_name"];
$file_lines = file($file_tmp_name, FILE_IGNORE_NEW_LINES);
$file_name = $_FILES["file"]["name"];
include "include/import.common.php";
//
// Save the group & addresses
//
$file_group_name = "";
if (count($ab) > 0) {
$file_group_name = "@IMPORT-" . $file_name . "-" . Date("Y-m-j_H:i:s");
saveGroup($file_group_name);
}
foreach ($ab as $addressbook) {
saveAddress($addressbook, $file_group_name);
echo "- <b><i>" . getIfSet($addressbook, 'firstname') . trim(" " . getIfSet($addressbook, 'middlename')) . ", " . getIfSet($addressbook, 'lastname') . "</i></b>, " . getIfSet($addressbook, 'email') . ", " . getIfSet($addressbook, 'email2') . ", " . getIfSet($addressbook, 'company') . "<br>";
}
echo "<br/><br/><div class='msgbox'>The " . $import_type . "-file '" . $_FILES["file"]["name"] . "' is imported into " . count($ab) . " records<br/>";
echo "<i>of the new group <a href='index{$page_ext}?group_name=" . $file_group_name . "'>" . $file_group_name . "</a></i></div>";
//*/
}
}
// end if(!$submit)
include "include/footer.inc.php";
/**
* Takes a result set and creates a simple array object.
*
* @param string $moduleName set to "accounts", "leads", or "contacts"
* @param array $innerResultSet Results from function find_beans_db_query
* @param object $current_user Global current_user object - allows db access
* @return array Returns contacts
*/
function convert_bean_to_simple_array($moduleName, $innerResultSet, $current_user)
{
$beans = array();
while ($beanRow = $current_user->db->fetchByAssoc($innerResultSet)) {
$parentName = '';
$parentId = '';
$parentModule = '';
if (!empty($beanRow['parent_name'])) {
$parentName = getIfSet($beanRow, 'parent_name', "");
$parentId = getIfSet($beanRow, 'parent_id', "");
$parentModule = getIfSet($beanRow, 'parent_module', "");
}
$beanName = getIfSet($beanRow, 'bean_last_name', "");
if (!empty($beanRow['bean_first_name'])) {
$beanName = $beanRow['bean_first_name'] . " " . getIfSet($beanRow, 'bean_last_name', "");
}
$beanId = $beanRow['bean_id'];
$bean = array('bean_module' => $moduleName, 'bean_id' => $beanId, 'bean_name' => $beanName, 'bean_description' => getIfSet($beanRow, 'bean_description', ""), 'bean_link' => build_link($moduleName, $beanId), 'parent_name' => $parentName, 'parent_module' => $parentModule, 'parent_id' => $parentId, 'parent_link' => build_link($parentName, $parentId));
$beans[] = $bean;
}
return $beans;
}
?>
<script type="text/javascript">
var title=document.getElementsByTagName("title")[0];
title.innerHTML+=" as '<?php
echo htmlspecialchars($temp_user);
?>
'";
</script>
<?php
}
}
$json = json_decode(getDataJSON($temp_user), true);
if (getIfSet($_POST, 'doAdd', "false") == "true") {
global $conn, $ustabl;
$key = getIfSet($_POST, 'key');
$val = getIfSet($_POST, 'value');
$data = explode(';', $key);
$key = $data[0];
$title = $data[1];
$json[$key]['title'] = $title;
$json[$key]['value'] = $val;
$newjson = json_encode($json);
$sql = "UPDATE {$ustabl} SET data='{$newjson}' WHERE username='******';";
/* ?><span class="code"> <?= $sql ?> </span><br> <?php //*/
$result = $conn->query($sql);
}
?>
<h1 class="nomp code"><?php
echo htmlspecialchars($temp_user);
?>
</h1> <?php
<?php
$off = isset($off) ? $off : 0;
$addr = array();
$addr['lastname'] = getIfSet($rec, $off + 3);
$addr['firstname'] = getIfSet($rec, $off + 1) . (getIfSet($rec, $off + 2) != "" ? " " . getIfSet($rec, $off + 2) : "");
$addr['company'] = getIfSet($rec, $off + 5);
$date_parts = explode(".", getIfSet($rec, $off + 65));
if (count($date_parts) == 3 && $date_parts[0] != 0) {
$addr['bday'] = ltrim($date_parts[0], "0");
$addr['bmonth'] = MonthToName($date_parts[1]);
$addr['byear'] = $date_parts[2];
}
$addr['address'] = getIfSet($rec, $off + 15) . "\n" . getIfSet($rec, $off + 20) . " " . getIfSet($rec, $off + 18);
// tbd: improved guess of all possible # (rows 30-48)
$addr['home'] = getIfSet($rec, $off + 37);
$addr['mobile'] = getIfSet($rec, $off + 40);
$addr['work'] = getIfSet($rec, $off + 31);
$addr['fax'] = getIfSet($rec, $off + 30);
$addr['email'] = getIfSet($rec, $off + 56) == "SMTP" ? getIfSet($rec, $off + 55) : "";
$addr['email2'] = getIfSet($rec, $off + 59) == "SMTP" ? getIfSet($rec, $off + 58) : "";
$addr['homepage'] = getIfSet($rec, $off + 90);
$addr['address2'] = getIfSet($rec, $off + 8) . "\n" . getIfSet($rec, $off + 13) . " " . getIfSet($rec, $off + 11);
$addr['phone2'] = getIfSet($rec, $off + 42);
<?php
$off = isset($off) ? $off : 0;
$addr = array();
$names = explode(" ", getIfSet($rec, $off + 3));
$addr['firstname'] = array_pop($names);
if ($addr !== NULL) {
$addr['lastname'] = implode(" ", $names);
}
// tbd: improved guess of all possible # (rows 30-48)
$addr['home'] = getIfSet($rec, $off + 13);
$addr['mobile'] = getIfSet($rec, $off + 14);
$addr['work'] = getIfSet($rec, $off + 28);
//
// Write line+result to HTML
//
$debug_import = false;
if ($debug_import) {
print_r($rec);
print_r($addr);
}
