function getTitle($archive,$category,$catid,$type){
if(!empty($archive['mtitle'])) {
echo $archive['mtitle'];return;
} elseif ($category[$catid][meta_title] and !$archive['title']) {
echo $category[$catid]['meta_title'];return;
} else {
if(!empty($archive['title'])) {
echo $archive['title'];return;
}
if($type['meta_title']) {
echo $type['meta_title'];return;
} elseif (typename($type['typeid'])) {
echo typename($type['typeid']);return;
}
if($category[$catid][meta_title]) {
echo $category[$catid]['meta_title'];return;
} elseif (!empty($catid)) {
echo catname($catid);return;
}
echo get('fullname');return;
}
}
function replaceParams($filename, $header)
{
global $funcs;
$orig = $file = file_get_contents($filename);
foreach ($funcs as &$func) {
$var_arg = $func['flags'] & VarArgsMask;
$args = $func['args'];
$search = '(?!return\\s)\\b\\w+\\s+f_' . $func['name'] . '\\s*\\(\\s*';
if ($var_arg) {
$search .= '\\w+\\s+\\w+';
}
if ($var_arg && count($args) > 0) {
$search .= ',\\s*';
}
for ($i = 0; $i < count($args); $i++) {
$arg = $args[$i];
$search .= '\\w+\\s+\\w+\\s*';
if (isset($arg['default'])) {
if ($header) {
$search .= '=\\s*(?:' . preg_quote($arg['default'], '/') . '|\\d+)\\s*';
} else {
$search .= '(?:\\/\\*\\s*=\\s*(?:' . preg_quote($arg['default'], '/') . '|\\d+)\\s*\\*\\/\\s*)?';
}
}
if ($i < count($args) - 1) {
$search .= ',(\\s*)';
}
}
if ($var_arg) {
if ($header) {
$search .= ',\\s*\\w+\\s+\\w+\\s*=\\s*null_array\\s*';
} else {
$search .= ',(\\s*)\\w+\\s+\\w+\\s*(?:\\/\\*\\s*=\\s*null_array\\s*\\*\\/\\s*)?';
}
}
$search .= '\\)';
$replace = typename($func['return']) . ' f_' . $func['name'] . '(';
if ($var_arg) {
$replace .= 'int _argc, ';
}
for ($i = 0; $i < count($args); $i++) {
$arg = $args[$i];
$replace .= param_typename($arg) . ' ' . $arg['name'];
if (isset($arg['default'])) {
if ($header) {
$replace .= ' = ' . addcslashes($arg['default'], '\\');
} else {
$replace .= ' /* = ' . addcslashes($arg['default'], '\\') . ' */';
}
}
if ($i < count($args) - 1) {
$replace .= ',${' . ($i + 1) . '}';
}
}
if ($var_arg) {
if ($header) {
$replace .= ', CArrRef _argv = null_array';
} else {
$replace .= ',${' . $i . '}';
$replace .= 'CArrRef _argv /* = null_array */';
}
}
$replace .= ')';
if ($header && preg_match("/inline\\s+{$search}/ms", $file)) {
$func['inlined'] = true;
}
//var_dump($search, $replace);
$count = preg_match_all("/{$search}/ms", $file, $m);
if ($count == 0) {
if ($header || !isset($func['inlined'])) {
var_dump($search, $replace);
print $func['name'] . " not found in {$filename}\n";
}
} else {
if ($count == 1) {
$file = preg_replace("/{$search}/ms", $replace, $file);
} else {
print "skipped " . $func['name'] . " in {$filename}\n";
}
}
}
if ($orig != $file) {
file_put_contents($filename, $file);
}
}
$types = retrieve($q3);
$timezone = "set timezone TO 'GMT'";
retrieve($timezone);
$q = "\n\t\t\tSELECT\n\t\t\tl.state, \n\t\t\tto_char(l.create_date::timestamp,'dd-mm-yy') as DATE,\n\t\t\tl.partner_id as PID,\n\t\t\tp.name as FIRM,\n\t\t\tl.fax as DESC,\n\t\t\tl.name as JOB,\n\t\t\tl.street as QTY,\n\t\t\tl.street2 as PRICE,\n\t\t\tl.planned_revenue as AMOUNT,\n\t\t\tl.mobile as PAPER, \n\t\t\tl.zip as COLOR,\n\t\t\tl.birthdate as AFTER,\n\t\t\tl.title_action as BILL,\n\t\t\tl.referred as ART,\n\t\t\tl.phone as TEL,\n\t\t\tl.categ_id as MACHINE,\n\t\t\tl.function as LABOR,\n\t\t\tl.create_uid as COOR,\n\t\t\tl.type_id as CODE,\n\t\t\tto_char(l.date_closed::timestamp AT TIME ZONE '+0','dd-mm-yy') as DEADLINE \n\t\t\tFROM crm_lead l, res_partner p\n\t\t\tWHERE\n\t\t\tl.partner_id = p.id \n\t\t\tAND \n\t\t\tl.partner_id = {$pid} \n\t\t\tORDER BY \n\t\t\tp.name\n\t\t\t";
echo $q;
$a = retrieve($q);
$q2 = 'SELECT id,name FROM res_users';
$users = retrieve($q2);
$q3 = 'SELECT id,name FROM crm_case_categ';
$o = [];
foreach ($a as $k => $v) {
if ($v['desc'] == null) {
$a = explode(' ', $v['job']);
$v['job'] = $a[0];
$v['desc'] = $a[1];
}
$v['coor'] = username($v['coor'], $users);
$v['machine'] = machinename($v['machine'], $machines);
$v['code'] = typename($v['code'], $types);
$partner_categ = get_categ($v['pid']);
//echo $v["pid"]."<br>";
// remove "del" job no
$categs = retrieve($q3);
if (strpos(strtolower($v['job']), 'del') !== false) {
$del[] = [$v['date'], $v['firm'], $partner_categ, $v['desc'], $v['job'], $v['qty'], $v['price'], $v['amount'], $v['paper'], $v['color'], $v['after'], $v['bill'], $v['art'], $v['machine'], $v['labor'], $v['coor'], $v['code'], $v['deadline'], $v['tel']];
} else {
$o[] = [$v['date'], $v['firm'], $partner_categ, $v['desc'], $v['job'], $v['qty'], $v['price'], $v['amount'], $v['paper'], $v['color'], $v['after'], $v['bill'], $v['art'], $v['machine'], $v['labor'], $v['coor'], $v['code'], $v['deadline'], $v['tel']];
}
}
}
print_r($o);
<script type="text/javascript">
var currentPage = <?php
echo $Page['page'];
?>
;
var currentState = <?php
echo $state;
?>
;
</script>
<div class="top_title clearfix">
<div class="top_name"><?php
if (isset($_GET["shuatype"])) {
echo typename($_GET["shuatype"]);
} else {
echo '试用任务';
}
?>
</div>
<div class="top_menu clearfix">
<ul>
<li data="0" <?php
if ($state == 0) {
echo "class=\"current\"";
}
?>
>全部</li>
<li data="1" <?php
if ($state == 1) {
