hmaddy Posted May 9, 2023 Share Posted May 9, 2023 i need to collect some data from the tblhosting. 1. collect the renewal date and status 2. how to find all the active records which have the packageid as 100 or 101 0 Quote Link to comment Share on other sites More sharing options...
pRieStaKos Posted May 9, 2023 Share Posted May 9, 2023 (edited) 21 minutes ago, hmaddy said: i need to collect some data from the tblhosting. 1. collect the renewal date and status 2. how to find all the active records which have the packageid as 100 or 101 Hello, in which page ? You can try ClientAreaPageProductDetails hook. Otherwise Interact with database Edited May 9, 2023 by pRieStaKos 0 Quote Link to comment Share on other sites More sharing options...
hmaddy Posted May 9, 2023 Author Share Posted May 9, 2023 am trying to collect these data on cron and create a ticket with some condition. for each (Capsule::table('tblhosting')->where("domainstatus", "=", "Active") && ("packageid", "=", "100") || ("packageid", "=", "101") ->get() as $client){ 0 Quote Link to comment Share on other sites More sharing options...
pRieStaKos Posted May 9, 2023 Share Posted May 9, 2023 21 minutes ago, hmaddy said: am trying to collect these data on cron and create a ticket with some condition. for each (Capsule::table('tblhosting')->where("domainstatus", "=", "Active") && ("packageid", "=", "100") || ("packageid", "=", "101") ->get() as $client){ DailyCronjob Your Capsule query could be better. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.