<?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); }