示例#1
0
<?php

$aql = "sky_sql_log\t{\n\t\t\t\t\t\t\tcodebase,\n\t\t\t\t\t\t\tsql\n\t\t\t\t\t\t}";
$param = array('aql' => $aql, 'cols' => array('codebase', 'sql'));
aql::grid($param);
示例#2
0
<?php

$title = "Blog Listing";
template::inc('intranet', 'top');
?>
<div class = "has-floats">
	<div class = "float-right blog_listing">
		<div class = "content_listing">
			<input type = "button" onclick = "window.location = '/admin/blog/blogs/add-new'" value = "Add new blog"/>
<?php 
$cols = "\t\n\t\t\tname\t\t{label:\tName\t\t;}\n\t\t\tdescription\t{label:\tDescription\t;}\n                        slug            {label: Slug \t\t;}\n                        status\t\t{label: Status\t\t;}\n\t\t";
if (auth('blog_author:editor')) {
    $cols .= 'edit {}';
}
$clause = array('blog_website' => array('where' => 'blog_website.website_id=' . $website_id));
$param = array('enable_sort' => true);
$params = array("aql" => 'blog', 'clause' => $clause, "cols" => $cols, "param" => $param);
aql::grid($params);
?>
		</div>
	</div>
		<div class = "left_nav">
<?php 
include 'pages/admin/blog/left-nav/left-nav.php';
?>
	</div>
</div>
<?php 
template::inc('intranet', 'bottom');
示例#3
0
文件: list.php 项目: hshoghi/cms
            </select>
        </div>
        <?php 
}
?>
        
        <div class="col">
        	<?php 
$aql = "blog_category {\n\t\t\t\t\t\tname\n\t\t\t\t\t\torder by name asc\n\t\t\t\t\t}\n\t\t\t\t\tblog_website on blog_category.blog_id = blog_website.blog_id {\n\t\t\t\t\t\twhere website_id = {$website_id}\n\t\t\t\t\t}";
$dropdown = array('select_name' => 'cat_ide', 'value_field' => 'blog_category_ide', 'option_field' => 'name', 'selected_value' => $_GET['cat_ide'], 'null_option' => 'All Categories', 'onchange' => 'this.form.submit();');
aql::dd($aql, $dropdown);
?>
        </div>

		<div class="clear"></div>
		
	</div>
</form>

<?php 
snippet::tabs($tabs);
?>

<div id="gridcontent">
<?php 
aql::grid($aql_blog_title, $col, $param);
?>
</div>
		 
<?php 
template::inc('intranet', 'bottom');
示例#4
0
    ?>
" />
            </div>
    
            <div class="clear"></div>
            
        </div>
    </form>
    
    <?php 
    $q = '';
    if ($_GET['q']) {
        $_GET['q'] = addslashes(trim(urldecode($_GET['q'])));
        $aql = "person {\n                    id as name,\n                    id as add_contributor,\n                    fname,\n                    lname,\n\t\t\t\t\taccess_group,\n                    email_address\n                    where ( email_address ilike '" . $_GET['q'] . "%' )\n\t\t\t\t\tand password is not null and password != ''\n                }";
        $cols = "\n            name { label: Name; }\n            email_address { label: Email; }\n\t\t\taccess_group {}\n            add_contributor {}\n        ";
        aql::grid($aql, $cols);
    }
}
if (!$blog_author['blog_author_ide']) {
    if ($_GET['debug']) {
        echo "no blog_author_ide <br />";
    }
    if (is_numeric($person_id = decrypt($_POST['sky_qs'][0], 'person'))) {
        if ($_GET['debug']) {
            echo "person_id : {$person_id} " . decrypt($_POST['sky_qs'][0], 'person') . "<br />";
        }
        $aql = "blog_author{\n         where person_id={$person_id}\n      }";
        $person_res = aql::select($aql);
        if (is_array($person_res)) {
            if ($_GET['debug']) {
                echo "found blog_author <br />";
示例#5
0
$cols = "\n\tblog_roll_name {\n\t\tlabel: Name;\n\t}\n\tblog_roll_url {\n\t\tlabel: URL;\n\t\tscript: components/blog_roll/blog_roll_url/blog_roll_url.php;\n\t}\n\tpagerank {\n\t\tlabel: PR;\n\t}\n\tmod_time {\n\t\tlabel: Date Added;\n\t}\n\tadded_by__person_id {\n\t\tlabel: Added By;\n\t}\n\tstatus {\n\t\tlabel: On Website;\n\t}\n";
if (auth('blog_author:editor;')) {
    $cols .= 'edit {}';
    $cols .= 'delete {}';
}
$where = NULL;
if ($_POST['sky_ide']) {
    $where .= " and blog_roll.blog_ide =  '{$_POST['sky_ide']}'";
}
if ($_GET['on_website'] !== NULL && is_numeric($_GET['on_website'])) {
    $where .= " and blog_roll.status = {$_GET['on_website']} ";
}
$clause = array('blog_roll' => array('where' => 'true ' . $where . $q, 'order by' => 'blog_roll.name asc'), 'blog_website' => array('where' => "website_id = '{$website_id}'"));
$model = 'blog_roll';
?>
			<div class = "clear"></div>
			<div>
<?php 
aql::grid($model, $cols, $clause);
?>
			</div>
		</div>
	</div>
		<div class = "left_nav">
<?php 
include 'pages/admin/blog/left-nav/left-nav.php';
?>
	</div>
</div>
<?php 
template::inc('intranet', 'bottom');
示例#6
0
    case 'h1':
        $title = 'h1';
        $where[] = "field = 'h1'";
        break;
    case 'h1_blurb':
        $title = 'h1_blurb';
        $where[] = "field = 'h1_blurb'";
        break;
    case 'meta_description':
        $title = 'meta_description';
        $where[] = "field = 'meta_description'";
        break;
    default:
        // tab_redirect() ensures this is never the case
        break;
}
$title = "Website Page Data";
template::inc('intranet', 'top');
?>

<?php 
snippet::tabs($tabs);
$aql = aql::get_aql('website_page_data');
$cols = "\n\t\t\tnickname {label: Nickname;}\n\t\t\tfield {label: field;}\n\t\t\tvalue {label: value;}\t\t\n\t";
$clause = array('website' => array('where' => $where, 'order by' => $order_by));
$options = array('enable_sort' => true);
?>
	
<?php 
aql::grid($aql, $cols, $clause, $options);
template::inc('intranet', 'bottom');
示例#7
0
        $where[] = "blog_article.status = 'T'";
        break;
    default:
        // tab_redirect() ensures this is never the case
        break;
}
// begin html output
template::inc('intranet', 'top');
?>
<div class="has-floats">
    <div class="float-right blog_listing">
        <div class="content_listing">
<?php 
// display the filters
include INCPATH . '/includes/listing-filter.php';
// display the tabs
snippet::tabs($tabs);
$post_time_column = IDE == 'published' ? 'post_time    { label:	Post Time; order by: blog_article.post_time;}' : 'mod_time_formatted    { label:	Edit Time; order by: blog_article.mod_time;}';
// display the grid
aql::grid(array('model' => 'blog_article', 'columns' => " title {\n                                    label: Title;\n                                    order by: title;\n                               }\n                               blog_name { \n                                    label: Blog;\n                               }\n                               fname_lname  { \n                                    label: Author;\n                                    order by: person.fname;\n                               }\n                               market_name  { label:\tMarket; }\n                               {$post_time_column}\n                               note         { label:\tNote; }\n                               edit         { label:\tEdit; }", 'where' => $where, 'order by' => 'post_time desc', 'enable_sort' => true, 'max_rows' => 50));
?>
        </div>
    </div>
    <div class="left_nav">
<?php 
include INCPATH . '/../left-nav/left-nav.php';
?>
    </div>
</div>
<?php 
template::inc('intranet', 'bottom');