Categories
PHP

Laravel : Customize Pagination on API Resource Collection

Laravel from 5.5 / 5.6 has been tested with this solution! You want to wrap your model collection into a resource collection but as you might using the Vue-Pagination which need to be outwrapping the meta and links key. So, you want something as expected output above related to pagination keys. In short, here is…

Categories
PHP Website

Tips: The site is experiencing technical difficulties

Open the website, you receive a message: “This site is experiencing difficulties.“ And if you open admin page, it added another detail as: “This site is experiencing difficulties. Please check your site admin email inbox for instruction” So it’s telling you check email of an Admin user and of course, if you are lucky, you…

Categories
Windows

Windows 10: Change Language Case

On my Windows 10 Pro / Microsoft Surface 6 Pro, I did a setup wrong from the beginning to select UK as my language/keyboard and it’s likes nightmare as I cannot completely remove it, it did remove each time I tried around such as follow this post, or this post, etc. as it may randomly…

Categories
How-To Java Reporting

Jasper Report: Print Column Footer only at the last page

Report designer mostly said it’s depended on the way you design the report, of course, it does but for some new or even some years report designers still need example, tips to help too. Here, I take this kind of issue/solution that finally I could make it: “printing a signature footnote to the last table…

Categories
MySQL

MySQL 8 : About GRANT / PRIVILEGES

In previous version of MySQL (before v8), we can grant/create mysql user one and grant it at once to get access by each host (location / 127.0.0.1) base on your mysql config. In MySQL 8, you no longer can (implicitly) create a user using the GRANT command. You need to do by CREATE USER and…

Categories
Java Reporting

Jasper Report: Total Pages

To have total pages, you can do two options: On view using $V{PAGE_NUMER} flexible using evaluation time: current page with “Now”, total page with “Report” Create a variable for total page Name: TOTAL_PAGES (or any other) Variable class: Integer Calculation: highest Reset type: report Increment type: page Variable expression: ${PAGE_NUMBER} Then you can use on…

Categories
Access DB VBA

VBA MS Access for 32-bits / 64-bits – PtrSafe declaration

The message is clear: The expression On Load you entered as the event property setting produced the following error: The code in this project​ must be updated for use on 64-bit system. Please review and update Declare statements and then mark them with the PtrSafe attribute. So the issue is linked to declare function or…

Categories
Access DB VBA

VBA Converting Khmer Numeric to Ascii for TextBox Number

The error message: The value you entered isn’t valid for this field. For example, you may have entered text in a numeric field or a number that is larger than the FieldSize settings permits. MS Access 2010 Above error is simple for us as our characters are in Unicode and of course, if we check…

Categories
General

VueJS – Implement Oganization Chart with Title

I use this Vue Wrapper: OrgChart JS At first, I could not figure out the chart to display: name + title. Finally I got the point! Here how I go… Install npm install vue-orgchart -S And setting up the style per its website. Implementation export default { components: { VoBasic }, data () { return…

Categories
PHP

[Laravel+DBAL] Doctrine\DBAL\Driver\PDOStatement contains 3 abstract methods

I though before not to share every error I met during the development I did so far but it’s just facing more often with the same issue so let’s make it documents for others. I have a Laravel 5.5.* and use the package: Doctrine\DBAL which is on version v2.5.13, it was working fine, it might…