Example #1
0
function cahorro_off_action($xcrud)
{
    if ($xcrud->get('primary')) {
        $db = Xcrud_db::get_instance();
        $query = 'UPDATE datos_familiares SET `cahorro` = b\'0\' WHERE id_familiar = ' . (int) $xcrud->get('primary');
        $db->query($query);
    }
}
Example #2
0
function unpublish_action($xcrud)
{
    if ($xcrud->get('primary')) {
        $db = Xcrud_db::get_instance();
        $query = 'UPDATE base_fields SET `bool` = b\'0\' WHERE id = ' . (int) $xcrud->get('primary');
        $db->query($query);
    }
}
Example #3
0
function movebottom($xcrud)
{
    if ($xcrud->get('primary') !== false) {
        $primary = (int) $xcrud->get('primary');
        $db = Xcrud_db::get_instance();
        $query = 'SELECT `officeCode` FROM `offices` ORDER BY `ordering`,`officeCode`';
        $db->query($query);
        $result = $db->result();
        $count = count($result);
        $sort = array();
        foreach ($result as $key => $item) {
            if ($item['officeCode'] == $primary && $key != $count - 1) {
                unset($result[$key]);
                array_splice($result, $key + 1, 0, array($item));
                break;
            }
        }
        foreach ($result as $key => $item) {
            $query = 'UPDATE `offices` SET `ordering` = ' . $key . ' WHERE officeCode = ' . $item['officeCode'];
            $db->query($query);
        }
    }
}
Example #4
0
 protected function _clone_row()
 {
     if (is_array($this->table_info) && count($this->table_info) && !$this->table_ro) {
         $db = Xcrud_db::get_instance($this->connection);
         $fields = array();
         $row = array();
         $this->find_details_text_variables();
         if ($this->direct_select_tags) {
             foreach ($this->direct_select_tags as $key => $dsf) {
                 $fields[$key] = "`{$dsf['table']}`.`{$dsf['field']}` AS `{$key}`";
             }
         }
         if ($fields) {
             if (!$this->join) {
                 $db->query('SELECT ' . implode(',', $fields) . " FROM `{$this->table}` WHERE `{$this->primary_key}` = " . $db->escape($this->primary_val) . " LIMIT 1");
                 $row = $db->row();
             } else {
                 $tables = array('`' . $this->table . '`');
                 $joins = array();
                 foreach ($this->join as $alias => $param) {
                     $tables[] = '`' . $alias . '`';
                     $joins[] = "INNER JOIN `{$param['join_table']}` AS `{$alias}` \n                    ON `{$param['table']}`.`{$param['field']}` = `{$alias}`.`{$param['join_field']}`";
                 }
                 $db->query('SELECT ' . implode(',', $fields) . " FROM `{$this->table}` AS `{$this->table}` " . implode(' ', $joins) . " WHERE `{$this->table}`.`{$this->primary_key}` = " . $db->escape($this->primary_val));
                 $row = $db->row();
             }
         }
         if (!$this->is_duplicate($row)) {
             return self::error('Forbidden');
         }
         $columns = array();
         $this->primary_ai = false;
         foreach ($this->table_info as $table => $types) {
             foreach ($types as $row) {
                 $field_index = "{$table}.{$row['Field']}";
                 if ($row['Key'] == 'PRI' && $row['Extra'] == 'auto_increment') {
                     if ($table == $this->table) {
                         $this->primary_ai = "`{$table}`.`{$row['Field']}`";
                     }
                 } elseif ($row['Key'] == 'UNI' or $row['Key'] == 'PRI') {
                     self::error('Duplication impossible. The table has a unique field.');
                 } else {
                     $columns[$field_index] = array('table' => $table, 'field' => $row['Field']);
                 }
             }
         }
         if (!$this->primary_ai) {
             self::error('Duplication impossible. Table does not have a primary autoincrement field.');
         }
         $select = $this->_build_select_clone($columns);
         $where = $this->_build_where();
         $table_join = $this->_build_table_join();
         $where_ai = $where ? "AND {$this->primary_ai} = " . (int) $this->primary_val : "WHERE {$this->primary_ai} = " . (int) $this->primary_val;
         $db->query("SELECT {$select}\r\n FROM `{$this->table}`\r\n {$table_join}\r\n {$where}\r\n {$where_ai} LIMIT 1");
         $postdata = $db->row();
         if (isset($this->pass_var['create'])) {
             foreach ($this->pass_var['create'] as $field => $pv) {
                 $postdata[$field] = $pv['value'];
             }
         }
         if (!$this->demo_mode) {
             $this->_insert($postdata, true, $columns);
         }
     }
     $this->task = 'list';
 }
Example #5
0
function validate_weight()
{
    $db = Xcrud_db::get_instance();
    $sell_purchase_id = $postdata->get('seid');
    $sel = "SELECT * FROM stock_new WHERE purchase_id=" . $sell_purchase_id;
    $db->query($sel);
    $result = $db->result();
    $result = $result[0];
    $stock_weight = $result['weight'];
    $sell_weight = $postdata->get('weight');
    $total_weight = $stock_weight - $sell_weight;
    if ($stock_weight < $sell_weight) {
        echo "Your Remaining weight is" . $total_weight;
    } else {
        echo "Sell weight not greater then stock weight";
    }
}
Example #6
0
function update_price()
{
    //mengupdate field lpb_detail yang belum memiliki price HANYA UNTUK PR (cukup dijalankan sekali)
    Xcrud_config::$dbname = 'bcspurchase_2015';
    Xcrud_config::$dbuser = '******';
    Xcrud_config::$dbpass = '******';
    Xcrud_config::$dbhost = '10.2.2.32';
    $db = Xcrud_db::get_instance();
    $select = "select lpb_id from lpb_detail";
    $db->query($select);
    $arr = $db->result();
    $count = 0;
    //die("Arr :".$arr[0]['lpb_id']);
    foreach ($arr as $ar) {
        foreach ($ar as $a) {
            $count++;
        }
    }
    for ($x = 0; $x < $count; $x++) {
        $query = "select po_item_id from lpb_detail where lpb_id='" . $arr[$x]['lpb_id'] . "'";
        $db->query($query);
        $po_item_id = $db->row()['po_item_id'];
        //die("po item id : ".$po_item_id);
        if ($po_item_id != '') {
            $query2 = "select price from po_item  where po_item_id='{$po_item_id}'";
            $db->query($query2);
            $price = $db->row()['price'];
            //die("material id : ".$material_id);
            $query3 = "update lpb_detail set price='{$price}' where lpb_id='" . $arr[$x]['lpb_id'] . "'";
            $db->query($query3);
        }
    }
    die;
}
Example #7
0
function close_dns($xcrud)
{
    if ($xcrud->get('primary')) {
        $db = Xcrud_db::get_instance();
        $query = 'UPDATE trans_transaksi_invoices_detail_dn a
									SET a.status = "Proses Penagihan", a.total = 
															(SELECT sum(b.total) 
																	FROM trans_transaksi_dn_detail_new b 
																	WHERE b.no_surat_jalan = a.no_surat_jalan)
									WHERE a.nid = ' . (int) $xcrud->get('primary');
        $query2 = 'UPDATE trans_transaksi_dn_detail_new a
									SET a.status_surat_jalan = "Proses Penagihan"
									WHERE a.no_surat_jalan = (select b.no_surat_jalan from trans_transaksi_invoices_detail_dn b
										WHERE b.nid = ' . (int) $xcrud->get('primary') . ')';
        $db->query($query);
        $db->query($query2);
    }
}
function make_new_row_last($postdata, $primary)
{
    $db = Xcrud_db::get_instance();
    $q = 'SELECT COUNT(*) as num FROM your_table';
    $db->query($q);
    $num = $db->row()['num'];
    $q = 'UPDATE your_table SET ordering = ' . $db->quote($num) . ' WHERE id = ' . $db->quote($primary);
    $db->query($q);
}
Example #9
0
error_reporting(E_ALL);
ini_set("display_errors", 1);
include '../inc/commons.php';
include BASE_URL . 'xcrud/xcrud.php';
if (!function_exists('xcrud_get_instance')) {
    function xcrud_get_instance($name = true)
    {
        return Xcrud::get_instance($name);
    }
}
Xcrud_config::$dbname = 'shop';
Xcrud_config::$dbuser = '******';
Xcrud_config::$dbpass = '******';
Xcrud_config::$dbhost = 'localhost';
$db = Xcrud_db::get_instance('shop');
$exec = $db->query("SELECT counter from counter");
$array = $db->result();
$counter = $array[0]['counter'];
$exec = $db->query("SELECT count(*),country from visitors group by country order by count(*) desc");
$array = $db->result();
$country = $array[0]['country'];
$exec = $db->query("SELECT count(*) as items from items");
$array = $db->result();
$items = $array[0]['items'];
$exec = $db->query("SELECT count(*) as count_category from (select distinct category from items group by category) as tbl1");
$array = $db->result();
$category = $array[0]['count_category'];
$exec = $db->query("SELECT count(*) as new from (select * from items where date_created+INTERVAL 1 WEEK > NOW()) as tbl1");
$array = $db->result();
$new = $array[0]['new'];
Example #10
0
error_reporting(E_ALL);
ini_set("display_errors", 1);
include '../inc/commons.php';
include BASE_URL . 'xcrud/xcrud.php';
if (!function_exists('xcrud_get_instance')) {
    function xcrud_get_instance($name = true)
    {
        return Xcrud::get_instance($name);
    }
}
require_once "userCake/models/config.php";
if (!securePage($_SERVER['PHP_SELF'])) {
    die;
} elseif (isUserLoggedIn()) {
    $db = Xcrud_db::get_instance('fashion');
    $exec = $db->query("SELECT counter from counter");
    $res = $db->result();
    $counter = $res[0]['counter'];
    $exec = $db->query("SELECT count(*) as items from items");
    $res = $db->result();
    $items = $res[0]['items'];
    $exec = $db->query("SELECT count(*) as count_category from (select distinct category from items group by category) as tbl1");
    $res = $db->result();
    $category = $res[0]['count_category'];
    $exec = $db->query("SELECT count(*) as new from (select * from items where date_created+INTERVAL 1 WEEK > NOW()) as tbl1");
    $res = $db->result();
    $new = $res[0]['new'];
}
?>
<!DOCTYPE html>
Example #11
0
function update_sku($xcrud)
{
    $db = Xcrud_db::get_instance();
    $id = $xcrud->get('primary');
    die("id" . $id);
    $result = '';
    for ($i = 0; $i < 12; $i++) {
        $result .= mt_rand(0, 9);
    }
    $query = "update items set sku='{$result}' where id='{$id}'";
    $db->query($query);
}