Skip to content

Instantly share code, notes, and snippets.

View jbagaresgaray's full-sized avatar
🏠
Working from home

Philip Cesar Garay jbagaresgaray

🏠
Working from home
View GitHub Profile
@jbagaresgaray
jbagaresgaray / company.vb
Created February 8, 2017 09:50
HRIS Company API
Option Explicit On
Imports MySql.Data.MySqlClient
Module modCompany
Public Structure Company_Info
Dim ci_id As Integer
Dim ci_name As String
Dim ci_fax As String
Dim ci_telephone As String
@jbagaresgaray
jbagaresgaray / department.vb
Last active February 8, 2017 09:49
HRIS Department API
Option Explicit On
Imports MySql.Data.MySqlClient
Module modDepartment
Public Structure tDepartment
Dim d_id As Integer
Dim d_name As String
Dim d_addedby As Integer
Dim d_dateadded As Date
@jbagaresgaray
jbagaresgaray / employee.vb
Last active February 8, 2017 07:29
HRIS Employee API
Option Explicit On
Imports MySql.Data.MySqlClient
Module modEmployees
Public Structure Employees
Dim e_id As Integer
Dim e_idno As String
Dim e_deviceno As String
Dim e_ssno As String
@jbagaresgaray
jbagaresgaray / camera.ts
Created February 8, 2017 07:15
Ionic 2 Camera and Library
import { Component } from '@angular/core';
import { NavController, ActionSheetController, AlertController, Platform } from 'ionic-angular';
import { Camera, EmailComposer } from 'ionic-native';
/*
Generated class for the Camera page.
See http://ionicframework.com/docs/v2/components/#navigation for more info on
Ionic pages and navigation.
// Last time updated at Wednesday, March 16th, 2016, 11:18:45 AM
// Quick-Demo for newbies: http://jsfiddle.net/c46de0L8/
// Another simple demo: http://jsfiddle.net/zar6fg60/
// Latest file can be found here: https://cdn.webrtc-experiment.com/RTCMultiConnection.js
// Muaz Khan - www.MuazKhan.com
// MIT License - www.WebRTC-Experiment.com/licence
// Documentation - www.RTCMultiConnection.org/docs
@jbagaresgaray
jbagaresgaray / attachmentsample.html
Created August 25, 2016 08:16
attachmentsample
<!doctype html>
<html ng-app="tessaApp">
<head>
<meta charset="UTF-8" class="ng-scope">
<title class="ng-scope">Title</title>
<link href="https://fonts.googleapis.com/css?family=Roboto:400,500,400italic,900,300,300italic" rel="stylesheet" type="text/css" class="ng-scope">
<style type="text/css">
body {
font-family: Roboto, sans-serif;
@jbagaresgaray
jbagaresgaray / ios7.phonegap.cordova.js
Last active August 29, 2015 14:26 — forked from shazron/ios7.phonegap.cordova.js
PhoneGap / Apache Cordova - top margin for iOS 7
// Pre-requisites:
// 1. Device core plugin
// 2. Splashscreen core plugin (3.1.0)
// 3. config.xml: <preference name="AutoHideSplashScreen" value="false" />
// 4. config.xml: <preference name="DisallowOverscroll" value="true" />
function onDeviceReady() {
if (parseFloat(window.device.version) >= 7.0) {
document.body.style.marginTop = "20px";
// OR do whatever layout you need here, to expand a navigation bar etc
@jbagaresgaray
jbagaresgaray / 0_reuse_code.js
Last active August 29, 2015 14:10
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@jbagaresgaray
jbagaresgaray / hr_db_dti.sql
Created January 6, 2014 02:42
HRIS LGU version
-- CREATE DATABASE IF NOT EXISTS `hr_db_dti` /*!40100 DEFAULT CHARACTER SET latin1 */;
-- USE `hr_db_dti`;
-- MySQL dump 10.13 Distrib 5.6.11, for Win32 (x86)
--
-- Host: localhost Database: hr_db_dti
-- ------------------------------------------------------
-- Server version 5.6.12-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;