function workbench_registadd($rid, $hour, $number, $type)
{
global $_USER;
$registration_log = array('rid' => $rid, 'hour' => $hour, 'number' => $number, 'type' => $type);
insert_db('registration_log', $registration_log);
return;
}
public function config_user()
{
global $db;
$user = array('username' => 'CRMUSER', 'password' => '96e79218965eb72c92a549dd5a330112', 'groupid' => '1', 'ischeck' => '1');
insert_db('user', $user);
$id = $db->insert_id();
$user_view = array('name' => 'CRMUSER');
insert_db('user_view', $user_view);
}
function news_comment_record($News)
{
if (verif_connect(true)) {
if (verifier_token(600, get_link('Comments', 'Public'), 'Comment-' . $News['News_ID'])) {
if (request_confirm('End_Add')) {
if (request_confirm('Comment_Message')) {
insert_db('Caranille_Comments', addslashes_r($_POST));
}
}
}
}
}
function register_request()
{
global $prefixe_salt, $suffixe_salt;
extract(addslashes_r(stripslashes_r($_POST)));
$Date = date('Y-m-d H:i:s');
$IP = getRealIpAddr();
$filter = uniqid();
$pswd = password_encode($prefixe_salt . $filter . $suffixe_salt, $Password);
$key = uniqid();
insert_db('Caranille_Accounts', array('Account_Pseudo' => strip_tags($Pseudo), 'Account_Password' => strip_tags($pswd), 'Account_Salt' => $filter, 'Account_Email' => $Email, 'Account_Sexe' => $Sexe, 'Account_Inscription' => $Date, 'Account_Last_IP' => $IP, 'Account_HP_Remaining' => 100, 'Account_Key' => $key, 'Account_valid' => 0, 'Account_Level' => 1, 'Account_Order' => 1, 'Account_Reason' => 'None', 'Account_Status' => "Authorized", 'Account_Access' => "Member", 'Account_Guild_ID' => 0, 'Account_HP_Bonus' => 0, 'Account_MP_Remaining' => 10, 'Account_MP_Bonus' => 0, 'Account_Strength_Bonus' => 0, 'Account_Magic_Bonus' => 0, 'Account_Agility_Bonus' => 0, 'Account_Defense_Bonus' => 0, 'Account_Experience' => 0, 'Account_Golds' => 0, 'Account_Notoriety' => 0, 'Account_Chapter' => 1, 'Account_Mission' => 1, 'Account_Step' => 2));
$user_record = get_db('request_account', $_POST);
return $user_record;
}
function PHONE_ADD_POST($person = 0, $content = 0, $receiveperson = 0, $type = 0, $url = 0, $userid = 0)
{
//判断当前可用通道
global $db;
$blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "phone_channel where id=1 and pkey='1' and (type='2' or type='3') order by id desc");
//获取账户信息
$username = $blog["username"];
$password = $blog["password"];
//获取接口信息
$connection = explode('#515158#', $blog["connection"]);
$personfor = explode(',', $person);
$receivepersonfor = explode(',', $receiveperson);
//$ef='';
for ($i = 0; $i < sizeof($personfor); $i++) {
if ($personfor[$i] != '') {
$date = get_date('y-m-d H:i:s', PHP_TIME);
$sms_add = explode('#01', $connection[2]);
$ugcode_vod = new ugcode();
$contentgdb2312 = $ugcode_vod->ugcode_vod(1, $content);
$phoneurl = $sms_add[0] . trim($username) . $sms_add[1] . trim($password) . $sms_add[2] . trim($personfor[$i]) . $sms_add[3] . trim($contentgdb2312) . $sms_add[4] . $sms_add[5];
$res = Utility::HttpRequest($phoneurl);
if ($blog["connectionid"] == '1') {
$res_sms = explode('/', $res);
if ($res_sms[0] == '000') {
$type = '1';
} else {
$type = '2';
}
} else {
$res_sms = explode('&', $res);
if ($res_sms[0] == 'result=0') {
$type = '1';
} else {
$type = '2';
}
}
//数据入库
$phone_send = array('content' => $content, 'receivephone' => $personfor[$i], 'sendperson' => $userid, 'receiveperson' => $receivepersonfor[$i], 'date' => get_date('y-m-d H:i:s', PHP_TIME), 'type' => $type, 'channelid' => $blog["id"]);
insert_db('phone_send', $phone_send);
sleep(1);
}
}
}
function get_data($num, $url)
{
$str = file_get_contents($url);
$str = trim($str);
$str = strtolower($str);
if ($str == '') {
$str = file_get_contents($url);
}
if ($str == '') {
// recode error
$fp = fopen('cantdown_' . $num, 'a+');
fputs($fp, $num . '\\r\\n');
fclose($fp);
} else {
$data = parse_html($str);
if (insert_db($num, $data)) {
echo $num . "is ok \r\n";
}
}
}
$wheresql .= " and uid='" . $vuidtype . "'";
}
}
$num = $db->result("SELECT COUNT(*) AS num FROM " . DB_TABLEPRE . "sms_send WHERE 1 {$wheresql} ");
$sql = "SELECT * FROM " . DB_TABLEPRE . "sms_send WHERE 1 {$wheresql} ORDER BY id desc LIMIT {$offset}, {$pagesize}";
$result = $db->fetch_all($sql);
include_once 'template/index.php';
} elseif ($do == 'update') {
get_key("office_info_delete");
$idarr = getGP('id', 'P', 'array');
foreach ($idarr as $id) {
$db->query("DELETE FROM " . DB_TABLEPRE . "sms_send WHERE id = '{$id}' ");
//db->query("DELETE FROM ".DB_TABLEPRE."user_view WHERE uid = '$id'");
if ($id != '') {
$oalog = array('uid' => $_USER->id, 'content' => '删除内部短信', 'title' => '删除内部短信', 'startdate' => get_date('Y-m-d H:i:s', PHP_TIME), 'contentid' => $id, 'type' => '4');
insert_db('oalog', $oalog);
}
}
show_msg('短消息删除成功！', 'admin.php?ac=index&fileurl=sms&userkeytype=' . getGP('userkeytype', 'P') . '');
} elseif ($do == 'excel') {
$datename = "sms_" . get_date('YmdHis', PHP_TIME);
$outputFileName = 'data/excel/' . $datename . '.xls';
$content = array();
$archive = array("接收人", "发送人", "发送时间", "内容");
$content[] = $archive;
$wheresql = '';
$vuidtype = getGP('vuidtype', 'P');
if (!is_superadmin() && $vuidtype == '') {
$wheresql .= " AND uid ='" . $_USER->id . "'";
}
if ($vuidtype != '') {
copy($tempfile, $newfile);
$imgfold = $thispath . "/img";
mkdir($imgfold, 0777);
/*$test = "company/test";
$newtest = $tempMain."/test";
full_copy($test,$newtest);*/
}
//-------------------------- Check Interface Data
$sql_chk_interface = "select count(interfaceId) as totaldata from garageinterface where garageId = '" . $u_garage . "'";
$rs_chk_interface = mysql_query($sql_chk_interface);
$data_chk_interface = mysql_fetch_object($rs_chk_interface);
$chk_rowdata = $data_chk_interface->totaldata;
if ($chk_rowdata == 0) {
$Table_Name = 'garageinterface';
$data = array('interfaceLogo' => 'logo.png', 'interfaceBanner' => 'banner.jpg', 'interfaceFacebook' => 'https://www.facebook.com/', 'interfaceTwitter' => 'https://twitter.com/', 'interfaceGoogle' => 'https://plus.google.com/', 'garageId' => $u_garage);
$sql = insert_db($Table_Name, $data);
mysql_query($sql);
}
//-------------------------- Call Interface Data
$sql_interface = "select * from garageinterface where garageId = '" . $u_garage . "'";
$rs_interface = mysql_query($sql_interface);
$data_interface = mysql_fetch_object($rs_interface);
$interfaceLogo = $data_interface->interfaceLogo;
$interfaceBanner = $data_interface->interfaceBanner;
$interfaceFacebook = $data_interface->interfaceFacebook;
$interfaceTwitter = $data_interface->interfaceTwitter;
$interfaceGoogle = $data_interface->interfaceGoogle;
$garageAbout = $data_interface->garageAbout;
//-------------------------- Check Logo
$chk_logo = 0;
$pathLogo = $upload_dir . $interfaceLogo;
}
if (getGP('tpladmin', 'P') != '') {
$tpladmin = getGP('tpladmin', 'P');
} else {
$tpladmin = '0';
}
$uid = $_USER->id;
if (getGP('tpladdr', 'P') != '') {
$tpladdr = getGP('tpladdr', 'P');
} else {
$tpladdr = Pinyin($title) . '.php';
}
//主表信息
$workclass_template = array('title' => $title, 'typeid' => $typeid, 'tplkey' => $tplkey, 'tpltype' => $tpltype, 'tpluser' => $tpluser, 'tpladmin' => $tpladmin, 'uid' => $uid, 'tpladdr' => $tpladdr);
//写入主表信息
insert_db('workclass_template', $workclass_template);
$id = $db->insert_id();
$content = serialize($workclass_template);
$title = '添加工作流模型';
get_logadd($id, $content, $title, 35, $_USER->id);
show_msg('工作流模型添加成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} elseif ($do == 'edit') {
$tplid = getGP('tplid', 'G', 'int');
$blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "workclass_template WHERE tplid = '{$tplid}'");
include_once 'mana/template_edit.php';
} elseif ($do == 'editsave') {
$tplid = getGP('tplid', 'P', 'int');
$title = getGP('title', 'P');
$typeid = getGP('typeid', 'P');
$tplkey = getGP('tplkey', 'P');
if (getGP('tpluser', 'P') != '') {
/*
[Office 515158] (C) 2009-2012 天生创想 Inc.
$Id: user_count.php 1209087 2012-01-08 08:58:28Z baiwei.jiang $
*/
define('IN_ADMIN', True);
require_once '../include/common.php';
get_login($_USER->id);
//更新在线数据到数据库中
$blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "online where uid='" . $_USER->id . "' ");
if ($blog["uid"] != '') {
$online = array('startdate' => get_date('Y-m-d H:i:s', PHP_TIME), 'enddate' => get_date('Y-m-d H:i:s', PHP_TIME + 600));
update_db('online', $online, array('uid' => $_USER->id));
} else {
$online = array('uid' => $_USER->id, 'startdate' => get_date('Y-m-d H:i:s', PHP_TIME), 'enddate' => get_date('Y-m-d H:i:s', PHP_TIME + 600));
insert_db('online', $online);
}
//更新在线状态
global $db;
$query = $db->query("SELECT * FROM " . DB_TABLEPRE . "online order by id desc");
while ($row = $db->fetch_array($query)) {
$uid = $row['uid'];
if ($row["enddate"] >= get_date('Y-m-d H:i:s', PHP_TIME)) {
$user = array('online' => 1);
update_db('user', $user, array('id' => $uid));
} else {
$user = array('online' => 0);
update_db('user', $user, array('id' => $uid));
}
}
//更新数据后取出当前总在线人数
$content = '';
$content = serialize($registration);
$title = '编辑考勤信息';
get_logadd($id, $content, $title, 7, $_USER->id);
} else {
$name = check_str(getGP('user', 'P'));
$uid = check_str(getGP('userid', 'P'));
$startdate = getGP('startdate', 'P') . " " . getGP('starth', 'P') . ":" . getGP('starti', 'P') . ":00";
$enddate = getGP('enddate', 'P') . " " . getGP('endh', 'P') . ":" . getGP('endi', 'P') . ":00";
$startnote = check_str(getGP('startnote', 'P'));
$endnote = check_str(getGP('endnote', 'P'));
$date = check_str(getGP('date', 'P'));
$startyype = check_str(getGP('startyype', 'P'));
$endtype = check_str(getGP('endtype', 'P'));
$registration = array('name' => $name, 'startdate' => $startdate, 'enddate' => $enddate, 'startnote' => $startnote, 'endnote' => $endnote, 'uid' => $uid, 'startyype' => $startyype, 'endtype' => $endtype, 'date' => $date);
insert_db('registration', $registration);
$id = $db->insert_id();
$content = serialize($registration);
$title = '录入考勤信息';
get_logadd($id, $content, $title, 7, $_USER->id);
}
show_msg('考勤信息操作成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} else {
$id = getGP('id', 'G', 'int');
if ($id != '') {
$user = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "registration WHERE id = '{$id}' ");
$startdate = explode(' ', $user['startdate']);
$starttime = explode(':', $startdate[1]);
$enddate = explode(' ', $user['enddate']);
$endtime = explode(':', $enddate[1]);
$_title['name'] = '更改';
foreach (getGP('newinherited', 'P', 'array') as $name) {
$newinherited .= $name . ',';
}
$newname = explode(',', substr($newname, 0, -1));
$newinherited = explode(',', substr($newinherited, 0, -1));
if ($newname != '') {
for ($i = 0; $i < sizeof($newname); $i++) {
if ($newname[$i] != '') {
if ($newname[$i] == '') {
$newname[$i] = '新文件夹名称';
}
if ($newinherited[$i] != '') {
$fatherid = $newinherited[$i];
} else {
$fatherid = '0';
}
$document_type = array('title' => $newname[$i], 'father' => $fatherid, 'date' => $date, 'type' => $_GET['type'], 'uid' => $_USER->id);
insert_db('document_type', $document_type);
}
}
}
$str = ',新增了<font color=red>' . sizeof($newname) . '</font>条信息';
}
show_msg('批量文件夹信息更新成功' . $str . '！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=documenttype&type=' . $_GET['type'] . '');
} elseif ($_GET['view'] == 'typeupdate') {
$db->query("DELETE FROM " . DB_TABLEPRE . "document_type WHERE id = '" . $_GET[id] . "' ");
$db->query("UPDATE " . DB_TABLEPRE . "document_type set father='" . $_GET['fid'] . "' WHERE father = '" . $_GET[id] . "' ");
show_msg('文件夹信息删除成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=documenttype&type=' . $_GET['type'] . '');
}
include_once 'template/documenttype.php';
}
$office_type = array('oname' => $name[$id]);
update_db('office_type', $office_type, array('oid' => $id));
}
$newname = '515158';
foreach (getGP('newname', 'P', 'array') as $name) {
$newname .= ',,' . $name;
}
$newname = explode(',,', str_replace('515158,,', '', $newname));
if ($newname != '') {
for ($i = 0; $i < sizeof($newname); $i++) {
if (str_replace('515158', '', $newname[$i]) != '') {
if (str_replace('515158', '', $newname[$i]) == '') {
$newname[$i] = '新' . $_cname['name'];
}
$office_type = array('oname' => str_replace('515158', '', $newname[$i]), 'otype' => $otype, 'uid' => $_USER->id);
insert_db('office_type', $office_type);
}
}
}
show_msg($_cname['name'] . '信息操作成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=bbsclass&otype=' . $otype);
} elseif (getGP('id', 'G') != '') {
$db->query("DELETE FROM " . DB_TABLEPRE . "office_type WHERE oid = '" . getGP('id', 'G') . "' ");
/*$content=getGP('id','G').get_log(1).$_USER->id;
$title='删除'.$_cname['name'];
get_logadd(getGP('id','G'),$content,$title,30,$_USER->id);*/
//都写了日志，唯这个还没有写
show_msg($_cname['name'] . '信息删除成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=bbsclass&otype=' . $otype);
} else {
$sql = "SELECT * FROM " . DB_TABLEPRE . "office_type where otype='" . $otype . "' ORDER BY oid asc";
$result = $db->fetch_all($sql);
include_once 'template/officeclass.php';
$Agility = 10;
$Defense = 10;
do {
update_db('Caranille_Levels', array('Level_ID' => $Level, 'Level_Number' => $Level, 'Level_Experience_Required' => $Experience, 'Level_HP' => $HP, 'Level_MP' => $MP, 'Level_Strength' => $Strength, 'Level_Magic' => $Magic, 'Level_Agility' => $Agility, 'Level_Defense' => $Defense));
$HP += $_POST['HP_Level'];
$MP += $_POST['MP_Level'];
$Strength += $_POST['Strength_Level'];
$Magic += $_POST['Magic_Level'];
$Agility += $_POST['Agility_Level'];
$Defense += $_POST['Defense_Level'];
$Experience += $_POST['Experience_Level'];
$Level++;
} while ($Level <= $max['Level_Number']);
update_db('Caranille_Configuration', array('Configuration_Name' => 'curve-Experience', 'Configuration_Value' => $_POST['Experience_Level']));
foreach ($array_character_type as $type) {
update_db('Caranille_Configuration', array('Configuration_Name' => 'curve-' . $type, 'Configuration_Value' => $_POST[$type . '_Level']));
}
}
if (request_confirm('Delete')) {
delete_db('Caranille_Levels', $_POST);
$message = 'Le niveau a bien été supprimée';
}
if (request_confirm('End_Add')) {
if (valid_post_db('Caranille_Levels')) {
insert_db('Caranille_Levels', addslashes_r($_POST));
$message = 'niveau ajouté';
} else {
$message = 'Tous les champs n\'ont pas été remplis';
}
}
}
<?php
if (verif_connect()) {
load_css('guild.css', 'guild');
if (has_guild()) {
if (has_guild_acces('recrutement')) {
if (request_confirm('guild-engage') || request_confirm('guild-refuse')) {
if (verifier_token(60, get_link('Recrutement', 'Guild'), 'guild-candidat-' . $_POST['Account_ID'])) {
$Account_Query = get_db("candidat_guild_confirm", array('Guild_ID' => guild_data('Guild_ID'), 'Account_ID' => request_post('Account_ID')));
if (!empty($Account_Query)) {
if (request_confirm('guild-engage')) {
update_db('Caranille_Accounts', stripslashes_r($_POST));
$message = "Vous avez été accepté dans la guilde " . guild_data('Guild_Name') . ".";
} else {
update_db('Caranille_Accounts', array('Account_ID' => $Account_Query['Account_ID'], 'Account_Guild_ID' => 0, 'Account_Guild_Accept' => 0));
$message = "Votre candidature dans la guilde " . guild_data('Guild_Name') . " a été refusé.";
}
add_diary($message, $Account_Query['Account_ID']);
insert_db('Caranille_Private_Messages', array('Private_Message_Transmitter' => logged_data('Account_ID'), 'Private_Message_Receiver' => $Account_Query['Account_Pseudo'], 'Private_Message_Subject' => "Votre candidature dans la guilde " . guild_data('Guild_Name'), 'Private_Message_Message' => $message, 'Private_Message_Conversation' => null));
}
}
}
}
}
}
$startdate = getGP('startdate', 'P');
$enddate = getGP('enddate', 'P');
$price = getGP('price', 'P');
$examination = check_str(getGP('examination', 'P'));
$department = check_str(getGP('department', 'P'));
$user = getGP('user', 'P');
$organizationinfo = check_str(getGP('organizationinfo', 'P'));
$contactperson = check_str(getGP('contactperson', 'P'));
$request = check_str(getGP('request', 'P'));
$appendix = getGP('appendix', 'P');
$content = getGP('content', 'P');
$uid = $_USER->id;
$date = get_date('Y-m-d H:i:s', PHP_TIME);
$training = array('number' => $number, 'name' => $name, 'channel' => $channel, 'trform' => $trform, 'sponsor' => $sponsor, 'responsible' => $responsible, 'participation' => $participation, 'address' => $address, 'organization' => $organization, 'orgperson' => $orgperson, 'curriculum' => $curriculum, 'classhour' => $classhour, 'startdate' => $startdate, 'enddate' => $enddate, 'price' => $price, 'examination' => $examination, 'department' => $department, 'user' => $user, 'organizationinfo' => $organizationinfo, 'contactperson' => $contactperson, 'request' => $request, 'appendix' => $appendix, 'content' => $content, 'uid' => $uid, 'type' => 1, 'date' => $date);
//写入主表信息
insert_db('training', $training);
$id = $db->insert_id();
$content = serialize($training);
$title = '添加培训计划';
get_logadd($id, $content, $title, 28, $_USER->id);
}
show_msg('培训计划信息操作成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} else {
$id = getGP('id', 'G', 'int');
if ($id != '') {
$user = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "training WHERE id = '{$id}' ");
get_key("training_");
$_title['name'] = '编辑';
} else {
get_key("training_");
$user['number'] = get_date('YmdHis', PHP_TIME);
(!defined('IN_TOA') || !defined('IN_ADMIN')) && exit('Access Denied!');
get_key("office_communication_Increase");
empty($do) && ($do = 'list');
if ($do == 'list') {
include_once 'template/add.php';
} elseif ($do == 'save') {
$savetype = getGP('savetype', 'P');
$company = getGP('company', 'P');
$person = getGP('person', 'P');
$tel = getGP('tel', 'P');
$phone = getGP('phone', 'P');
$fax = getGP('fax', 'P');
$mail = getGP('mail', 'P');
$zipcode = getGP('zipcode', 'P');
$address = getGP('address', 'P');
$position = getGP('position', 'P');
$sex = getGP('sex', 'P');
$msn = getGP('msn', 'P');
$date = get_date('Y-m-d h:i:s', PHP_TIME);
$type = getGP('type', 'P');
$uid = $_USER->id;
//主表信息
$communication = array('company' => $company, 'person' => $person, 'tel' => $tel, 'phone' => $phone, 'fax' => $fax, 'mail' => $mail, 'zipcode' => $zipcode, 'address' => $address, 'position' => $position, 'sex' => $sex, 'msn' => $msn, 'type' => $type, 'date' => $date, 'uid' => $uid);
//写入主表信息
insert_db('communication', $communication);
$id = $db->insert_id();
$content = serialize($communication);
$title = '添加通迅录';
get_logadd($id, $content, $title, 9, $_USER->id);
show_msg('添加通迅录成功！', 'admin.php?ac=index&fileurl=communication&type=' . $type . '');
}
$query = $db->query("SELECT * FROM " . DB_TABLEPRE . "crm_form where type1='crm_care' ORDER BY inputnumber Asc");
while ($row = $db->fetch_array($query)) {
if ($row['inputtype'] == '4') {
$inputvalues = '';
$inputvalue = getGP('' . $row["inputname"] . '', 'P', 'array');
foreach ($inputvalue as $arrsave) {
$inputvalues .= $arrsave . ',';
}
$inputvalue = substr($inputvalues, 0, -1);
} elseif ($row['inputtype'] == '2') {
$inputvalue = trim(getGP('' . $row["inputname"] . '', 'P'));
} else {
$inputvalue = check_str(getGP('' . $row["inputname"] . '', 'P'));
}
$crm_db = array('inputname' => $row["inputname"], 'content' => $inputvalue, 'viewid' => $vid, 'formid' => $row["fid"], 'type' => 'crm_care');
insert_db('crm_db', $crm_db);
$crm_log .= serialize($crm_db) . '|515158.com|';
}
$content = serialize($crm_care);
$title = get_realname($_USER->id) . '于' . get_date('Y-m-d H:i:s', PHP_TIME) . '新建客户关怀信息';
get_logadd($vid, $content, $title, 36, $_USER->id);
crm_log($title, $vid, $content, substr($crm_log, 0, -12), 1, 'crm_care');
show_msg('新建客户关怀信息成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&type=' . $type);
} else {
if ($_GET['type'] == '2') {
get_key("crm_care_add_2");
} else {
get_key("crm_care_add_1");
}
include_once 'company/care_add.php';
}
if ($do == 'list') {
include_once 'template/add.php';
} elseif ($do == 'save') {
$savetype = getGP('savetype', 'P');
$goods_type = getGP('goods_type', 'P');
$title = getGP('title', 'P');
$specification = getGP('specification', 'P');
$unit = getGP('unit', 'P');
$price = getGP('price', 'P');
$number = getGP('number', 'P');
$content = getGP('content', 'P');
//$purchase=getGP('purchase','P');
//$examination=getGP('examination','P');
//$warehousing=getGP('warehousing','P');
$office_goods = array('goods_type' => $goods_type, 'title' => $title, 'specification' => $specification, 'unit' => $unit, 'price' => $price, 'number' => $number, 'content' => $content, 'date' => get_date('Y-m-d H:i:s', PHP_TIME), 'uid' => $_USER->id);
insert_db('office_goods', $office_goods);
$id = $db->insert_id();
$content = serialize($office_goods);
$title = '新增办公用品信息';
get_logadd($id, $content, $title, 23, $_USER->id);
show_msg('您要处理的信息操作成功！', 'admin.php?ac=index&fileurl=' . $fileurl . '');
}
//读取部门
function GET_FILE_PUBLIC_LIST($fatherid = 0, $selid = 0, $layer = 0)
{
$str = "";
global $db;
$query = $db->query("SELECT * FROM " . DB_TABLEPRE . "goods_type where father='{$fatherid}' ORDER BY id Asc ");
if (count($query) > 0) {
for ($i = 0; $i < $layer; $i++) {
$str .= "├";
}
include_once 'template/planadd.php';
}
} elseif ($do == 'views') {
$id = getGP('id', 'G', 'int');
if ($_POST['view'] != '') {
$bbsid = getGP('bbsid', 'P');
$title = check_str(getGP('title', 'P'));
$author = getGP('author', 'P');
$content = getGP('content', 'P');
$type = getGP('type', 'P');
$enddate = get_date('Y-m-d H:i:s', PHP_TIME);
$uid = $_USER->id;
//主表信息
$bbs_log = array('bbsid' => $bbsid, 'title' => $title, 'author' => $author, 'content' => $content, 'enddate' => $enddate, 'type' => 10, 'uid' => $uid);
insert_db('bbs_log', $bbs_log);
$content = serialize($bbs_log);
$title = '回复信息';
get_logadd($id, $content, $title, 12, $_USER->id);
show_msg('评论发布成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&do=views&id=' . $bbsid);
} else {
if ($id != '') {
$plan = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "plan WHERE id = '{$id}' ");
$_title['name'] = '信息浏览';
}
}
include_once 'template/planviews.php';
} elseif ($do == 'excel') {
$datename = "plan_" . get_date('YmdHis', PHP_TIME);
$outputFileName = 'data/excel/' . $datename . '.xls';
$content = array();
$arr_bank_holidays[] = mktime(0, 0, 0, 11, 11, $year);
// Armistice 1918
$arr_bank_holidays[] = mktime(0, 0, 0, 12, 25, $year);
// Noel
// Récupération de paques. Permet ensuite d'obtenir le jour de l'ascension et celui de la pentecote
$easter = self::easter_date($year);
$arr_bank_holidays[] = $easter + 86400;
// Paques
$arr_bank_holidays[] = $easter + 86400 * 39;
// Ascension
$arr_bank_holidays[] = $easter + 86400 * 50;
// Pentecote
return $arr_bank_holidays;
}
if (request_confirm('End_Add_Event')) {
insert_db('Caranille_Events', $_POST);
}
if (request_confirm('End_Edit_Event')) {
update_db('Caranille_Events', $_POST);
}
$month = request_confirm('m') ? str_pad(request_get('m'), 2, "0", STR_PAD_LEFT) : date('m');
$year = request_confirm('y') ? str_pad(request_get('y'), 4, "0", STR_PAD_LEFT) : date('Y');
debug_log("period({$year},{$month})");
$calendar = get_months($year, $month);
foreach ($calendar as $day => $week) {
$events[$day] = get_db('request_event', array('date' => "{$year}-{$month}-{$day}%", 'guild' => guild_data('Guild_ID')));
}
/**
$list_events = list_db('list_event',array(
'date' => "$year-$month%",
'guild' => guild_data('Guild_ID')
}
preg_match('/<i>注意事项.*?>(.*?)<\\/p/', $str, $match_arr['precautions']);
//注意事项
if (empty($match_arr['precautions'][1])) {
$match_arr['precautions'][1] = '';
echo "don't get 'precautions' data\n";
}
preg_match('/<i>禁忌人群.*?>(.*?)<\\/p/', $str, $match_arr['taboo_crowd']);
//禁忌人群
if (empty($match_arr['taboo_crowd'][1])) {
$match_arr['taboo_crowd'][1] = '';
echo "don't get 'taboo_crowd' data\n";
}
$data = array('skuId' => $match_arr['skuId'][1], 'name' => $match_arr['name'][1], 'adword' => $good['tip'], 'jdPrice' => $good['price'], 'martPrice' => $match_arr['martPrice'][1], 'good' => $match_arr['good'][1], 'good_num' => $match_arr['good_num'][1], 'url' => $good['url'], 'category_1' => $v['category_1'], 'category_2' => $v['category_2'], 'category_3' => $v['category_3'], 'brand_name' => $match_arr['brand_name'][1], 'manufacturer' => $match_arr['manufacturer'][1], 'specification' => $match_arr['specification'][1], 'methods_of_food' => $match_arr['methods_of_food'][1], 'ingredients' => $match_arr['ingredients'][1], 'main_ingredient' => $match_arr['main_ingredient'][1], 'valid' => $match_arr['valid'][1], 'storage' => $match_arr['storage'][1], 'precautions' => $match_arr['precautions'][1], 'taboo_crowd' => $match_arr['taboo_crowd'][1]);
//插入数据库
insert_db($data);
die;
}
} while (!empty($url));
}
/**
* 插入数据库
* @param [type] $data [description]
* @return [type] $inser_num [返回成功插入的数量]
*/
function insert_db($data)
{
$con = new mysqli("localhost", "root", "", "collection");
if (!$con) {
die('连接数据库失败:' . $con->error() . "\n\n");
}
if ($name[$id] != '') {
$wage_basis = array('username' => $username[$id], 'name' => $name[$id], 'content' => $content[$id]);
update_db('wage_basis', $wage_basis, array('bid' => $id));
}
//$sqlu = "SELECT tid,name FROM ".DB_TABLEPRE."wage_type order by tnumber asc";
//$results = $db->query($sqlu);
//while ($type = $db->fetch_array($results)) {
foreach ($_CACHE['wage_type'] as $type) {
$contentdb = getGP('type_' . $type['tid'], 'P', 'array');
$wdb = $db->fetch_one_array("SELECT did FROM " . DB_TABLEPRE . "wage_data WHERE type=1 and viewid='" . $id . "' and tid='" . $type['tid'] . "'");
if ($wdb['did'] != '') {
$wage_data = array('content' => $contentdb[$id]);
update_db('wage_data', $wage_data, array('viewid' => $id, 'tid' => $type['tid'], 'type' => 1));
} else {
$wage_data = array('viewid' => $id, 'tid' => $type['tid'], 'name' => $type['name'], 'content' => $contentdb[$id], 'type' => 1);
insert_db('wage_data', $wage_data);
}
}
}
show_msg('薪资基础信息操作成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} elseif (getGP('id', 'G') != '') {
$db->query("DELETE FROM " . DB_TABLEPRE . "wage_type WHERE tid = '" . getGP('id', 'G') . "' ");
$content = getGP('id', 'G');
$title = '删除薪资项目';
get_logadd(getGP('id', 'G'), $content, $title, 36, $_USER->id);
show_msg('薪资项目删除成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} else {
$sql = "SELECT a.*,b.name FROM " . DB_TABLEPRE . "user a," . DB_TABLEPRE . "user_view b where a.ischeck!=0 and a.id!=1 and a.id=b.uid ORDER BY a.numbers asc";
$result = $db->fetch_all($sql);
include_once 'template/basis.php';
}
public function ads_add($title = 0, $adsurl = 0, $cid = 0, $color = 0)
{
$ads = array('title' => $title, 'adsurl' => $adsurl, 'cid' => $cid, 'color' => $color, 'date' => get_date('Y-m-d H:i:s', PHP_TIME));
insert_db('ads', $ads);
return;
}
$canback = $row9['id'];
} else {
$canback = '0';
}
} else {
if ($canback != '0' && strpos('1' . $row9['name'], get_realname($_USER->id)) >= 1) {
$db->query("update " . DB_TABLEPRE . "personnel set fileid='被回退：" . $_POST['id'] . "',lnstructions='" . $row9['lnstructions'] . "<br><font color=red>此操作在" . $s4 . "被" . get_realname($_USER->id) . "回退，理由：" . $_POST['ly'] . "</font>' WHERE id =" . $canback . " or id=" . $row9['id']);
////////////////////////////////
$personnel2 = array('type' => $row9['type'], 'name' => $row9['name'], 'uid' => $row9['uid'], 'node' => $row9['node'], 'pkey' => 0, 'fileid' => $row9['fileid'], 'apptype' => $row9['apptype'], 'appflow' => $row9['appflow'], 'appkey' => $row9['appkey'], 'appkey1' => $row9['appkey1']);
insert_db('personnel', $personnel2);
if ($row9['appkey'] == '1') {
$staff = explode(',', $row9['name']);
$staffid = explode(',', $row9['uid']);
for ($i = 0; $i < sizeof($staffid); $i++) {
$personnel_log = array('type' => 2, 'name' => $staff[$i], 'uid' => $staffid[$i], 'pkey' => 0, 'perid' => $row9['id']);
insert_db('personnel_log', $personnel_log);
}
}
//$db->query('UPDATE personnel SET oapostscript ="流程被回退，理由：".$_POST['ly'] where id=');
/////////////////////////////
if ($_POST['type'] == '1') {
show_msg('操作成功，当前步骤已被撤销！', 'admin.php?ac=attachment&fileurl=app&type=5');
} else {
show_msg('操作成功，当前步骤已被撤销！', 'admin.php?ac=approval&fileurl=app&type=5');
}
} else {
echo '在您提交回退操作前，该公文状态已发生变化，且当前状态无法进行回退操作！';
}
}
}
} else {
function config_race()
{
insert_db('Caranille_Races', array('Race_Name' => 'Néphilims', 'Race_Description' => 'croisement maudits des anges et des démons'));
insert_db('Caranille_Races', array('Race_Name' => 'Humains', 'Race_Description' => 'Rejetés du ciel et de l\'enfer, la terre est devenu leur royaume souverain'));
}
<?php
(!defined('IN_TOA') || !defined('IN_ADMIN')) && exit('Access Denied!');
get_key("file_Increase");
empty($do) && ($do = 'list');
if ($do == 'list') {
include_once 'template/add.php';
} elseif ($do == 'save') {
$savetype = getGP('savetype', 'P');
$filetype = getGP('filetype', 'P');
$filenumber = getGP('filenumber', 'P');
$filename = getGP('filename', 'P');
$enddate = getGP('enddate', 'P');
$position = getGP('position', 'P');
$page = getGP('page', 'P');
$appendix = getGP('file1', 'P') . "," . getGP('file2', 'P') . "," . getGP('file3', 'P');
$content = getGP('content', 'P');
$file = array('filetype' => $filetype, 'filenumber' => $filenumber, 'filename' => $filename, 'enddate' => $enddate, 'position' => $position, 'page' => $page, 'appendix' => $appendix, 'content' => $content, 'type' => '0', 'date' => get_date('Y-m-d H:i:s', PHP_TIME), 'uid' => $_USER->id);
insert_db('file', $file);
$id = $db->insert_id();
$content = serialize($file);
$title = '新增档案信息';
get_logadd($id, $content, $title, 20, $_USER->id);
show_msg('新增档案信息成功！', 'admin.php?ac=index&fileurl=file');
}
$newname = substr($newname, 0, -1);
$newpersno = substr($newpersno, 0, -1);
$newinherited = substr($newinherited, 0, -1);
$newname = explode(',', $newname);
$newpersno = explode(',', $newpersno);
$newinherited = explode(',', $newinherited);
if ($newname != '') {
for ($i = 0; $i < sizeof($newname); $i++) {
if ($newname[$i] != '') {
if ($newinherited[$i] != '') {
$fatherid = trim($newinherited[$i]);
} else {
$fatherid = '0';
}
$department = array('name' => $newname[$i], 'persno' => $newpersno[$i], 'father' => $fatherid, 'date' => $date);
insert_db('department', $department);
}
}
}
$str = ',新增了<font color=red>' . sizeof($newname) . '</font>条信息';
}
$content = serialize($idarr) . serialize($persno) . serialize($name);
$title = '部门信息';
get_logadd($id, $content, $title, 18, $_USER->id);
oa_mana_recache('department', 'id', 'id');
show_msg('批量部门信息更新成功' . $str . '！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} elseif ($_GET['do'] == 'update') {
$db->query("DELETE FROM " . DB_TABLEPRE . "department WHERE id = '" . $_GET[id] . "' ");
$db->query("UPDATE " . DB_TABLEPRE . "department set father='" . $_GET['fid'] . "' WHERE father = '" . $_GET[id] . "' ");
oa_mana_recache('department', 'id', 'id');
show_msg('部门信息删除成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
//处理编码问题
$utf8_json = characet($json);
//json解析为数组
$arr = json_decode($utf8_json, true);
//获取页码
$page = $arr['page']['currentPage'];
//获取总页码
$totalPage = $arr['page']['totalPage'];
//获取商品列表
$lists = $arr['itemList'];
//计算总共商品数
$count = count($lists);
//向终端输出信息
echo "获取....第" . $page . "页,共" . $count . "条信息\n";
//开始插入数据库
$insert_num = insert_db($lists);
//向终端输出信息
echo "\n";
echo "成功" . $insert_num . "条 失败" . ($count - $insert_num) . "条\n\n";
$page++;
} while ($page <= $totalPage);
/**
* 插入数据库
* @param [type] $data [description]
* @return [type] $inser_num [返回成功插入的数量]
*/
function insert_db($data)
{
echo "开始写入数据库\n";
$insert_num = 0;
//成功插入的数量
}
$content = serialize($idarr);
$title = '删除项目类别';
get_logadd($id, $content, $title, 32, $_USER->id);
show_msg('项目类别删除成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} elseif ($do == 'add') {
include_once 'mana/type_add.php';
} elseif ($do == 'addsave') {
$project_type[title] = getGP('title', 'P');
$project_type[manauser] = getGP('manauser', 'P');
$project_type[keyuser] = getGP('keyuser', 'P');
$project_type[type1] = getGP('type1', 'P');
$project_type[type2] = '1';
$project_type[uid] = $_USER->id;
//写入主表信息
insert_db('project_type', $project_type);
$id = $db->insert_id();
$content = serialize($project_type);
$title = '添加项目类别';
get_logadd($id, $content, $title, 32, $_USER->id);
show_msg('项目类别添加成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} elseif ($do == 'edit') {
$tid = getGP('tid', 'G', 'int');
$view = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "project_type WHERE tid = '{$tid}'");
include_once 'mana/type_edit.php';
} elseif ($do == 'editsave') {
$project_type[title] = getGP('title', 'P');
$project_type[manauser] = getGP('manauser', 'P');
$project_type[keyuser] = getGP('keyuser', 'P');
$project_type[type1] = getGP('type1', 'P');
update_db('project_type', $project_type, array('tid' => getGP('tid', 'P')));
