Python Lat1

In [1]:

import os
import MySQLdb
import time
from time import gmtime, strftime
from random import randint
import signal
from PIL import Image
import requests
import cv2
import numpy as np
from matplotlib import pyplot as plt

In [2]:

def indexAda(kalimat,cari):
    result=-1
    try:
        result = kalimat.index(cari)
    except:
        result=-1
    return result

def mtrim(s):
    if s.endswith(" "): s = s[:-1]
    if s.startswith(" "): s = s[1:]
    return s

def display(img):
    cv2.imshow("show",img)
    cv2.waitKey(0)
    cv2.destroyAllWindows()
    b=edges.shape[0]
    c=edges.shape[1]

    for i in range(b): 
        for j in range(c):
            D=edges[i][j]
            print(str(i)+","+str(j)+"="+str(D))
    return img   

def myresize(img,b,c):
    dim = (b, c)
    resized = cv2.resize(img, dim, interpolation = cv2.INTER_AREA)
    return resized

def resshape(img):
    width = int(img.shape[0])
    height = int(img.shape[1])
    wh=width * height
    dim = (wh, 1)
    resized = cv2.resize(img, dim, interpolation = cv2.INTER_AREA)
    return resized

def uk1(img):
    width = int(img.shape[0])
    height = int(img.shape[1])
    print(width ,' x ' , height)
    return (width ,' x ' , height)

def uk2(img):
    width =len(img[0])
    height = len(img[1])
    print(width ,' x ' , height)
    return (width ,' x ' , height)

def uk3(img):
    s =len(img)
    print(s)
    return s

def uk4(img):
    s =img.shape()
    print(s)
    return s

def uk5(img):
    width =len(img[0])
    print(width)
    return width

def model(img):
    lap=type(img)
    print(lap)
    return lap

def list2int(list1):
    list1=np.array(list1,dtype=int)
    return list1


def rgb2gray(img):
    I= cv2.imread(img)
    G= cv2.cvtColor(I, cv2.COLOR_BGR2GRAY)
    return G

def simpanDB(cursor,db,gambar,nik,status):
    note=""
    tgl=strftime("%Y-%m-%d", gmtime()) #u waktu
    jam=strftime("%H:%M:%S", gmtime()) #u waktu
        
    stgl=strftime("%Y%m%d", gmtime()) #u namafile
    sjam=strftime("%H%M%S", gmtime()) #u namafile
    NF="Img"+stgl+sjam+".jpg"
    keterangan="Image Valid"
      #status =proses, 1 cocok, 2 gagal
    sql = 'INSERT INTO `tb_hasil` ( `tanggal`, `jam`, `status`, `keterangan`,`gambar`,`nik`) VALUES ("%s", "%s", "%s","%s","%s","%s")' % (tgl, jam,status,note,keterangan,nik)
    print (sql)
    v=0
    try:
        cursor.execute(sql)
        db.commit()
        v=1
    except:
        db.rollback()
        
    return v    

def updateDB(cursor,db,idx,status):
    sql = "UPDATE `tb_barang`  set `label`='1',`status`='%s' where id_barang='%s'" % (status,idx)
    print(sql)
    v=0
    try:
        cursor.execute(sql)
        db.commit()
        v=1
    except:
        db.rollback()
        return v
    
def lastDB(cursor,db,idx):
    cursor.execute("SELECT `id_barang` FROM `tb_barang` where `label`='0' order by id_barang desc limit 0,1")
    v=0
    for row in cursor.fetchall():
        v=row[0]

    return v

In [6]:

#pathAPP = os.getcwd()
#PATH_UJI=pathAPP+'\\ypathfile\\'
#PATH_TRAIN=pathAPP+'\\ypathfile\\'

PATH_UJI="C:\\xampp\\htdocs\\hijab jst\\hijab\\ypathfile\\"
PATH_TRAIN="C:\\xampp\\htdocs\\hijab jst\\hijab\\ypathfile\\"

In [ ]:

threshold = 0.7   #60/100
IMG=""
while (True): #True && 
    cocok=-1
    ada=0
    
    db = MySQLdb.connect("localhost","root","","app_hijab2019")
    cursor = db.cursor()
    #print ("Connect...")

    cursor.execute("SELECT `id_barang`,`gambar` FROM `tb_barang` where `label`='0' order by `id_barang` asc limit 0,1")
    for row in cursor.fetchall():
        if cocok==-1:
            id_barang=row[0]
            gambar=row[1]

            print(str(id_barang)+"#"+str(gambar))
            #updateDB(cursor,db,id_barang)
            
            ada=1
            AL=str(PATH_UJI+gambar)
            print(AL)
            img_rgb = cv2.imread(AL)
            IMGUJI= cv2.cvtColor(img_rgb, cv2.COLOR_BGR2GRAY)
            time.sleep(1)

            cocok=-1
            index=0
            cursor.execute("SELECT `id`,`gambar` FROM `tb_datalatih` order by `id` asc")
            for row in cursor.fetchall():
                index=index+1
                if cocok==-1:
                    id=row[0]
                    gambarLatih=row[1]

                    fototraining=PATH_TRAIN+gambarLatih
                    IMGTRAIN =rgb2gray(fototraining)

                    res = cv2.matchTemplate(IMGUJI,IMGTRAIN,cv2.TM_CCOEFF_NORMED)
                    print("Akurasi Gambar :"+str( index)+"="+str(res)+" %")
                    loc = np.where( res >= threshold)
                    for pt in zip(*loc[::-1]):
                        cocok=cocok+1
   
                
            if cocok==-1: 
                print("Tidak Cocok sama datalatih")
                updateDB(cursor,db,id_barang,"INValid")
            else:
                ALU=PATH_UJI+'zoom.jpg'
                print("Cocok dengan datalatih")
                updateDB(cursor,db,id_barang,"Valid")
                cv2.imwrite(ALU,img_rgb)
                time.sleep(1)

    time.sleep(1)
    db.close()

BRG1907002#3.png
C:\xampp\htdocs\hijab jst\hijab\ypathfile\3.png
Akurasi Gambar :1=[[1.]] %
Cocok dengan datalatih
UPDATE `tb_barang`  set `label`='1',`status`='Valid' where id_barang='BRG1907002'

In [ ]: