jersobh

Simulate a scanned PDF with ImageMagick

1. Download and install Ghostscript and ImageMagick + Convert Module
2. Execute the following command in the console (change the filename)

$ convert -density 200 INPUT.pdf -rotate 0.3 +noise Multiplicative -format pdf  -quality 85 -compress JPEG -colorspace gray OUTPUT.pdf

Description of the options

• -density: set the input DPI to 200
• -rotate: set Page rotation to 0.3 degrees

jersobh

 $near = "SELECT c.id, c.name, c.email, c.phone, c.logo, c.banner, c.description, cl.lat, cl.lng, 
        ACOS( SIN( RADIANS( cl.lat ) ) * SIN( RADIANS( '$lat' ) ) + COS( RADIANS( cl.lat ) )
        * COS( RADIANS( '$lat' )) * COS( RADIANS( cl.lng ) - RADIANS( '$lng' )) ) * 6380 AS distance
        FROM CLIENT_LOCATION cl
        INNER JOIN CLIENT c
        on cl.client_id = c.id
        WHERE
        ACOS( SIN( RADIANS( cl.lat ) ) * SIN( RADIANS( '$lat' ) ) + COS( RADIANS( cl.lat ) )
        * COS( RADIANS( '$lat' )) * COS( RADIANS( cl.lng ) - RADIANS( '$lng' )) ) * 6380 < 10
        ORDER BY distance ASC";