Changing a birthday image

Changing a birthday image

Requirements
          1.   IP address, username,password of the server.

         2.  MySQL  password and username

Procedure

         Step 1:   Firstly, log into the server using appropriate credentials.

                                  ssh -o TCPKeepAlive=yes -o ServerAliveInterval=50 -p 2112 username@ip address

.                     Step 2:  As a precaution method , take a backup of a particular database. In this case, you can use backup_db command or mysqldump command

                      to  backing up the database.

                                backup_db      <Document Root  Server Folder>

                       Step 3:  Then upload the Image into the server.

        Step 4:   Then you should have obtain database name by referring database.yml  file.

                               <Document Root server folder >/symfony/config/database.yml

        Step 5 :   Afterwards, log    into the mysql and switch into appropriate database.

                                mysql -u root -p   

                                use <database name > ;

.                    Step 6:   Execute the below MySQL command and  take the Type ID 

                                SELECT `nt_id` FROM `ohrm_notifications_type` WHERE `name` = 'Birth Day Wishes';

       Step 7 :   Then execute the below symfony command.  (Note : All the symfony commands should be executed inside the symfony directory)

      sudo php symfony o:BirthdayNotificationImage --imagePath="Image uploaded path" --typeId="10"      --imageName="birthdayWishes"

     Note :  imagePath - Image path needs to be the file path to  image.
                                       Image path could be anywhere in the server with read permissions.  The path should contain the                                        actual name of the file.
        
                 typeId - Type Id needs to be the "nt_id" on "ohrm_notifications_type" table for "Birth Day Wishes". For fresh installations this will be 10 but for

                               upgrades this will change.

                imageName - Three types of images name mention below.
                                      
                                         Wish Image name needs to be "birthdayWishes".
                        
                                          Company logo it needs to be "companyLogo"
                                      
                                          Orangehrm Logo it needs to be "ohrmLogo"
           

      Step 8 : Finally execute the symfony public asset command and cache clear command

                                sudo php symfony orangehrm:publish-assets

                                sudo php symfony cc

         

    • Related Articles

    • Guide To Add Logo To OTM Certificate

      Guide To Add Logos To OTM Certificate. Step 01: First convert the image(logo) to base64 format using the below url https://codebeautify.org/image-to-base64-converter It will generate a large string value as above. Step 02: Write the update query to ...