function entrySetReady($entry)
{
global $invoice_sendto, $systemurl, $login;
if (!count($entry)) {
echo __('No entry found.');
return FALSE;
}
/*
* Set new status
* Set new rev_num, time of edit, etc
*/
$rev_num = $entry['rev_num'] + 1;
mysql_query("UPDATE `entry` SET `invoice_status` = '2', `user_last_edit` = '" . $login['user_id'] . "', `time_last_edit` = '" . time() . "', `rev_num` = '{$rev_num}' WHERE `entry_id` = '" . $entry['entry_id'] . "' LIMIT 1 ;");
$log_data = array();
if (!newEntryLog($entry['entry_id'], 'edit', 'invoice_readyfor', $rev_num, $log_data)) {
echo __('Can\'t log the changes for the entry.');
echo '<br><br>';
return FALSE;
}
if (isset($invoice_sendto) && is_array($invoice_sendto)) {
$entry_summary = 'Bookingid: ' . $entry['entry_id'] . chr(10);
$area = getArea($entry['area_id']);
if (count($area)) {
foreach ($invoice_sendto as $email) {
emailSendDirect($email, 'Booking klar til fakturering - ' . $area['area_name'] . ', ' . date('d.m.Y', $entry['time_start']) . ' (' . $entry['entry_id'] . ')', 'Hei' . chr(10) . chr(10) . $login['user_name'] . ' har satt en ny booking, fra ' . $area['area_name'] . ', klar til fakturering. Bookingen var fra ' . date('d.m.Y', $entry['time_start']) . '.' . chr(10) . chr(10) . 'Gå inn på følgende adresse for å få tilsendt fakturagrunnlagene:' . chr(10) . $systemurl . '/invoice_tobemade_ready.php' . chr(10) . 'Hvis det er flere fakturaer som er klar til fakturering, så kan samtlige hentes ut på likt.' . chr(10) . chr(10) . 'Oppsummert booking:' . chr(10) . 'Bookingid: ' . $entry['entry_id'] . chr(10) . 'Tittel: ' . html_entity_decode($entry['entry_name']) . chr(10) . 'Anlegg: ' . $area['area_name'] . chr(10) . 'Sum eks mva: kr ' . smarty_modifier_commify($entry['eks_mva_tot'], 2, ',', ' ') . chr(10) . ' + MVA kr ' . smarty_modifier_commify($entry['faktura_belop_sum_mva'], 2, ',', ' ') . chr(10) . 'Sum ink. mva: kr ' . smarty_modifier_commify($entry['faktura_belop_sum'], 2, ',', ' ') . chr(10) . chr(10) . 'Mvh. Bookingsystemet');
}
}
}
return TRUE;
}
function testScope()
{
require_once 'func.php';
$area = getArea(20, 14);
print $scope;
print '四角形の面積' . $area;
return $scope;
}
function getAreaFromEntry($entry, $key)
{
$area = getArea($entry[$key . '_id']);
if (count($area)) {
return $area['area_name'];
} else {
return '';
}
}
function getBorrowList($parm = array(), $countonly = false)
{
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'];
//$map = array_merge($map,$search);
if ($countonly) {
return M('borrow_info b')->where($map)->count('b.id');
}
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('borrow_info b')->where($map)->count('b.id');
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,b.borrow_info,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.pro_provide,b.first_verify_time,b.schedular_time";
if ($parm['hotest']) {
$field .= ",IFNULL(b.`full_time`,0)-IFNULL(bv.`deal_time`,0) finish_time";
$list = M('borrow_info')->alias("b")->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->join("{$pre}borrow_verify bv ON b.id=bv.borrow_id")->where($map)->order($orderby)->limit($Lsql)->select();
} else {
$list = M('borrow_info')->alias("b")->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
}
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100, 2);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("Home/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
$list[$key]['schedular_time'] = trans_date_format($v['schedular_time'], 'Y-m-d');
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
return $row;
}
function getBorrowList($parm = array())
{
$map = $parm['map'];
$orderby = $parm['orderby'];
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('borrow_info b')->where($map)->count('b.id');
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
$row['page']['total'] = ceil($count / $parm['pagesize']);
$row['page']['nowPage'] = isset($_REQUEST['p']) ? $_REQUEST['p'] : 1;
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_type,b.updata,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control";
$list = M('borrow_info b')->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100, 2);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("M/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
$img = unserialize($v['updata']);
$list[$key]['image'] = $img['0']['img'];
}
$row['list'] = $list;
return $row;
}
function getBorrowList($parm = array())
{
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'];
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
//require THINK_PATH.'Lib/Util/page.class.php';
$count = M('borrow_info b')->where($map)->count('b.id');
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
//$field = "b.id,b.borrow_name,b.topic,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control";
$field = "b.id,b.borrow_name,b.money_invest_place,b.borrow_type,b.stock_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.stock_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control";
$list = M('borrow_info b')->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$progress = $v['has_borrow'] / $v['borrow_money'] * 100;
$list[$key]['progress'] = $progress > 50 ? floor($progress) : ceil($progress);
//增加floor
//$list[$key]['progress'] = getFloatValue($v['has_borrow']/$v['borrow_money']*100,2);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("Home/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
//新加
$list[$key]['lefttime'] = $v['collect_time'] - time();
if ($v['deadline'] == 0) {
$endTime = strtotime(date("Y-m-d", time()));
if ($v['repayment_type'] == 1) {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} day", $endTime);
} else {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} month", $endTime);
}
} else {
$list[$key]['repaytime'] = $v['deadline'];
//还款时间
}
$list[$key]['publishtime'] = $v['add_time'] + 60 * 60 * 24 * 3;
//预计发标时间=添加时间+1天
if ($v['danbao'] != 0) {
$danbao = M('article')->field("id,title")->where("type_id =7 and id ={$v['danbao']}")->find();
$list[$key]['danbao'] = $danbao['title'];
//担保机构
} else {
$list[$key]['danbao'] = '暂无担保机构';
//担保机构
}
}
$row = array();
$row['list'] = $list;
$row['count'] = $count;
$row['page'] = $page;
return $row;
}
} else {
$date = time();
}
$start = mktime(16, 0, 0, date('m', $date), date('d', $date), date('Y', $date));
$end = mktime(06, 0, 0, date('m', $date), date('d', $date) + 1, date('Y', $date));
$default_area = 6;
if (isset($_GET['area'])) {
$area2 = getArea($_GET['area']);
if (!count($area2)) {
$area = $default_area;
} else {
$area = $area['area_id'];
}
} else {
$area = $default_area;
$area2 = getArea($area);
if (!count($area2)) {
$area = 0;
}
}
echo '<html><head><title>';
if (count($area2)) {
echo $area2['area_name'] . ' - ';
}
echo date('d.m.Y', $start);
echo '</title></head>';
echo '<body background="img/infoskjerm-bg.png" style="margin: 0px; padding: 0px;">' . chr(10);
$Q_room = mysql_query("select id as room_id, room_name from `mrbs_room` where area_id = '" . $area . "' and hidden = 'false'");
$rooms = array();
while ($R_room = mysql_fetch_assoc($Q_room)) {
$rooms[$R_room['room_id']] = $R_room['room_name'];
public function tdetail()
{
if ($_GET['type'] == 'commentlist') {
//评论
$cmap['tid'] = intval($_GET['id']);
$clist = getCommentList($cmap, 5);
$this->assign("commentlist", $clist['list']);
$this->assign("commentpagebar", $clist['page']);
$this->assign("commentcount", $clist['count']);
$data['html'] = $this->fetch('commentlist');
exit(json_encode($data));
}
$pre = C('DB_PREFIX');
$id = intval($_GET['id']);
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//合同ID
if ($this->uid) {
$invs = M('transfer_borrow_investor')->field('id')->where("borrow_id={$id} AND (investor_uid={$this->uid} OR borrow_uid={$this->uid})")->find();
if ($invs['id'] > 0) {
$invsx = $invs['id'];
} elseif (!is_array($invs)) {
$invsx = 'no';
}
} else {
$invsx = 'login';
}
$this->assign("invid", $invsx);
//合同ID
//borrowinfo
//$borrowinfo = M("borrow_info")->field(true)->find($id);
$borrowinfo = M("transfer_borrow_info b")->join("{$pre}transfer_detail d ON d.borrow_id=b.id")->field(true)->find($id);
/*if(!is_array($borrowinfo) || $borrowinfo['is_show'] == 0){
$this->error("数据有误或此标已认购完");
}*/
$borrowinfo['progress'] = getfloatvalue($borrowinfo['transfer_out'] / $borrowinfo['transfer_total'] * 100, 2);
$borrowinfo['need'] = getfloatvalue(($borrowinfo['transfer_total'] - $borrowinfo['transfer_out']) * $borrowinfo['per_transfer'], 2);
$borrowinfo['updata'] = unserialize($borrowinfo['updata']);
$this->assign("vo", $borrowinfo);
//此标借款利息还款相关情况
//memberinfo
$memberinfo = M("members m")->field("m.id,m.customer_name,m.customer_id,m.user_name,m.reg_time,m.credits,fi.*,mi.*,mm.*")->join("{$pre}member_financial_info fi ON fi.uid = m.id")->join("{$pre}member_info mi ON mi.uid = m.id")->join("{$pre}member_money mm ON mm.uid = m.id")->where("m.id={$borrowinfo['borrow_uid']}")->find();
$areaList = getArea();
$memberinfo['location'] = $areaList[$memberinfo['province']] . $areaList[$memberinfo['city']];
$memberinfo['location_now'] = $areaList[$memberinfo['province_now']] . $areaList[$memberinfo['city_now']];
$this->assign("minfo", $memberinfo);
//memberinfo
//investinfo
$fieldx = "bi.investor_capital,bi.transfer_month,bi.transfer_num,bi.add_time,m.user_name,bi.is_auto,bi.final_interest_rate";
$investinfo = M("transfer_borrow_investor bi")->field($fieldx)->join("{$pre}members m ON bi.investor_uid = m.id")->where("bi.borrow_id={$id}")->order("bi.id DESC")->select();
$this->assign("investinfo", $investinfo);
//investinfo
$oneday = 86400;
$time_1 = time() - 30 * $oneday . "," . time();
$time_6 = time() - 180 * $oneday . "," . time();
$time_12 = time() - 365 * $oneday . "," . time();
$mapxr['borrow_id'] = $id;
$this->assign("time_all_out", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['add_time'] = array("between", "{$time_1}");
$this->assign("time_1_out", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['add_time'] = array("between", "{$time_6}");
$this->assign("time_6_out", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['add_time'] = array("between", "{$time_12}");
$this->assign("time_12_out", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr = array();
$mapxr['borrow_id'] = $id;
$mapxr['status'] = 2;
$this->assign("time_all_back", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['back_time'] = array("between", "{$time_1}");
$this->assign("time_1_back", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['back_time'] = array("between", "{$time_6}");
$this->assign("time_6_back", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['back_time'] = array("between", "{$time_12}");
$this->assign("time_12_back", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$this->assign("Bconfig", $Bconfig);
$this->display();
}
$addrQuery = pdoQuery('address_tbl', null, array('c_id' => $_SESSION['customerId'], 'dft_a' => 1), ' limit 1');
}
if ($addrrow = $addrQuery->fetch()) {
$addr = $addrrow;
} else {
$addrrow = array('id' => -1, 'name' => '', 'phone' => '', 'address' => '点击设置收货地址', 'province' => ' ', 'city' => ' ', 'area' => ' ');
$addr = $addrrow;
}
include 'view/order.html.php';
exit;
}
//地址页面修改已存在地址
if (isset($_GET['alterAddress'])) {
$pro = getProvince($_POST['pro']);
$city = getCity($_POST['pro'], $_POST['city']);
$area = getArea($_POST['pro'], $_POST['city'], $_POST['area']);
$value = array('pro_id' => $_POST['pro'], 'city_id' => $_POST['city'], 'area_id' => $_POST['area'], 'area' => $_POST['area'], 'province' => $pro, 'city' => $city, 'area' => $area, 'address' => $_POST['address'], 'name' => $_POST['name'], 'phone' => $_POST['phone']);
if (-1 == $_POST['address_id']) {
$value['c_id'] = $_SESSION['customerId'];
$value['dft_a'] = 0;
$addrId = pdoInsert('address_tbl', $value);
} else {
pdoUpdate('address_tbl', $value, array('id' => $_POST['address_id']));
}
$from = isset($_GET['from']) ? '&from=' . $_GET['from'] : '';
header('location:controller.php?editAddress=1' . $from);
}
if (isset($_GET['editAddress'])) {
$to = $_GET['from'];
$addrQuery = pdoQuery('address_tbl', null, array('c_id' => $_SESSION['customerId']), ' limit 5');
$addrlist = array();
header('Location: admin_entry_type.php');
exit;
} else {
echo 'Error occured while performing query on database:<br>' . chr(10), exit;
}
}
}
include "include/admin_middel.php";
$editor->printEditor();
} elseif (isset($_GET['entry_type_id']) && isset($_GET['area_id'])) {
$entry_type = getEntryType($_GET['entry_type_id']);
if (!count($entry_type)) {
echo 'Finner ikke typen.';
exit;
}
$area = getArea($_GET['area_id']);
if (!count($area)) {
echo __('Can\'t find the area.');
exit;
}
$entry_type_defaultattachment = getEntryTypeDefaultAttachment($_GET['entry_type_id'], $_GET['area_id']);
$saved = false;
if (isset($_POST['attSave'])) {
if (!isset($_POST['attachment']) || !is_array($_POST['attachment'])) {
$_POST['attachment'] = array();
}
// Accept the changes in attachments
$att_new = array();
$att_deleted = $entry_type_defaultattachment;
foreach ($_POST['attachment'] as $att_id) {
$att = getAttachment($att_id);
echo ' <th>Bruker</th>' . chr(10);
echo ' <th>Login</th>' . chr(10);
echo ' <th>Accesslevel</th>' . chr(10);
echo ' <th>Info</th>' . chr(10);
echo ' <th>Valg</th>' . chr(10);
echo ' <th>Grupper som brukeren er medlem av</th>' . chr(10);
echo ' </tr>' . chr(10) . chr(10);
while ($R_user = mysql_fetch_assoc($Q_users)) {
$user = getUser($R_user['user_id'], true);
echo ' <tr>' . chr(10);
echo ' <td>' . $user['user_id'] . '</td>';
echo ' <td>' . '<a href="user.php?user_id=' . $user['user_id'] . '">' . iconHTML('user') . ' ' . $user['user_name'] . '</a>' . '</td>' . chr(10);
echo ' <td>' . $user['user_name_short'] . '</td>' . chr(10);
echo ' <td>' . iconHTML('lock') . ' ' . $user['user_accesslevel'] . '</td>' . chr(10);
echo ' <td>' . '<div class="showButton" id="buttonId' . $user['user_id'] . '"><a href="javascript:void();">Vis / Ikke vis</a></div>' . '<div class="showField" id="fieldId' . $user['user_id'] . '" style="display:none;">' . 'Telefon: ' . $user['user_phone'] . '<br>' . 'E-post: ' . $user['user_email'] . '<br>' . 'Stilling: ' . $user['user_position'] . '<br>';
$area_user = getArea($user['user_area_default']);
if (!count($area_user)) {
$area_user['area_name'] = 'IKKE FUNNET';
}
echo 'Standard bygg: ' . $area_user['area_name'] . '<br>';
echo 'Fakturatilgang: ';
if ($user['user_invoice']) {
echo 'ja';
} else {
echo 'nei';
}
'</div></td>' . chr(10);
echo ' <td>' . '<a href="' . $_SERVER['PHP_SELF'] . '?editor=1&id=' . $user['user_id'] . '">' . iconHTML('user_edit') . ' ' . 'Endre</a>' . '</td>' . chr(10);
echo ' <td>';
if (count($user) && count($user['groups'])) {
echo '<ul style="margin: 0;">' . chr(10);
echo '<script language="javascript" src="js/jquery-1.3.2.min.js"></script>' . chr(10);
//echo nl2br(str_replace(' ', '_ ', print_r($invoice, 1)));
echo '<form method="post" name="invoiceform" action="' . $_SERVER['PHP_SELF'] . '">' . chr(10);
if (count($invoice->invoice_idlinks)) {
$datafrom_string = 'Fakturadata hentet fra' . chr(10);
foreach ($invoice->invoice_idlinks as $link) {
list($idtype, $id) = explode('=', $link);
$datafrom_string .= '- ';
switch ($idtype) {
case 'e':
// Entry
$thisentry = getEntry($id);
if (!count($thisentry)) {
$datafrom_string .= '(BID' . $id . ') UKJENT BOOKING (ikke funnet i databasen)';
} else {
$entryarea = getArea($thisentry['area_id']);
$a = '';
if (count($entryarea)) {
$a = ' - ' . $entryarea['area_name'];
}
$datafrom_string .= 'Booking' . $a . ', ' . date('d-m-Y', $thisentry['time_start']) . ', BID' . $id . ' - ' . '<a href="entry.php?entry_id=' . $thisentry['entry_id'] . '">' . $thisentry['entry_name'] . '</a>';
//' (BID'.$id.')';
if ($thisentry['contact_person_name'] != '') {
$datafrom_string .= ', kontaktperson: ' . $thisentry['contact_person_name'];
}
}
break;
default:
$datafrom_string .= _('Unknown sourcetype');
break;
}
function getAreaIds($area_id_from_default)
{
$area_ids = array();
if (isset($_GET['area'])) {
$split = explode(',', $_GET['area']);
foreach ($split as $id) {
$area_ids[] = (int) $id;
}
}
if (!count($area_ids)) {
$area_ids = array($area_id_from_default);
}
$areas = array();
foreach ($area_ids as $area_id) {
$area = getArea($area_id);
if (count($area)) {
$areas[$area['area_id']] = $area;
}
}
return $areas;
}
public function getBorrowerInfo($bid)
{
$db = core::db()->getConnect('CAILAI', true);
$filed = "bi.borrow_uid,mi.sex,mi.age,mi.education,mi.marry,fi.fin_monthin,m.user_email,m.customer_name,fi.fin_car,m.integral,mi.zy,mm.credit_limit,mi.province,mi.city,mm.account_money,mm.back_money,mm.money_collect,mm.money_freeze ";
$sql = sprintf("SELECT {$filed} FROM`lzh_borrow_info` bi LEFT JOIN lzh_members m ON m.id = bi.borrow_uid LEFT JOIN lzh_member_financial_info fi ON bi.borrow_uid=fi.uid LEFT JOIN `lzh_member_info` mi ON mi.uid=bi.borrow_uid LEFT JOIN `lzh_member_money` mm ON mm.uid=bi.borrow_uid WHERE bi.id=%s", $bid);
$zw = $db->query($sql, "array ");
$borrow_uid = $zw['borrow_uid'];
unset($zw['borrow_uid']);
$zw['fin_monthin'] = getMoneyFormt($zw['fin_monthin']);
$zw['integral'] = (int) $zw['integral'];
$zw['credit_limit'] = (double) $zw['credit_limit'];
if ($zw['fin_car'] == NULL) {
$zw['fin_car'] = '未填写';
}
//借款次数相关
$sql2 = sprintf("SELECT `borrow_status`, COUNT(id) AS num,SUM(borrow_money) AS money,SUM(repayment_money) AS repayment_money FROM `lzh_borrow_info` WHERE borrow_uid = %s GROUP BY borrow_status ", $borrow_uid);
$zw2 = $db->query($sql2);
while ($row = $db->fetchArray($zw2)) {
$borrowCount[$row['borrow_status']] = $row;
}
//借出情况相关
$field3 = "status,count(id) as num,sum(investor_capital) as investor_capital,sum(reward_money) as reward_money,sum(investor_interest) as investor_interest,sum(receive_capital) as receive_capital,sum(receive_interest) as receive_interest,sum(invest_fee) as invest_fee";
$sql3 = sprintf("SELECT {$field3} FROM `lzh_borrow_investor` WHERE investor_uid = %s GROUP BY STATUS ", $borrow_uid);
$zw3 = $db->query($sql3);
$_reward_money = 0;
while ($v = $db->fetchArray($zw3)) {
$investStatus[$v['status']] = $v;
$_reward_money += floatval($v['reward_money']);
}
$rowtj['jkze'] = getFloatValue(floatval($borrowCount[6]['money'] + $borrowCount[7]['money'] + $borrowCount[8]['money'] + $borrowCount[9]['money']), 2);
//借款总额
$rowtj['jcze'] = getFloatValue(floatval($investStatus[4]['investor_capital']), 2);
//借出总额
$rowtj['ysze'] = getFloatValue(floatval($investStatus[4]['receive_capital']), 2);
//应收总额
$rowtj['yhze'] = getFloatValue(floatval($borrowCount[6]['repayment_money'] + $borrowCount[7]['repayment_money'] + $borrowCount[8]['repayment_money'] + $borrowCount[9]['repayment_money']), 2);
//应还总额
$data2['yhze'] = getMoneyFormt(getFloatValue(floatval($borrowCount[6]['repayment_money'] + $borrowCount[7]['repayment_money'] + $borrowCount[8]['repayment_money'] + $borrowCount[9]['repayment_money']), 2));
//应还总额
$data2['dhze'] = getMoneyFormt(getFloatValue($rowtj['jkze'] - $rowtj['yhze'], 2));
//待还总额
$data2['jcze'] = getMoneyFormt(getFloatValue(floatval($investStatus[4]['investor_capital']), 2));
//借出总额
$data2['ysze'] = getMoneyFormt(getFloatValue(floatval($investStatus[4]['receive_capital']), 2));
//应收总额
$data2['dsze'] = getMoneyFormt(getFloatValue($rowtj['jcze'] - $rowtj['ysze'], 2));
//待收总额
$data2['fz'] = getMoneyFormt(getFloatValue($rowtj['jcze'] - $rowtj['jkze'], 2));
$data2['jkcgcs'] = (int) ($borrowCount[6]['num'] + $borrowCount[7]['num'] + $borrowCount[8]['num'] + $borrowCount[9]['num']);
//借款成功次数
$data2['zcze'] = getMoneyFormt(getFloatValue(floatval($zw['account_money'] + $zw['back_money'] + $zw['money_collect'] + $zw['money_freeze']), 2));
//资产总额
//还款情况相关
$field4 = "status,sort_order,borrow_id,sum(capital) as capital,sum(interest) as interest";
$sql4 = sprintf("SELECT {$field4} FROM `lzh_investor_detail` WHERE borrow_uid = %s GROUP BY sort_order, borrow_id ", $borrow_uid);
$zw4 = $db->query($sql4);
while ($v = $db->fetchArray($zw4)) {
// $repaymentStatus[$v['status']]['capital']+=$v['capital'];//当前状态下的数金额
// $repaymentStatus[$v['status']]['interest']+=$v['interest'];//当前状态下的数金额
$repaymentStatus[$v['status']]['num']++;
//当前状态下的总笔数
}
$data2['repayment1'] = (int) $repaymentStatus[1]['num'];
//正常还款次数：
$data2['repayment3'] = (int) $repaymentStatus[3]['num'];
//迟还次数：
$data2['repayment2'] = (int) $repaymentStatus[2]['num'];
//提前还款次数：：
$data2['repayment6'] = (int) $repaymentStatus[6]['num'];
//待还款笔数：
$data2['repayment4'] = (int) $repaymentStatus[4]['num'];
//网站代还次数：：：
$data2['repayment5'] = (int) $repaymentStatus[5]['num'];
//逾期还款笔数：：
$areaList = getArea();
$data2['location'] = $areaList[$zw['province']] . $areaList[$zw['city']];
unset($zw['province'], $zw['city']);
$zz = array_merge($zw, $data2);
return $zz;
}
function templateAssignEntry($var, $entry)
{
global ${$var};
if (count($entry)) {
${$var}->assign('entry_id', $entry['entry_id']);
${$var}->assign('entry_name', $entry['entry_name']);
${$var}->assign('entry_title', $entry['entry_title']);
${$var}->assign('confirm_email', $entry['confirm_email']);
if ($entry['confirm_email']) {
${$var}->assign('confirm_email2', _('yes'));
} else {
${$var}->assign('confirm_email2', _('no'));
}
${$var}->assign('entry_type_id', $entry['entry_type_id']);
if ($entry['entry_type_id'] == 0) {
$entry_type = _('Non selected');
} else {
$entry_type = getEntryType($entry['entry_type_id']);
if (count($entry_type)) {
$entry_type = $entry_type['entry_type_name'];
} else {
$entry_type = 'ERROR';
}
}
${$var}->assign('entry_type', $entry_type);
${$var}->assign('num_person_child', $entry['num_person_child']);
${$var}->assign('num_person_adult', $entry['num_person_adult']);
${$var}->assign('num_person_count', $entry['num_person_count']);
if ($entry['num_person_count']) {
${$var}->assign('num_person_count2', _('yes'));
} else {
${$var}->assign('num_person_count2', _('no'));
}
${$var}->assign('program_id', $entry['program_id']);
$program = getProgram($entry['program_id']);
if (count($program)) {
${$var}->assign('program_id_name', $program['program_name']);
${$var}->assign('program_id_desc', $program['program_desc']);
} else {
${$var}->assign('program_id_name', '');
${$var}->assign('program_id_desc', '');
}
${$var}->assign('program_description', $entry['program_description']);
${$var}->assign('service_alco', $entry['service_alco']);
if ($entry['service_alco']) {
${$var}->assign('service_alco2', _('yes'));
} else {
${$var}->assign('service_alco2', _('no'));
}
${$var}->assign('service_description', $entry['service_description']);
${$var}->assign('comment', $entry['comment']);
${$var}->assign('infoscreen_txt', $entry['infoscreen_txt']);
${$var}->assign('time_start', $entry['time_start']);
${$var}->assign('time_end', $entry['time_end']);
${$var}->assign('room_id', $entry['room_id']);
// Room
$rooms = array();
if (!count($entry['room_id'])) {
$rooms[] = _('Whole area');
} elseif (count($entry['room_id']) == '1') {
// Single room
foreach ($entry['room_id'] as $rid) {
if ($rid == '0') {
$rooms[] = _('Whole area');
} else {
$room = getRoom($rid);
if (count($room)) {
$rooms[] = $room['room_name'];
} else {
$rooms[] = 'ERROR';
}
}
}
} else {
foreach ($entry['room_id'] as $rid) {
if ($rid != '0') {
$room = getRoom($rid);
if (count($room)) {
$rooms[] = $room['room_name'];
} else {
$rooms[] = 'ERROR';
}
}
}
}
if (!count($rooms)) {
$rooms[] = _('Whole area');
}
${$var}->assign('room', implode(', ', $rooms));
${$var}->assign('rooms', $rooms);
${$var}->assign('area_id', $entry['area_id']);
// Area
$area = getArea($entry['area_id']);
if (count($area)) {
$area = $area['area_name'];
} else {
$area = 'ERROR';
}
${$var}->assign('area', $area);
${$var}->assign('user_assigned', $entry['user_assigned']);
${$var}->assign('user_assigned2', $entry['user_assigned2']);
// User_assigned_names
$names = array();
$names2 = array();
foreach ($entry['user_assigned'] as $user_id) {
if ($user_id != 0) {
$user = getUser($user_id);
if (count($user)) {
$names[] = $user['user_name'];
$names2[] = '<a href="user.php?user_id=' . $user['user_id'] . '">' . $user['user_name'] . '</a>';
} else {
$names[] = 'ERROR';
$names2[] = 'ERROR';
}
}
}
if ($entry['user_assigned2'] != '') {
$names[] = $entry['user_assigned2'];
$names2[] = $entry['user_assigned2'];
}
if (!count($names)) {
$names[] = _('Nobody');
$names2[] = _('Nobody');
${$var}->assign('user_assigned_any', false);
} else {
${$var}->assign('user_assigned_any', true);
}
${$var}->assign('user_assigned_names', implode(', ', $names));
${$var}->assign('user_assigned_names2', implode(', ', $names2));
${$var}->assign('customer_id', $entry['customer_id']);
${$var}->assign('customer_name', $entry['customer_name']);
${$var}->assign('contact_person_name', $entry['contact_person_name']);
${$var}->assign('contact_person_phone', $entry['contact_person_phone']);
${$var}->assign('contact_person_email', $entry['contact_person_email']);
${$var}->assign('customer_municipal_num', $entry['customer_municipal_num']);
${$var}->assign('customer_municipal', $entry['customer_municipal']);
${$var}->assign('created_by', $entry['created_by']);
// created_by_name
$user = getUser($entry['created_by']);
if (count($user)) {
${$var}->assign('created_by_name', $user['user_name']);
} else {
${$var}->assign('created_by_name', '');
}
${$var}->assign('time_created', $entry['time_created']);
${$var}->assign('edit_by', $entry['edit_by']);
// Edit_by_names
$names = array();
foreach ($entry['edit_by'] as $user_id) {
$user = getUser($user_id);
if (count($user)) {
$names[] = $user['user_name'];
} else {
$names[] = 'ERROR';
}
}
if (!count($names)) {
$names[] = _('Nobody');
}
${$var}->assign('edit_by_names', implode(', ', $names));
${$var}->assign('time_last_edit', $entry['time_last_edit']);
${$var}->assign('user_last_edit', $entry['user_last_edit']);
$user = getUser($entry['user_last_edit']);
if (count($user)) {
${$var}->assign('user_last_edit_name', $user['user_name']);
} else {
${$var}->assign('user_last_edit_name', '');
}
${$var}->assign('rev_num', $entry['rev_num']);
${$var}->assign('invoice', $entry['invoice']);
if ($entry['invoice'] == '1') {
${$var}->assign('invoice2', true);
${$var}->assign('invoice3', _('yes'));
} else {
${$var}->assign('invoice2', false);
${$var}->assign('invoice3', _('no'));
}
${$var}->assign('invoice_status', $entry['invoice_status']);
switch ($entry['invoice_status']) {
case '0':
${$var}->assign('invoice_status2', _('not to be made'));
break;
case '1':
${$var}->assign('invoice_status2', 'skal lages, ikke klar');
break;
case '2':
${$var}->assign('invoice_status2', 'skal lages, klar til fakturering');
break;
case '3':
${$var}->assign('invoice_status2', 'faktura laget og sendt');
break;
case '4':
${$var}->assign('invoice_status2', 'betalt');
break;
}
${$var}->assign('invoice_electronic', $entry['invoice_electronic']);
if ($entry['invoice_electronic'] == '1') {
${$var}->assign('invoice_electronic2', true);
${$var}->assign('invoice_electronic3', _('yes'));
} else {
${$var}->assign('invoice_electronic2', false);
${$var}->assign('invoice_electronic3', _('no'));
}
${$var}->assign('invoice_email', $entry['invoice_email']);
${$var}->assign('invoice_comment', $entry['invoice_comment']);
${$var}->assign('invoice_internal_comment', $entry['invoice_internal_comment']);
${$var}->assign('invoice_ref_your', $entry['invoice_ref_your']);
${$var}->assign('invoice_address_id', $entry['invoice_address_id']);
$invoice_address = getAddress($entry['invoice_address_id']);
if (count($invoice_address)) {
${$var}->assign('invoice_address', $invoice_address['address_full']);
} else {
${$var}->assign('invoice_address', '');
}
${$var}->assign('invoice_content', $entry['invoice_content']);
${$var}->assign('mva_vis', $entry['mva_vis']);
${$var}->assign('mva', $entry['mva']);
${$var}->assign('mva_grunnlag', $entry['mva_grunnlag']);
${$var}->assign('mva_grunnlag_sum', $entry['mva_grunnlag_sum']);
${$var}->assign('faktura_belop_sum', $entry['faktura_belop_sum']);
${$var}->assign('faktura_belop_sum_mva', $entry['faktura_belop_sum_mva']);
${$var}->assign('eks_mva_tot', $entry['eks_mva_tot']);
${$var}->assign('grunnlag_mva_tot', $entry['grunnlag_mva_tot']);
}
}
function getFullAreaName($Zone_id, $as_ref = 1)
{
$zone = getArea($Zone_id, '`name`, `zone_id`');
if ($zone) {
$name = $zone['name'];
if ($as_ref) {
$name = '<a href="?zone=' . $Zone_id . '">' . $name . '</a>';
}
if ($zone['zone_id']) {
$name = getAreaName($zone['zone_id'], $as_ref) . ' - ' . $name;
}
} else {
$name = "Unknown area - {$Zone_id}";
}
return $name;
}
public function tdetail()
{
if ($_GET['type'] == 'commentlist') {
//评论
$cmap['tid'] = intval($_GET['id']);
$clist = getCommentList($cmap, 5);
$this->assign("commentlist", $clist['list']);
$this->assign("commentpagebar", $clist['page']);
$this->assign("commentcount", $clist['count']);
$data['html'] = $this->fetch('commentlist');
exit(json_encode($data));
}
$pre = C('DB_PREFIX');
$id = intval($_GET['id']);
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//合同ID
if ($this->uid) {
$invs = M('transfer_borrow_investor')->field('id')->where("borrow_id={$id} AND (investor_uid={$this->uid} OR borrow_uid={$this->uid})")->find();
if ($invs['id'] > 0) {
$invsx = $invs['id'];
} elseif (!is_array($invs)) {
$invsx = 'no';
}
} else {
$invsx = 'login';
}
$this->assign("invid", $invsx);
//合同ID
//borrowinfo
//$borrowinfo = M("borrow_info")->field(true)->find($id);
$borrowinfo = M("transfer_borrow_info b")->join("{$pre}transfer_detail d ON d.borrow_id=b.id")->field(true)->find($id);
/*if(!is_array($borrowinfo) || $borrowinfo['is_show'] == 0){
$this->error("数据有误或此标已认购完");
}*/
$borrowinfo['progress'] = getfloatvalue($borrowinfo['transfer_out'] / $borrowinfo['transfer_total'] * 100, 2);
$borrowinfo['need'] = getfloatvalue(($borrowinfo['transfer_total'] - $borrowinfo['transfer_out']) * $borrowinfo['per_transfer'], 2);
$borrowinfo['updata'] = unserialize($borrowinfo['updata']);
if ($borrowinfo['danbao'] != 0) {
$danbao = M('article')->field('id,title')->where("type_id=7 and id={$borrowinfo['danbao']}")->find();
$borrowinfo['danbao'] = $danbao['title'];
//担保机构
$borrowinfo['danbaoid'] = $danbao['id'];
} else {
$borrowinfo['danbao'] = '暂无担保机构';
//担保机构
}
if (time() >= $borrowinfo['deadline'] || $borrowinfo['progress'] == 100) {
$borrowinfo['restday'] = 0;
$borrowinfo['currentday'] = $borrowinfo['add_time'];
} else {
$borrowinfo['restday'] = ceil(($borrowinfo['deadline'] - time()) / (24 * 60 * 60));
$borrowinfo['currentday'] = time();
}
$now = time();
$borrowinfo['aa'] = floor($borrowinfo['collect_day'] - $now);
$borrowinfo['lefttime'] = $borrowinfo['collect_day'] - $now;
$borrowinfo['leftday'] = ceil(($borrowinfo['collect_day'] - $now) / 3600 / 24);
$borrowinfo['leftdays'] = floor(($borrowinfo['collect_day'] - $now) / 3600 / 24) . '天以上';
$money = 100000;
switch ($borrowinfo['repayment_type']) {
//收益
case 2:
//等额本息
$monthData['duration'] = $borrowinfo['borrow_duration'];
$monthData['money'] = $money;
$monthData['year_apr'] = $borrowinfo['borrow_interest_rate'];
$monthData['type'] = "all";
$repay_detail = EqualMonth($monthData);
$borrowinfo['shouyi'] = $repay_detail['repayment_money'] - $money;
break;
case 4:
//每月还息
$monthData['month_times'] = $borrowinfo['borrow_duration'];
$monthData['account'] = $money;
$monthData['year_apr'] = $borrowinfo['borrow_interest_rate'];
$monthData['type'] = "all";
$repay_detail = EqualEndMonth($monthData);
$borrowinfo['shouyi'] = $repay_detail['repayment_account'] - $money;
break;
case 5:
//一次性还款
$borrowinfo['shouyi'] = floor($borrowinfo['borrow_interest_rate'] * $money * $borrowinfo['borrow_duration'] / 12) / 100;
break;
}
$this->assign("vo", $borrowinfo);
//帐户资金情况
$this->assign("investInfo", getMinfo($this->uid, true));
//帐户资金情况
//此标借款利息还款相关情况
//memberinfo
$memberinfo = M("members m")->field("m.id,m.customer_name,m.customer_id,m.user_name,m.reg_time,m.credits,fi.*,mi.*,mm.*")->join("{$pre}member_financial_info fi ON fi.uid = m.id")->join("{$pre}member_info mi ON mi.uid = m.id")->join("{$pre}member_money mm ON mm.uid = m.id")->where("m.id={$borrowinfo['borrow_uid']}")->find();
$areaList = getArea();
$memberinfo['location'] = $areaList[$memberinfo['province']] . $areaList[$memberinfo['city']];
$memberinfo['location_now'] = $areaList[$memberinfo['province_now']] . $areaList[$memberinfo['city_now']];
$this->assign("minfo", $memberinfo);
//memberinfo
//investinfo
$fieldx = "bi.investor_capital,bi.transfer_month,bi.transfer_num,bi.add_time,m.user_name,bi.is_auto,bi.final_interest_rate";
$investinfo = M("transfer_borrow_investor bi")->field($fieldx)->join("{$pre}members m ON bi.investor_uid = m.id")->where("bi.borrow_id={$id}")->order("bi.id DESC")->select();
$this->assign("investinfo", $investinfo);
//investinfo
$oneday = 86400;
$time_1 = time() - 30 * $oneday . "," . time();
$time_6 = time() - 180 * $oneday . "," . time();
$time_12 = time() - 365 * $oneday . "," . time();
$mapxr['borrow_id'] = $id;
$this->assign("time_all_out", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['add_time'] = array("between", "{$time_1}");
$this->assign("time_1_out", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['add_time'] = array("between", "{$time_6}");
$this->assign("time_6_out", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['add_time'] = array("between", "{$time_12}");
$this->assign("time_12_out", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr = array();
$mapxr['borrow_id'] = $id;
$mapxr['status'] = 2;
$this->assign("time_all_back", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['back_time'] = array("between", "{$time_1}");
$this->assign("time_1_back", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['back_time'] = array("between", "{$time_6}");
$this->assign("time_6_back", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
$mapxr['back_time'] = array("between", "{$time_12}");
$this->assign("time_12_back", M("transfer_borrow_investor")->where($mapxr)->sum("transfer_num"));
//评论
$cmap['tid'] = $id;
$clist = getCommentList($cmap, 5);
$this->assign("Bconfig", $Bconfig);
$this->assign("commentlist", $clist['list']);
$this->assign("commentpagebar", $clist['page']);
$this->assign("commentcount", $clist['count']);
$this->display();
}
function entrylist_invoice_tobemade($SQL)
{
$Q = mysql_query($SQL . ' order by `time_start`');
if (!mysql_num_rows($Q)) {
echo _('No entries found.');
} else {
echo '<font color="red">' . mysql_num_rows($Q) . '</font> ' . _('entries found.');
echo '<br>' . chr(10) . chr(10);
echo '<table style="border-collapse: collapse;">' . chr(10);
echo ' <tr>' . chr(10);
echo ' <td style="border: 1px solid black;"><b>Arrangementsdato</b></td>' . chr(10);
echo ' <td style="border: 1px solid black;"><b>' . _('Name') . '</b></td>' . chr(10);
echo ' <td style="border: 1px solid black;"><b>' . _('Area') . '</b></td>' . chr(10);
echo ' </tr>' . chr(10);
while ($R = mysql_fetch_assoc($Q)) {
$entry = getEntry($R['entry_id']);
echo ' <tr>' . chr(10);
// Starts
echo ' <td style="border: 1px solid black;">';
echo '<a href="day.php?year=' . date('Y', $entry['time_start']) . '&month=' . date('m', $entry['time_start']) . '&day=' . date('d', $entry['time_start']) . '&area=' . $entry['area_id'] . '">' . date('d', $entry['time_start']) . '</a>-';
echo '<a href="month.php?year=' . date('Y', $entry['time_start']) . '&month=' . date('m', $entry['time_start']) . '&day=' . date('d', $entry['time_start']) . '&area=' . $entry['area_id'] . '">' . _(date('m', $entry['time_start'])) . '</a>-';
echo date('Y', $entry['time_start']);
echo '</td>' . chr(10);
// Name
echo ' <td style="border: 1px solid black;"><a href="entry.php?entry_id=' . $entry['entry_id'] . '">' . $entry['entry_name'] . '</a></td>' . chr(10);
// Area
echo ' <td style="border: 1px solid black;">';
$area = getArea($entry['area_id']);
if (count($area)) {
echo $area['area_name'];
}
echo '</td>' . chr(10);
echo ' </tr>' . chr(10);
}
echo '</table>';
}
}
function getPointData($area_id, &$data, $x, $y)
{
global $gZoneToAreaImage, $lang;
$area = getAreaIdFromPoint($data['map'], $data['position_x'], $data['position_y'], $data['position_z']);
$area_data = getArea($area);
if (!$area_data) {
return 0;
}
$zone = @$area_data['zone_id'] ? $area_data['zone_id'] : $area;
$areaname = $area_data['zone_id'] ? getAreaName($zone) . " (" . $area_data['name'] . ")" : $area_data['name'];
$img = 'images/map_points/';
$img .= $gZoneToAreaImage[$zone] == $area_id ? 'gps_icon.png' : 'gps_icon1.png';
$imgX = 16;
$imgY = 16;
$name = '';
if (@$data['type'] == 'n') {
$text = getCreatureName($data['id'], 0) . " ({$data['guid']})<br>{$areaname}<br>{$lang['respawn']} " . getTimeText($data['spawntimesecs']);
if (getCreatureEvent($data['guid']) > 0) {
$text = substr_replace("<br>{$lang['spawn_at_event']} - " . getGameEventName(getCreatureEvent($data['guid'])), $text, 0, 0);
}
if (getCreatureEvent($data['guid']) < 0) {
$text = substr_replace("<br>{$lang['despawn_at_event']} - " . getGameEventName(abs(getCreatureEvent($data['guid']))), $text, 0, 0);
}
if (getCreaturePool($data['guid'])) {
$text = substr_replace("<br>{$lang['pool']} (" . getCreaturePool($data['guid']) . ")", $text, 0, 0);
}
if (getCreaturePoolTemplate($data['id'])) {
$text = substr_replace("<br>{$lang['pool']} (" . getCreaturePoolTemplate($data['id']) . ")", $text, 0, 0);
}
}
if (@$data['type'] == 'o') {
$text = getGameobjectName($data['id'], 0) . " ({$data['guid']})<br>{$areaname}<br>{$lang['respawn']} " . getTimeText($data['spawntimesecs']);
if (getGameobjectEvent($data['guid']) > 0) {
$text = substr_replace("<br>{$lang['spawn_at_event']} - " . getGameEventName(getGameobjectEvent($data['guid'])), $text, 0, 0);
}
if (getGameobjectEvent($data['guid']) < 0) {
$text = substr_replace("<br>{$lang['despawn_at_event']} - " . getGameEventName(abs(getGameobjectEvent($data['guid']))), $text, 0, 0);
}
if (getGameobjectPool($data['guid'])) {
$text = substr_replace("<br>{$lang['pool']} (" . getGameobjectPool($data['guid']) . ")", $text, 0, 0);
}
if (getGameobjectPoolTemplate($data['id'])) {
$text = substr_replace("<br>{$lang['pool']} (" . getGameobjectPoolTemplate($data['id']) . ")", $text, 0, 0);
}
}
return array('id' => $data['id'], 'x' => $y, 'y' => $x, 'imgX' => $imgX, 'imgY' => $imgY, 'image' => $img, 'href' => "", 'tooltip' => $text);
}
<?php
require_once 'scripts/php/getxml.php';
//USE HTTP NOT HTTPS!!!!!!!!!!!!!
$alertraw = $_GET['alert'];
$alertID = substr($alertraw, 46);
//$alert = "http://alerts.weather.gov/cap/wwacapget.php?x=AL1253B4A3478C.SevereThunderstormWarning.1253B4A3608CAL.BMXSVSBMX.46618850bf2a2ce3e3083951a2a37391";
$alert = "http://alerts.weather.gov/cap/wwacapget.php?x=" . $alertID;
$coordinates = getCoordinates($alert);
$county = getArea($alert);
//$center = centerMap($county);
?>
<!DOCTYPE html>
<html>
<head>
<title>Area Plot</title>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no">
<meta charset="utf-8">
<style>
html, body, #map-canvas {
height: 100%;
margin: 0;
padding: 0;
}
</style>
<script src="https://maps.googleapis.com/maps/api/js?v=3.exp&signed_in=true"></script>
public function tdetail()
{
if ($_GET['type'] == 'commentlist') {
//评论
$cmap['tid'] = intval($_GET['id']);
$clist = getCommentList($cmap, 5);
$this->assign("commentlist", $clist['list']);
$this->assign("commentpagebar", $clist['page']);
$this->assign("commentcount", $clist['count']);
$data['html'] = $this->fetch('commentlist');
exit(json_encode($data));
}
$pre = C('DB_PREFIX');
$id = intval($_GET['id']);
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
//合同ID
if ($this->uid) {
$invs = M('borrow_investor')->field('id')->where("borrow_id={$id} AND (investor_uid={$this->uid})")->find();
if ($invs['id'] > 0) {
$invsx = $invs['id'];
} elseif (!is_array($invs)) {
$invsx = 'no';
}
} else {
$invsx = 'login';
}
$this->assign("invid", $invsx);
//合同ID
//borrowinfo
//$borrowinfo = M("borrow_info")->field(true)->find($id);
$borrowinfo = M("borrow_info bi")->field('bi.*,ac.title,ac.id as aid')->join('lzh_article ac on ac.id= bi.danbao')->where('bi.id=' . $id)->find();
if (!is_array($borrowinfo) || $borrowinfo['borrow_status'] == 0 && $this->uid != $borrowinfo['borrow_uid']) {
$this->error("数据有误");
}
$borrowinfo['biao'] = $borrowinfo['borrow_times'];
$borrowinfo['need'] = $borrowinfo['borrow_money'] - $borrowinfo['has_borrow'];
$borrowinfo['lefttime'] = $borrowinfo['collect_time'] - time();
$borrowinfo['progress'] = getFloatValue($borrowinfo['has_borrow'] / $borrowinfo['borrow_money'] * 100, 2);
$this->assign("vo", $borrowinfo);
$memberinfo = M("members m")->field("m.id,m.customer_name,m.customer_id,m.user_name,m.reg_time,m.credits,fi.*,mi.*,mm.*")->join("{$pre}member_financial_info fi ON fi.uid = m.id")->join("{$pre}member_info mi ON mi.uid = m.id")->join("{$pre}member_money mm ON mm.uid = m.id")->where("m.id={$borrowinfo['borrow_uid']}")->find();
$areaList = getArea();
$memberinfo['location'] = $areaList[$memberinfo['province']] . $areaList[$memberinfo['city']];
$memberinfo['location_now'] = $areaList[$memberinfo['province_now']] . $areaList[$memberinfo['city_now']];
$memberinfo['zcze'] = $memberinfo['account_money'] + $memberinfo['back_money'] + $memberinfo['money_collect'] + $memberinfo['money_freeze'];
$this->assign("minfo", $memberinfo);
//data_list
$data_list = M("member_data_info")->field('type,add_time,count(status) as num,sum(deal_credits) as credits')->where("uid={$borrowinfo['borrow_uid']} AND status=1")->group('type')->select();
$this->assign("data_list", $data_list);
//data_list
// 投资记录
$this->investRecord($id);
$this->assign('borrow_id', $id);
//近期还款的投标
//$time1 = microtime(true)*1000;
$history = getDurationCount($borrowinfo['borrow_uid']);
$this->assign("history", $history);
//$time2 = microtime(true)*1000;
//echo $time2-$time1;
//investinfo
$fieldx = "bi.investor_capital,bi.add_time,m.user_name,bi.is_auto";
$investinfo = M("borrow_investor bi")->field($fieldx)->join("{$pre}members m ON bi.investor_uid = m.id")->limit(10)->where("bi.borrow_id={$id}")->order("bi.id DESC")->select();
$this->assign("investinfo", $investinfo);
//investinfo
//帐户资金情况
$this->assign("investInfo", getMinfo($this->uid, true));
$this->assign("mainfo", getMinfo($borrowinfo['borrow_uid'], true));
$this->assign("capitalinfo", getMemberBorrowScan($borrowinfo['borrow_uid']));
//帐户资金情况
//展示资料
$show_list = M("member_borrow_show")->where("uid={$borrowinfo['borrow_uid']}")->order('sort DESC')->select();
$this->assign("show_list", $show_list);
//展示资料
//上传资料类型
$upload_type = FilterUploadType(FS("Webconfig/integration"));
$this->assign("upload_type", $upload_type);
// 上传资料所有类型
//评论
$cmap['tid'] = $id;
$clist = getCommentList($cmap, 5);
$this->assign("Bconfig", $Bconfig);
$this->assign("gloconf", $this->gloconf);
$this->assign("commentlist", $clist['list']);
$this->assign("commentpagebar", $clist['page']);
$this->assign("commentcount", $clist['count']);
$this->display();
}
/**
* 跳出页面-任务详情
*/
public function detail()
{
$openid = I('get.openid');
$action = I('get.action');
$itemid = I('get.id', 0);
if (empty($action) || empty($itemid)) {
$this->message('错误，没有找到相关信息');
}
$userid = $this->getCookieUserId($openid);
// 绑定的用户ID
//根据任务id获取任务信息
$data = D('Task')->relation(true)->where(" itemid= {$itemid} ")->find();
$this->assign('data', $data);
//分类的数组s
$areas = getArea(false);
$skills = getMemberSkill(false);
$this->assign('areas', $areas);
$this->assign('skills', $skills);
//获取技术要求
$techList = explode(',', $data['skill']);
$this->assign('techList', $techList);
//附件
$fileList = D('Task_attach')->where(" taskid= {$data['itemid']} AND status = 3")->select();
$this->assign('fileList', $fileList);
// 用户对任务的状态
if ($userid > 0) {
$taskstatus = M('Task_apply')->where(" taskid = {$data['itemid']} AND userid = {$userid} AND companyid = {$data['userid']}")->find();
$this->assign('taskstatus', $taskstatus);
}
$this->meta_title = $data['title'];
$this->assign('openid', $openid);
$this->assign('action', $action);
$this->display('detail');
}
function getTBorrowList($parm = array())
{
/* hycd if(empty($parm['map'])) return;
$map = $parm['map'];
$orderby = $parm['orderby'];
if($parm['pagesize'])
{
import( "ORG.Util.Page" );
$count = M("transfer_borrow_info b")->where($map)->count("b.id");
$p = new \Org\Util\Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
}else{
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C("DB_PREFIX");
$suffix =C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_status,b.borrow_money,b.repayment_type,b.min_month,b.transfer_out,b.transfer_back,b.transfer_total,b.per_transfer,b.borrow_interest_rate,b.borrow_duration,b.increase_rate,b.reward_rate,b.deadline,b.is_show,m.province,m.city,m.area,m.user_name,m.id as uid,m.credits,m.customer_name,b.borrow_type,b.b_img,b.add_time,b.collect_day,b.danbao,b.online_time";
$list = M("transfer_borrow_info b")->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
print_r($list);
$areaList = getarea();
foreach($list as $key => $v)
{
$list[$key]['location'] = $areaList[$v['province']].$areaList[$v['city']];
$list[$key]['progress'] = getfloatvalue( $v['transfer_out'] / $v['transfer_total'] * 100, 2);
$list[$key]['need'] = getfloatvalue(($v['transfer_total'] - $v['transfer_out'])*$v['per_transfer'], 2 );
$list[$key]['burl'] = MU("Home/invest_transfer", "invest_transfer",array("id" => $v['id'],"suffix" => $suffix));
$temp=floor(("{$v['collect_day']}"*3600*24-time()+"{$v['add_time']}")/3600/24);
$list[$key]['leftdays'] = "{$temp}".'天以上';
$list[$key]['now'] = time();
$list[$key]['borrow_times'] = count(M('transfer_borrow_investor') -> where("borrow_id = {$list[$key]['id']}") ->select());
$list[$key]['investornum'] = M('transfer_borrow_investor')->where("borrow_id={$v['id']}")->count("id");
if($v['danbao']!=0 ){
$list[$key]['danbaoid'] = intval($v['danbao']);
$danbao = M('article')->field('id,title')->where("type_id=7 and id={$v['danbao']}")->find();
$list[$key]['danbao']=$danbao['title'];//担保机构
}else{
$list[$key]['danbao']='暂无担保机构';//担保机构
}
//收益率
$monthData['month_times'] = 12;
$monthData['account'] = $v['borrow_money'];
$monthData['year_apr'] = $v['borrow_interest_rate'];
$monthData['type'] = "all";
$repay_detail = CompoundMonth($monthData);
if($v['borrow_duration']==1){
$list[$key]['shouyi'] = $v['borrow_interest_rate'];
}else{
$list[$key]['shouyi'] = $repay_detail['shouyi'];
}
//收益率结束
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
return $row;*/
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'];
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('borrow_info b')->where($map)->count('b.id');
echo $count;
$p = new \Org\Util\Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control,b.borrow_btype";
$list = M('borrow_info b')->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
$areaList = getArea();
foreach ($list as $key => $v) {
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['bollprogress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 86.90000000000001, 2);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("Home/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
//新加
$list[$key]['lefttime'] = $v['collect_time'] - time();
if ($v['deadline'] == 0) {
$endTime = strtotime(date("Y-m-d", time()));
if ($v['repayment_type'] == 1) {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} day", $endTime);
} else {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} month", $endTime);
}
} else {
$list[$key]['repaytime'] = $v['deadline'];
//还款时间
}
$list[$key]['publishtime'] = $v['add_time'] + 60 * 60 * 24 * 3;
//预计发标时间=添加时间+1天
if ($v['danbao'] != 0) {
$danbao = M('article')->field("id,title")->where("type_id =7 and id ={$v['danbao']}")->find();
$list[$key]['danbao'] = $danbao['title'];
//担保机构
} else {
$list[$key]['danbao'] = '暂无担保机构';
//担保机构
}
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
return $row;
}
$area_id_vitenfabrikken = mysql_result($Q, 0, 'area_id');
} else {
$area_id_vitenfabrikken = -1;
}
unset($Q);
if (count($areaArray) && $areaArray['area_name'] == 'Vitengarden') {
$area_name = 'Vitengarden';
$other = $area_id_vitenfabrikken;
} else {
$area_name = 'Vitenfabrikken';
$Q = mysql_query("SELECT id as area_id FROM `mrbs_area` where area_name = 'Vitengarden' limit 1");
if (mysql_num_rows($Q)) {
$other = mysql_result($Q, 0, 'area_id');
}
unset($Q);
$areaArray = getArea($area_id_vitenfabrikken);
if (!count($areaArray)) {
die('Vitenfabrikken not found. System error.');
}
}
$area = $areaArray['area_id'];
$path = './import/datanova-' . strtolower($area_name);
/* The real thing */
if (isset($_GET['importerfil'])) {
// Import of a singel file
$importerfil = str_replace('/', '', $_GET['importerfil']);
$importerfil = trim(str_replace('\\', '', $_GET['importerfil']));
if (isset($_GET['go'])) {
$go = true;
} else {
$go = false;
function getBorrowList($parm = array())
{
if (empty($parm['map'])) {
return;
}
$map = $parm['map'];
$orderby = $parm['orderby'] . "borrow_money-has_borrow DESC ,id DESC";
if ($parm['pagesize']) {
//分页处理
import("ORG.Util.Page");
$count = M('borrow_info b')->where($map)->count('b.id');
// return $sql= M()->getLastSql();
// die;
$p = new Page($count, $parm['pagesize']);
$page = $p->show();
$Lsql = "{$p->firstRow},{$p->listRows}";
//分页处理
} else {
$page = "";
$Lsql = "{$parm['limit']}";
}
$pre = C('DB_PREFIX');
$suffix = C("URL_HTML_SUFFIX");
$field = "b.id,b.borrow_name,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_min,b.borrow_interest_rate,b.borrow_mortgage_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control,b.toubiao_telephone";
// $field = "b.id,b.borrow_name,b.borrow_type,b.reward_type,b.borrow_times,b.borrow_status,b.borrow_money,b.borrow_use,b.repayment_type,b.borrow_min,b.borrow_interest_rate,b.borrow_duration,b.collect_time,b.add_time,b.province,b.has_borrow,b.has_vouch,b.city,b.area,b.reward_type,b.reward_num,b.password,m.user_name,m.id as uid,m.credits,m.customer_name,b.is_tuijian,b.deadline,b.danbao,b.borrow_info,b.risk_control";
$list = M('borrow_info b')->field($field)->join("{$pre}members m ON m.id=b.borrow_uid")->where($map)->order($orderby)->limit($Lsql)->select();
//ORDER BY borrow_money-has_borrow DESC ,id DESC
// echo M()->getLastSql();
// die;
$areaList = getArea();
foreach ($list as $key => $v) {
if (strlen($v['toubiao_telephone']) >= 11) {
$userTelephone = $_SESSION['u_user_name'];
if (strpos($v['toubiao_telephone'], $userTelephone) !== false) {
//此标是否在前端显示
$list[$key]['zw_show'] = 1;
} else {
$list[$key]['zw_show'] = 0;
}
} else {
$list[$key]['zw_show'] = 1;
}
$list[$key]['location'] = $areaList[$v['province']] . $areaList[$v['city']];
$list[$key]['biao'] = $v['borrow_times'];
$list[$key]['need'] = $v['borrow_money'] - $v['has_borrow'];
$list[$key]['leftdays'] = getLeftTime($v['collect_time']);
$list[$key]['progress'] = getFloatValue($v['has_borrow'] / $v['borrow_money'] * 100, 2);
$list[$key]['vouch_progress'] = getFloatValue($v['has_vouch'] / $v['borrow_money'] * 100, 2);
$list[$key]['burl'] = MU("Home/invest", "invest", array("id" => $v['id'], "suffix" => $suffix));
//新加
$list[$key]['lefttime'] = $v['collect_time'] - time();
if ($v['deadline'] == 0) {
$endTime = strtotime(date("Y-m-d", time()));
if ($v['repayment_type'] == 1) {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} day", $endTime);
} else {
$list[$key]['repaytime'] = strtotime("+{$v['borrow_duration']} month", $endTime);
}
} else {
$list[$key]['repaytime'] = $v['deadline'];
//还款时间
}
$list[$key]['publishtime'] = $v['add_time'] + 60 * 60 * 24 * 3;
//预计发标时间=添加时间+1天
if ($v['danbao'] != 0) {
$danbao = M('article')->field("id,title")->where("type_id =7 and id ={$v['danbao']}")->find();
$list[$key]['danbao'] = $danbao['title'];
//担保机构
} else {
$list[$key]['danbao'] = '暂无担保机构';
//担保机构
}
}
$row = array();
$row['list'] = $list;
$row['page'] = $page;
$row['count'] = $count;
return $row;
}
*This is the text that will appear on the menu bar </td>
</tr>
<tr>
<th> App: </th><td>
<select name="appId">
<?php
getApps();
?>
</select>
<?php
echo isSuperuser() ? "" : "*The path to the file with NO leading slash </td>";
?>
</tr>
<tr>
<th> Area: </th><td> <?php
getArea();
?>
</td>
</tr>
<tr>
<th> Permission Needed: </th><td>
<select name='permission'>
<?php
getPermissions();
?>
</select></td>
</tr>
<tr>
<th> Parent Link: </th><td>
<select name='parent'>
<?php
public function invest_people_info()
{
if (!$this->uid) {
$this->qingxian();
}
$pre = C('DB_PREFIX');
$id = intval($_GET['id']);
$Bconfig = (require C("APP_ROOT") . "Conf/borrow_config.php");
$borrowinfo = M("borrow_info bi")->field('bi.*,ac.title,ac.id as aid')->join('lzh_article ac on ac.id= bi.danbao')->where('bi.id=' . $id)->find();
if (!is_array($borrowinfo) || $borrowinfo['borrow_status'] == 0 && $this->uid != $borrowinfo['borrow_uid']) {
$this->error("数据有误");
}
$borrowinfo['biao'] = $borrowinfo['borrow_times'];
$borrowinfo['need'] = $borrowinfo['borrow_money'] - $borrowinfo['has_borrow'];
$borrowinfo['lefttime'] = $borrowinfo['collect_time'] - time();
$borrowinfo['progress'] = getFloatValue($borrowinfo['has_borrow'] / $borrowinfo['borrow_money'] * 100, 2);
$this->assign("vo", $borrowinfo);
$memberinfo = M("members m")->field("m.id,m.user_phone,m.customer_name,m.customer_id,m.user_name,m.reg_time,m.credits,fi.*,mi.*,mm.*")->join("{$pre}member_financial_info fi ON fi.uid = m.id")->join("{$pre}member_info mi ON mi.uid = m.id")->join("{$pre}member_money mm ON mm.uid = m.id")->where("m.id={$borrowinfo['borrow_uid']}")->find();
$areaList = getArea();
if (!$memberinfo) {
$memberinfo['credits'] = 0;
}
$memberinfo['location'] = $areaList[$memberinfo['province']] . $areaList[$memberinfo['city']];
$memberinfo['location_now'] = $areaList[$memberinfo['province_now']] . $areaList[$memberinfo['city_now']];
$memberinfo['zcze'] = $memberinfo['account_money'] + $memberinfo['back_money'] + $memberinfo['money_collect'] + $memberinfo['money_freeze'];
//var_dump($memberinfo);die;
$reg_time = date('Y-m-d H:i:s', $memberinfo['reg_time']);
$this->assign("reg_time", $reg_time);
$this->assign("minfo", $memberinfo);
//$this->assign("capitalinfo", getMemberBorrowScan($borrowinfo['borrow_uid']));
$this->assign("borrow_id", $id);
$this->assign("capitalinfo", getMemberBorrowScan($borrowinfo['borrow_uid']));
$this->display();
}
<?php
include 'config/autoload.php';
if (!isset($_GET['id'])) {
header('Location: categories.php');
}
$area = getArea($db, $_GET['id']);
if (isset($_POST['title'])) {
updateArea($db, $_GET['id'], $_POST['title']);
header('Location: categories.php');
}
?>
<h3>Gestion des catégories : domaine, priorité et thème</h3>
<form action="editArea.php?id=<?php
echo $_GET['id'];
?>
" method="post">
<fieldset>
<legend>Edition du domaine :</legend>
<input type="text" name="title" value="<?php
echo $area['title'];
?>
" placeholder="Libellé du domaine" required>*
<hr>
<input type="submit" value="Editer le domaine">
<input type="reset" value="Reset">
<a href="categories.php"><input type="button" value="Retour"></a>
</fieldset>
</form>
if (count($user)) {
$users_array[] = '<a href="user.php?user_id=' . $user['user_id'] . '">' . $user['user_name'] . '</a>';
}
}
if ($entry['user_assigned2'] != '') {
$users_array[] = $entry['user_assigned2'];
}
if (!count($users_array)) {
$users_array[] = '<i>' . iconHTML('user_delete') . ' ' . _('Nobody') . '</i>';
}
echo implode(', ', $users_array);
echo '</td>
</tr>' . chr(10);
echo '<tr>
<td align="right">' . iconHTML('house') . ' <b>' . _('Area') . ':</b> </td>';
$area = getArea($entry['area_id']);
echo "\t" . '<td>' . $area['area_name'] . '</td>
</tr>' . chr(10);
echo '<tr><td align="right">' . '<img src="./img/icons/shape_square.png" style="border: 0px solid black; vertical-align: middle;"> ' . '<b>' . _('Room') . ':</b> </td><td>';
if (!count($entry['room_id'])) {
echo '<i>' . _('Whole area') . '</i>';
} elseif (count($entry['room_id']) == '1') {
// Single room
foreach ($entry['room_id'] as $rid) {
if ($rid == '0') {
echo '<i>' . _('Whole area') . '</i>';
} else {
$room = getRoom($rid);
if (count($room)) {
echo $room['room_name'];
} else {
mysql_query("\n\t\t\t\tINSERT INTO `programs_defaultattachment`\n\t\t\t\t(`program_id`, `att_id`) VALUES\n\t\t\t\t('" . $conProgram['program_id'] . "', '" . $att['att_id'] . "');\n\t\t\t\t");
if (isset($_GET['redirect']) && $_GET['redirect'] == 'program') {
header('Location: admin_programs.php?program_id=' . $conProgram['program_id']);
} else {
header('Location: ' . $_SERVER['PHP_SELF'] . '?att_id=' . $att['att_id']);
}
exit;
}
if (isset($_POST['connection_entry_type']) && isset($_POST['connection_area'])) {
$conEntryType = getEntryType($_POST['connection_entry_type']);
if (!count($conEntryType)) {
include "include/admin_middel.php";
templateError('Fant ikke bookingtypen du prøvde å koble til vedlegg nr ' . $att['att_id']);
exit;
}
$conArea = getArea($_POST['connection_area']);
if (!count($conArea)) {
include "include/admin_middel.php";
templateError('Fant ikke bygget du prøvde å koble til vedlegg nr ' . $att['att_id']);
exit;
}
mysql_query("\n\t\t\t\tINSERT INTO `entry_type_defaultattachment`\n\t\t\t\t(\n\t\t\t\t\t`entry_type_id`, \n\t\t\t\t\t`area_id`, \n\t\t\t\t\t`att_id`\n\t\t\t\t) VALUES (\n\t\t\t\t\t'" . $conEntryType['entry_type_id'] . "',\n\t\t\t\t\t'" . $conArea['area_id'] . "',\n\t\t\t\t\t'" . $att['att_id'] . "'\n\t\t\t\t);\n\t\t\t\t");
if (isset($_GET['redirect']) && $_GET['redirect'] == 'entry_type') {
header('Location: admin_entry_type.php?entry_type_id=' . $conEntryType['entry_type_id']);
} else {
header('Location: ' . $_SERVER['PHP_SELF'] . '?att_id=' . $att['att_id']);
}
exit;
}
include "include/admin_middel.php";
$entry_types = array();
