Skip to main content

Posts

Showing posts from May, 2017

To Get the Date Diffence of the Current_date and FirstNoticeDate

In every scenario, the date functions and calculations are more import and effective way to have it. Here I used to get the correct and notice date as an example.  I'm just converting the DateTime to the temp value and stored in a variable. Then I go for the calculation the differences of the dates (i.e). The current date and notice date /*  *@ TO Get the Date Difference of the Current_date and FirstNoticeDate *@ Param Current_date, FirstNoticeDate. *@ Return Due Days */ function Days_Different($current_date, $notice_date) { //To Change the Date Format to StringtoTime: $temp_current_date = strtotime($current_date); $temp_notice = strtotime($notice_date);   // Calculate the Date Difference for the Days   $days_difference = (($temp_current_date - $temp_notice) / (60*60*24));   return $days_difference; } Reference : http://stackoverflow.com/questions/2040560/finding-the-number-of-days-between-two-dates

Invalid arguments passed in php

/********************************************************************************/ /* TITLE :  Invalid arguments passed in php /* DESCRIPTION :  To Solve the Invalid arguments passed in php /* CREATED BY   :  Jemiris Selvi S /* CREATED ON :  24-May-2017 /* MODIFIED BY :  Jemiris Selvi S /* MODIFIED ON :  24-May-2017 /********************************************************************************/ Problem :   implode() invalid arguments passed in php Answer : //Need Initialize an Array while parsing in the parameter. $condition  =  array(); $finalcondition = implode(' AND ',$condition);

To Get the Multiple Values in a Diffent or Same Table

/******************************************************************************/ /* TITLE : Sub Query /* DESCRIPTION     : To Get the Multiple Values in a Diffent or Same Table /* CREATED BY   : Jemiris Selvi S /* CREATED ON : 23-May-2017 /* MODIFIED BY : Jemiris Selvi S /* MODIFIED ON : 23-May-2017 /******************************************************************************/ Example: SELECT municipality,        municipality_label                 AS COUNTY,        Count(*)                           AS PURCHASED,        ( Sum(CASE lrf_redeemed                WHEN '1' THEN 1                ELSE 0              END) )                       AS REDEEMED,        (SELECT Count(*)         FROM   pmt_lien         WHERE  judgement_date IS NOT NULL)AS JUDGEMENT_DATE,        (SELECT Count(*)         FROM   pmt_lien         WHERE  write_off_date IS NOT NULL)AS WRITE_OFF_DATE FROM   pmt_lien WHERE  municipalit

Deleting a Windows Service in Command Prompt

Deleting a Windows Service The first thing you’ll need to do is identify the name of the service, so open up Services through the start menu or control panel, and then find the service in the list that you want to delete. If you can’t figure out how to open it, use WIN + R and type in  services.msc. You’ll want to open up the properties by double-clicking on the service name, and then highlight the “Service name” value and copy it to the clipboard. This is what we’ll need to disable it. You’ll need to open up a command prompt, and if you are using Windows 7, Windows 8, Windows 10, or Vista you’ll need to right-click the command prompt and choose Run as Administrator. We’ll use the sc command to actually do the work. The syntax used to delete a service is this: sc delete ServiceName If your service name has spaces in it, you’ll need to wrap the service name in quotes, like this: sc delete “Adobe LM Service” Note that I’m not recommending deleting this particu

Create a Plugin in the in Linux for Processmaker 3.0

**************************************************************************   To Create a Plugin in the in Linux for Processmaker 3.0 ************************************************************************** Now let us create the plugin using Linux/ ret hat os for the processmaker. The main Steps to Plugins can not be created on Windows servers, because Windows does not support symbolic links; however, there is an experimental script for Windows servers available at <INSTALL-DIRECTORY>/workflow/engine/gulliver-win.bat which can be tested. http://wiki.processmaker.com/3.0/Plugin_Development The steps are given below as a step by step please follow this any query just post commands. Step :1 ============ root@BPMServer:~# # ln -s /opt/processmaker/gulliver/bin/gulliver /opt/processmaker/workflow/engine ******************************************************************** Step :3 ============ root@BPMServer:~# cd /opt/processmaker/workflow/engine *************************

Create a Plugin in the in Windows for Processmaker 3.0

**************************************************************************   To Create a Plugin in the in Windows for Processmaker ************************************************************************** Now let us create the plugin using windows os for the processmaker. The main Steps to Plugins cannot be created on Windows servers, because Windows does not support symbolic links; however, there is an experimental script for Windows servers available at <INSTALL-DIRECTORY>/workflow/engine/gulliver-win.bat which can be tested. http://wiki.processmaker.com/3.0/Plugin_Development The steps given below as a step by step please follow this any query just post commands. Step :1 ============ C:\Bitnami\processmaker-3.1-1\apps\processmaker\htdocs\workflow\engine>gulliver-win.bat new-plugin deleteCases using DSN Connection The plugin deleteCases exists in this file C:\Bitnami\processmaker-3.1-1\apps\pr ocessmaker\htdocs\workflow\engine\plugins\deleteCases\class.deleteCas