Example #1
0
function session_dump($message)
{
    $ses = db_get_rows('wfpl_sessions', 'id,session_key,length,expires');
    if ($ses) {
        foreach ($ses as $row) {
            list($id, $session_key, $length, $expires) = $row;
            tem_set('id', $id);
            tem_set('session_key', $session_key);
            tem_set('length', $length);
            tem_set('expires', $expires);
            tem_sub('wfpl_sessions_row');
        }
    }
    $data = db_get_rows('wfpl_session_data', 'id,session_id,name,value');
    if ($data) {
        foreach ($data as $row) {
            list($id, $session_id, $name, $value) = $row;
            tem_set('id', $id);
            tem_set('session_id', $session_id);
            tem_set('name', $name);
            tem_set('value', $value);
            tem_sub('wfpl_session_data_row');
        }
    }
    tem_set('message', $message);
    tem_sub('block');
}
Example #2
0
 public function index()
 {
     $vhosts = db_get_rows("select * from vhost");
     //print_r($this->data);
     $this->assign("list", $vhosts);
     $this->view("vhost_index.php");
 }
Example #3
0
function db_get_row($sql)
{
    $list = db_get_rows($sql);
    if (count($list) > 0) {
        return $list[0];
    }
    return "";
}
Example #4
0
 function files()
 {
     $id = intval($_GET['id']);
     $vhost = db_get_row("select * from vhost");
     if ($vhost) {
         $files = db_get_rows("select * from backup");
         $this->assign("list", $files);
         $this->assign("vhost", $vhost);
     }
     $this->view("backup_files.php");
 }
Example #5
0
function db_get_items($offset, $limit, $order = 'id')
{
    $query = '';
    if ($order == 'id') {
        $query = 'select * from `%s` order by id limit %d, %d';
    } elseif ($order == 'price') {
        $query = 'select * from `%s` order by price, id limit %d, %d';
    } else {
        return false;
    }
    $query = sprintf($query, DB_TABLE_NAME, $offset, $limit);
    return db_get_rows($query);
}
Example #6
0
function __pagination_form_new_page($order, $page, $block_data)
{
    $id = $block_data['id'];
    $offset = $page % PAGINATION_WARM_PAGES_STEP * PAGINATION_ROWS_PER_PAGE;
    if ($order == 'id') {
        $query = 'SELECT * FROM `%s` WHERE id>=%d ORDER BY id LIMIT %d,%d';
        $query = sprintf($query, DB_TABLE_NAME, $id, $offset, PAGINATION_ROWS_PER_PAGE);
    } elseif ($order == 'price') {
        $price = $block_data['price'];
        $query = 'SELECT * FROM `%s` WHERE (price=%f AND id>=%d) OR price>%f ORDER BY price, id LIMIT %d,%d';
        $query = sprintf($query, DB_TABLE_NAME, $price, $id, $price, $offset, PAGINATION_ROWS_PER_PAGE);
    } else {
        return false;
    }
    return db_get_rows($query);
}
Example #7
0
<?php

include 'function.php';
$vhosts = db_get_rows("select * from vhost");
?>

<a href="vhost_add.php">add vhost</a>
<table>
<tr>
        <td>domain name</td>
        <td>git</td>
        <td>document_root</td>
        <td>vhost config</td>
        <td>publish</td>
</tr>
<?php 
foreach ($vhosts as $vhost) {
    ?>
<tr>
<?php 
    echo "<td>" . $vhost["domain_name"] . "</td>";
    echo "<td>" . $vhost["git"] . "</td>";
    echo "<td>" . $vhost["document_root"] . "</td>";
    echo "<td>" . $vhost["vhost_conf_file"] . ".conf</td>";
    echo "<td><a href='deployer.php?id=" . $vhost['id'] . "'>deployer</a><td>";
    echo "<td><a href='index.php?c=backup&a=index&id=" . $vhost['id'] . "'>backup</a><td>";
    echo "<td><a href='vhost.php?id=" . $vhost['id'] . "'>edit</a>";
    echo "<a href='vhost_del.php?id=" . $vhost['id'] . "'>delete</a></td>";
    ?>
	
</tr>
Example #8
0
function get_hard_tiles($url)
{
    $query = '';
    foreach ($GLOBALS['url_chars_a'] as $c) {
        if ($query) {
            $query .= ' || ';
        }
        $query .= ' url="' . $url . $c . '"';
    }
    $rows = db_get_rows('tiles', 'url,t32', $quere);
    $ut = array();
    foreach ($rows as $row) {
        list($u, $t) = $row;
        $ut[$u] = $t;
    }
    $ret = array();
    foreach ($GLOBALS['url_chars_a'] as $c) {
        if (isset($ut[$url . $c])) {
            $ret[] = $ut[$url . $c];
        } else {
            $ret[] = str_repeat("", 32 * 32 / 8);
        }
    }
    return $ret;
}
Example #9
0
 private function send_receipt()
 {
     $receive_id = get_request('receive_id');
     $template_name = get_request('template_name');
     $email_from = 'Email From System';
     $receive = db_get_row('Receives', 'id = ' . $receive_id);
     $services = db_get_rows('Services', 'receive_id = ' . $receive_id);
     $helper_names = '';
     foreach ($services as $service) {
         $user = db_get_row('Contacts', 'id = ' . $service['user_id']);
         $helper_names .= '<br>' . $user['full_name'];
     }
     $to_name = $receive['full_name'];
     $to_email = $receive['email'];
     $cc_name = '';
     $cc_email = '';
     $template = db_get_row('Templates', 'template_name = "' . $template_name . '"');
     $subject = revert_entities($template['template_subject']);
     $body = revert_entities($template['template_body']);
     $names = explode(';', get_control_value('System Keys', $email_from));
     $from_name = $names[0];
     $from_email = $names[1];
     $search = array();
     $replace = array();
     $search[] = '+';
     $replace[] = ' ';
     $search[] = '{SERVER_NAME}';
     $replace[] = SERVER_NAME;
     $search[] = '{FULL_NAME}';
     $replace[] = $receive['full_name'];
     $search[] = '{STREET}';
     $replace[] = $receive['street'];
     $search[] = '{CITY}';
     $replace[] = $receive['city'];
     $search[] = '{ZIP}';
     $replace[] = $receive['zip'];
     $search[] = '{STATE}';
     $replace[] = $receive['state'];
     $search[] = '{RECEIVE_ON}';
     $replace[] = format_date($receive['receive_on']);
     $search[] = '{RECEIVE_AMOUNT}';
     $replace[] = $receive['receive_amount'];
     $search[] = '{EVENT_NAME}';
     $replace[] = get_session('event_name');
     $search[] = '{HELPER_NAMES}';
     $replace[] = $helper_names;
     $subject = str_replace($search, $replace, $subject);
     $body = str_replace($search, $replace, $body);
     email_now($from_email, $from_name, $to_email, $to_name, $cc_email, $cc_name, $subject, $body);
     $return = array();
     $return['status'] = 'ok';
     $return['message'] = 'Email sent out, the template: ' . $template_name;
     echo json_encode($return);
 }
Example #10
0
/**
 *	invoice to Dyer from ShipDyer
 *
 * @param	int		shipdyer_id
 * @return	int		count of Records generated
 */
function JKY_invoice_dyer($the_id)
{
    $domain = get_config_value('NFe Dyer', 'domain');
    $my_return = json_decode(proxy($domain, 'data={"method":"check_status"}'), true);
    if (!isset($my_return['status'])) {
        JKY_echo_error('domain [' . $domain . '] is not active');
        return;
    }
    if ($my_return['status'] != 'ok') {
        JKY_echo_error($my_return['message']);
        return;
    }
    $db = Zend_Registry::get('db');
    $ship_dyer = db_get_row('ShipDyers', 'id=' . $the_id);
    $dyer = db_get_row('Contacts', 'id=' . $ship_dyer['dyer_id']);
    $company['pessoa'] = $dyer['is_company'] == 'Yes' ? 'J' : 'F';
    $company['name'] = $dyer['full_name'];
    $company['fantasia'] = $dyer['nick_name'];
    $company['email'] = $dyer['email'];
    $company['phone'] = $dyer['phone'];
    $company['fax'] = $dyer['fax'];
    $company['cnpj'] = $dyer['cnpj'];
    $company['ie'] = $dyer['ie'];
    $company['district'] = $dyer['district'];
    $company['number'] = $dyer['st_number'];
    $company['cpl'] = $dyer['st_cpl'];
    $company['street1'] = $dyer['street1'];
    $company['street2'] = $dyer['street2'];
    $company['zip'] = $dyer['zip'];
    $company['city'] = $dyer['city'];
    $company['state'] = $dyer['state'];
    $company['country'] = $dyer['country'];
    $my_return = json_decode(proxy($domain, 'data={"method":"add_company", "row":' . json_encode($company) . '}'), true);
    $my_id = $my_return['id'];
    log_sql('Dyer', 'INSERT', $my_id);
    $transport = db_get_row('Contacts', 'id=' . $ship_dyer['transport_id']);
    $company['pessoa'] = $transport['is_company'] == 'Yes' ? 'J' : 'F';
    $company['name'] = $transport['full_name'];
    $company['fantasia'] = $transport['nick_name'];
    $company['email'] = $transport['email'];
    $company['phone'] = $transport['phone'];
    $company['fax'] = $transport['fax'];
    $company['cnpj'] = $transport['cnpj'];
    $company['ie'] = $transport['ie'];
    $company['district'] = $transport['district'];
    $company['number'] = $transport['st_number'];
    $company['cpl'] = $transport['st_cpl'];
    $company['street1'] = $transport['street1'];
    $company['street2'] = $transport['street2'];
    $company['zip'] = $transport['zip'];
    $company['city'] = $transport['city'];
    $company['state'] = $transport['state'];
    $company['country'] = $transport['country'];
    $my_return = json_decode(proxy($domain, 'data={"method":"add_company", "row":' . json_encode($company) . '}'), true);
    $my_id = $my_return['id'];
    log_sql('Transport', 'INSERT', $my_id);
    $i = 0;
    $total_volume = 0;
    $items = array();
    $loadouts = db_get_rows('LoadOuts', 'shipdyer_id=' . $the_id);
    foreach ($loadouts as $loadout) {
        $loadquots = db_get_rows('LoadQuotations', 'loadout_id=' . $loadout['id']);
        foreach ($loadquots as $loadquot) {
            $pieces = db_get_rows('Pieces', 'load_quot_id=' . $loadquot['id']);
            $order = db_get_row('Orders', 'id=' . $pieces[0]['order_id']);
            $ftp = db_get_row('FTPs', 'id=' . $order['ftp_id']);
            $prod = db_get_row('Products', 'id=' . $order['product_id']);
            $total_weight = 0;
            foreach ($pieces as $piece) {
                $total_volume++;
                $total_weight += $piece['checkin_weight'];
            }
            $item['NFe_id'] = 'null';
            $item['cProd'] = get_config_value('NFe Dyer', 'cProd');
            $item['xProd'] = $prod['product_name'];
            $item['cor_code'] = get_config_value('NFe Dyer', 'cor_code');
            $item['cor_type'] = get_config_value('NFe Dyer', 'cor_type');
            $item['composicao'] = $ftp['composition'];
            $item['NCM'] = get_config_value('NFe Dyer', 'NCM');
            $item['CFOP'] = get_config_value('NFe Dyer', 'CFOP');
            $item['uCom'] = get_config_value('NFe Dyer', 'uCom');
            $item['qCom'] = $total_weight;
            $item['vUnCom'] = get_config_value('NFe Dyer', 'vUnCom');
            $item['orig'] = get_config_value('NFe Dyer', 'orig');
            $item['CST_ICMS'] = get_config_value('NFe Dyer', 'CST_ICMS');
            $item['CST_IPI'] = get_config_value('NFe Dyer', 'CST_IPI');
            $item['pIPI'] = get_config_value('NFe Dyer', 'pIPI');
            $item['pPIS'] = get_config_value('NFe Dyer', 'pPIS');
            $item['pCOFINS'] = get_config_value('NFe Dyer', 'pCOFINS');
            $items[$i] = $item;
            $i++;
            $product['product_code'] = get_config_value('NFe Dyer', 'cProd');
            $product['product_cf'] = get_config_value('NFe Dyer', 'NCM');
            $product['IPI_code'] = get_config_value('NFe Dyer', 'CST_IPI');
            $product['IPI_aliquota'] = get_config_value('NFe Dyer', 'pIPI');
            $product['product_title'] = $prod['product_name'];
            $product['composicao'] = $ftp['composition'];
            $my_return = json_decode(proxy($domain, 'data={"method":"add_product", "row":' . json_encode($product) . '}'), true);
            $my_id = $my_return['id'];
            log_sql('Product', 'INSERT', $my_id);
        }
    }
    $my_count = 0;
    $nfe['dEmi'] = get_date();
    $nfe['dSaiEnt'] = get_date();
    $nfe['tpNF'] = get_config_value('NFe Dyer', 'tpNF');
    $nfe['natOp'] = get_config_value('NFe Dyer', 'natOp');
    $nfe['dxNome'] = $dyer['full_name'];
    $nfe['txNome'] = $transport['full_name'];
    $nfe['modFrete'] = get_config_value('NFe Dyer', 'modFrete');
    $nfe['qVol'] = $total_volume;
    $nfe['esp'] = get_config_value('NFe Dyer', 'esp');
    $nfe['marca'] = get_config_value('NFe Dyer', 'marca');
    $nfe['pesoL'] = '0';
    $nfe['infCpl'] = get_config_value('NFe Dyer', 'infCpl');
    log_sql('NFe', 'BEFORE INSERT', json_encode($nfe));
    $my_return = json_decode(proxy($domain, 'data={"method":"add_nfe", "row":' . json_encode($nfe) . '}'), true);
    $my_nfe_id = $my_return['id'];
    if ($my_nfe_id) {
        $my_count++;
    }
    log_sql('NFe', 'INSERT', $my_nfe_id);
    foreach ($items as $item) {
        $item['NFe_id'] = $my_nfe_id;
        $my_return = json_decode(proxy($domain, 'data={"method":"add_nfeitem", "row":' . json_encode($item) . '}'), true);
        $my_id = $my_return['id'];
        if ($my_id) {
            $my_count++;
        }
        log_sql('NFeItem', 'INSERT', $my_id);
    }
    $sql = 'UPDATE ShipDyers' . '   SET status = "Active"' . ' WHERE id = ' . $the_id;
    log_sql('ShipDyers', 'UPDATE', $sql);
    $db->query($sql);
    insert_changes($db, 'ShipDyers', $the_id);
    JKY_echo_count($my_count);
}