PHP oa_where_recache Examples

Example #1

File: mod_form.php Project: haogm123/ydoa

    if ($_POST['view'] != '') {
        $fid = getGP('fid', 'P', 'int');
        $formname = getGP('formname', 'P');
        $inputvalue = getGP('inputvalue', 'P');
        $type = getGP('type', 'P');
        $inputtype = getGP('inputtype', 'P');
        $inputvaluenum = getGP('inputvaluenum', 'P');
        $confirmation = getGP('confirmation', 'P');
        $type1 = getGP('type1', 'P');
        $type2 = getGP('type2', 'P');
        $w = getGP('w', 'P');
        $h = getGP('h', 'P');
        //主表信息
        $crm_form = array('formname' => $formname, 'inputvalue' => $inputvalue, 'type' => $type, 'inputtype' => $inputtype, 'inputvaluenum' => $inputvaluenum, 'confirmation' => $confirmation, 'type2' => $type2, 'w' => $w, 'h' => $h);
        update_db('crm_form', $crm_form, array('fid' => $fid));
        oa_where_recache('crm_form', 'fid', 'inputnumber', "type1='" . $type1 . "'", $type1);
        $id = $db->insert_id();
        $content = serialize($crm_form);
        $title = '编辑CRM表单';
        get_logadd($id, $content, $title, 36, $_USER->id);
        show_msg('编辑CRM表单成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '&type1=' . $type1 . '');
    } else {
        $blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "crm_form  WHERE fid = '" . $_GET['fid'] . "' ");
        include_once 'mana/form_edit.php';
    }
}
function form_mod($mod = '')
{
    switch ($mod) {
        case 'crm_company':
            return "客户信息";

Example #2

File: mod_menu.php Project: haogm123/ydoa

        foreach (getGP('newinherited', 'P', 'array') as $name) {
            $newinherited .= $name . ',';
        }
        $newname = substr($newname, 0, -1);
        $newnumber = substr($newnumber, 0, -1);
        $newmenuurl = substr($newmenuurl, 0, -1);
        $newinherited = substr($newinherited, 0, -1);
        $newname = explode(',', $newname);
        $newnumber = explode(',', $newnumber);
        $newmenuurl = explode(',', $newmenuurl);
        $newinherited = explode(',', $newinherited);
        for ($i = 0; $i < sizeof($newname); $i++) {
            if ($newname[$i] != '') {
                if ($newinherited[$i] != '') {
                    $fatherid = $newinherited[$i];
                } else {
                    $fatherid = '0';
                }
                $menu = array('menuname' => $newname[$i], 'menuurl' => $newmenuurl[$i], 'menunum' => $newnumber[$i], 'menutype' => '0', 'menukey' => '0', 'fatherid' => $fatherid);
                insert_db('menu', $menu);
            }
        }
        $str = ',新增了<font color=red>' . sizeof($newname) . '</font>条信息';
    }
    oa_mana_recache('menu', 'menuid', 'menunum');
    oa_where_recache('menu', 'menuid', 'menunum', 'menutype=2', 'home');
    show_msg('批量菜单信息更新成功' . $str . '！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
} elseif ($_GET['do'] == 'update') {
    $db->query("DELETE FROM " . DB_TABLEPRE . "menu WHERE menuid = '" . $_GET[id] . "' ");
    show_msg('菜单信息删除成功！', 'admin.php?ac=' . $ac . '&fileurl=' . $fileurl . '');
}