7
@db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
14
fil = "WHERE " + @filtro
17
ord = "ORDER BY " + @orden
19
sql = "SELECT * FROM " + @tabla + " " + ord + " " + fil
21
@registro = res.fetch_hash
40
@db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
42
@tabla= @db.query('SELECT * FROM ' + @nombre)
48
fil = " WHERE " + @filtro
51
ord = " ORDER BY " + @orden
53
sql = "SELECT * FROM " + @nombre + fil + ord
54
@tabla = @db.query(sql)
68
@registro = @tabla.fetch_hash
74
sql = "UPDATE " + @nombre + " SET "
75
@registro.each do |x,y|
80
sql = sql + x + '="' + y + '",'
83
sql = sql[0..-2] + ' WHERE ' + @filtro
87
sql = "INSERT INTO " + @nombre + " SET "
88
@registro.each do |x,y|
93
sql = sql + x + '="' + y + '",'
102
attr_accessor :table, :where, :order_by, :limit
103
def initialize(tabla)
105
@db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
118
sql = "SELECT * FROM #{@table}"
120
sql = sql + " WHERE #{@where} "
123
sql = sql + " ORDER BY #{@order_by} "
126
sql = sql + " LIMIT #{@limit}"
130
def get_record(campo,valor)
131
sql = "SELECT * FROM #{@table} WHERE #{campo}='#{valor}'"
133
fil = res.fetch_hash()
138
def liquidacion(campo,clave)
139
db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
140
sql_liq = 'SELECT * FROM liquidacion WHERE '+campo+' = "'+ clave + '"'
141
res_liq = db.query(sql_liq)
144
def empleados(campo,clave)
145
sql_emp = 'SELECT * FROM empleados WHERE '+ campo+'="'+clave+'"'
146
res_emp = mysql_query(sql_emp);
147
return mysql_fetch_array(res_emp);
149
def det_liquidacion(campo,clave)
150
sql_det = 'SELECT * FROM det_liquidacion WHERE '+campo+'="'+clave+'"'
151
res_det = mysql_query(sql_det);
152
return mysql_fetch_array(res_det)
154
def tabla(tabla,campo,clave)
155
sql = 'SELECT * FROM ' + tabla + ' WHERE ' + campo + '="' + clave + '"'
156
db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
160
def tabla_ordenada(tabla,campo,orden)
161
sql = "SELECT * FROM #{tabla} ORDER BY #{campo} #{orden}"
162
db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
167
db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
172
db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
176
def tabla_simple(nombre)
177
db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
178
res = db.query('SELECT * FROM '+ nombre)
181
def buscar_registro(tabla,campo,filtro)
182
db = Mysql.real_connect("localhost","mescobal","pacu2000","Alianza")
183
sql = "SELECT * FROM #{tabla} WHERE #{campo} = '#{filtro}'"