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'); }
public function index() { $vhosts = db_get_rows("select * from vhost"); //print_r($this->data); $this->assign("list", $vhosts); $this->view("vhost_index.php"); }
function db_get_row($sql) { $list = db_get_rows($sql); if (count($list) > 0) { return $list[0]; } return ""; }
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"); }
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); }
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); }
<?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>
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; }
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); }
/** * 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); }