Skip to content

Instantly share code, notes, and snippets.

View rodrigobravo's full-sized avatar
💻
keyboard jockey

Rodrigo Bravo rodrigobravo

💻
keyboard jockey
2 followers · 4 following
View GitHub Profile
@rodrigobravo
rodrigobravo / capture.js
Created September 29, 2017 02:22
<?php
include_once 'Class.php';
include_once 'querys.php';
try{
$db = new PDO('sqlite:/home/rodrigo/delivery2/files/database.db');
if(!$db){
echo $db->lastErrorMsg() ;
}else{
@rodrigobravo
rodrigobravo / script.js
Created September 27, 2017 14:21
$(document).ready(function(){
var $div_novospedidos = $('#div_novospedidos');
$div_novospedidos.empty(); //Limpando a tabela
// setTimeout(function(){ location.reload(); }, 5000);
$.get("database3.php", function(data, status){
//if (data == null) {console.log("sem pedidos hoje")} else {console.log("teste")};
var dados_pedido = data;
console.log(dados_pedido);
const obj = dados_pedido;
@rodrigobravo
rodrigobravo / sqlite.sql
Created September 21, 2017 16:27
select DET.ID,
DET.DOCHEADER_ID,
DET.line_number,
DET.description,
DET.qnt,
DET.qnt_base,
DET.qnt_delivered,
DET.pending_qnt,
DET.price,
DET.discount1,
@rodrigobravo
rodrigobravo / insert.ṕhp
Last active September 19, 2017 22:07
try{
$dbdest = new PDO('sqlite:/home/rodrigo/delivery2/files/delivery.db');
foreach ($listaPedidos as $key) {
//var_dump($key);
$sqlinsert = $dbdest->prepare($sqlInsertRequests);
$client_id = $key->client_id;
$funcionario = $key->employee_name;
@rodrigobravo
rodrigobravo / dados.php
Created September 18, 2017 23:39
<?php
include_once 'Pedido.php';
include_once 'querys.php';
try{
$db = new PDO('sqlite:/home/rodrigo/delivery2/files/database.db');
$dbdest = new PDO('sqlite:/home/rodrigo/delivery2/files/delivery.db');
if(!$db){
echo $db->lastErrorMsg() ;
}else{
@rodrigobravo
rodrigobravo / teste.php
Created September 16, 2017 20:42
select
DOCHEADER.ID,
DOCHEADER.DOC_PREFIX,
DOCHEADER.DOC_NUMBER,
DOCHEADER.ACCUMULATOR as acumulador,
DOCHEADER.CLOCK_DATE data_FP,
DOCHEADER.ENTITY_ID as client_id,
ENTITY.DESCRIPTION as cliente,
EMPLOYEE.INTERNAL_NAME as funcionario,
LOCAL.DESCRIPTION as local,
@rodrigobravo
rodrigobravo / comparardata.php
Created September 16, 2017 19:45
$today=date('d-m-Y');
foreach ($linhas as $entrada) {
$reqdate = date("d/m/y",substr($entrada->data_FP,0,-9));
if ($today == $reqdate){
@rodrigobravo
rodrigobravo / cap.php
Created September 15, 2017 19:58
<?php
include_once 'Pedido.php';
try{
$db = new PDO('sqlite:/home/rodrigo/delivery2/files/database.db');
if(!$db) {
echo $db->lastErrorMsg() ;
} else {
$sqlPedidos = "
select
DOCHEADER.ID,
@rodrigobravo
rodrigobravo / ajax.js
Created August 1, 2017 20:57
$(document).ready(function(){
var $tabela_novospedidos = $('#tabela_novospedidos');
$tabela_novospedidos.empty(); //Limpando a tabela
$.get("database2.php", function(data, status){
var dados_pedido = data;
@rodrigobravo
rodrigobravo / ajax.js
Last active July 24, 2017 17:23
$(document).ready(function(){
var $tabela_novospedidos = $('#tabela_novospedidos');
$tabela_novospedidos.empty(); //Limpando a tabela
$.ajax({
type:'post', //Definimos o método HTTP usado
dataType: 'json', //Definimos o tipo de retorno
url: 'database.php',//Definindo o arquivo onde serão buscados os dados
success: function(dados){
var dados_pedido = dados;