Steve21 Posted October 20, 2016 Posted October 20, 2016 The site is custom made, the Bootstrap theme was purchased (I think it was Material Admin). PHP/MySQL on IIS with adLdap to get staff details. That's also linked in with their SIMS timetable which updates hourly. Sticky notes, room lookups, search timetable, emergency contact, network status is all custom. The weather is a jQuery plugin, can't remember which but if anyone wants it I'll check it out. Don't suppose you fancy throwing a copy of yours up too as well as Pete? Need to re-do ours over half-term as binning Frog "again" Steve
SteveM555 Posted October 20, 2016 Posted October 20, 2016 Don't suppose you fancy throwing a copy of yours up too as well as Pete? Need to re-do ours over half-term as binning Frog "again" Steve I don't think I'll be able to post it up as is, as it's got a paid premium template (MaterialAdmin) in it and I can't distribute that... If you want code though just let me know.
bossman Posted October 20, 2016 Posted October 20, 2016 This is currently our Staff and Students browser page within our Moodle VLE Staff: Student: Work in progress at the moment. PHP and MySQL
FragglePete Posted October 20, 2016 Posted October 20, 2016 (edited) See attached. I've gone through and modified the code that has various links, usernames, servernames, passwords, etc and stripped them out. You'll need to amend the file in the Connections directory that links to the Database The ad.php and adLDAP.php files will need amending with various AD Info (Base DN, Domain Name, etc, etc) Some of the Icons on the index.php only appear if your a member of the 'Staff' AD Group - change this if your Staff AD Group is called something else. I've included the photoshop files I've used to build the icons with. The admin directory which contains the files for administrating the notices I protect with NTFS permissions so only members of a particular AD group can access and make changes to notices, etc - it's very simple. PaperCut Widget files will also need amending with your PaperCut server name if your using PaperCut. The main page does pull in the BING home page image on each load which I appreciate isn't ideal, but it works and looks pretty - I was planning on amending the code so it only pulls in the image once a day and saves it locally on the server (something fancy that looks at the date of the file and grabs the image if the date is different from today or something, but haven't really got around to doing it). The current approach obviously has an impact on your connection but the page does fail to load if your internet connection goes out. (Happens every now and then). As I said earlier, I'm not a programmer - I tinker with code and blunder along getting things working. I use Dreamweaver to help with most stuff but will play with PHP code myself (which I love as a coding language). I appreciate many peeps on here will rip it apart, but, I'm open to suggestions on how the code should be. Oh.... and there's a .sql file in there too which gives you the structure of the database used. Hope you can get it working for you. Petecwsportal.zip Edited October 20, 2016 by FragglePete 4
Steve21 Posted October 20, 2016 Posted October 20, 2016 I don't think I'll be able to post it up as is, as it's got a paid premium template (MaterialAdmin) in it and I can't distribute that... If you want code though just let me know. Aye sorry meant the code behind Would be appreciated! Trying to work head around few bits like the timetables Steve
SteveM555 Posted October 20, 2016 Posted October 20, 2016 Aye sorry meant the code behind Would be appreciated! Trying to work head around few bits like the timetables Steve No problem, will package some stuff up and send it over. 1
Steve21 Posted October 20, 2016 Posted October 20, 2016 Thank you both @FragglePete @SteveM555 appreciate both of you uploading your work Steve
mdrabble Posted October 20, 2016 Posted October 20, 2016 @FragglePete thank you for sharing your code - really appreciate it
Theldron Posted October 20, 2016 Posted October 20, 2016 How do you go about extracting the SIMS timetable to your intranet? I am creating mine in sharepoint, (will send a screenshot on Monday when I am back in). Cheers
Liam Posted October 21, 2016 Posted October 21, 2016 How do you go about extracting the SIMS timetable to your intranet? I am creating mine in sharepoint, (will send a screenshot on Monday when I am back in). Cheers commandreporter. works a treat
Steve21 Posted October 26, 2016 Posted October 26, 2016 How are people doing the timetable part, I thought there'd be a nice simple pre-made template for it but can't find what it's using in terms of the "timetable button". And then what are you using something like EmployeeID/No. to link it to the user? Thanks, Steve
Liam Posted October 26, 2016 Posted October 26, 2016 Yes we use attributes from sims and put them into active directory. Once they are matched the staff member gets their timetable on the homepage. We use admission number for pupils 1
Theldron Posted October 27, 2016 Posted October 27, 2016 I am probably being simple and a pain, but has anyone got a guide on how to extract timetables from SIMS and put them into an intranet page?
Liam Posted October 27, 2016 Posted October 27, 2016 I am probably being simple and a pain, but has anyone got a guide on how to extract timetables from SIMS and put them into an intranet page? Have you used command reporter? How are you displaying them?
Steve21 Posted October 27, 2016 Posted October 27, 2016 Have you used command reporter? How are you displaying them? See I've been trying with the command reporter and can't work out a nice way of listing a timetable for the student (Seems the "timetable" option isn't schedulable?), unless you're putting each lessons students etc and doing some work on it after before serving it up? Steve
Liam Posted October 27, 2016 Posted October 27, 2016 Command reporter directly into sql then php to pull it out and display accordingly. Works well enough, although im the the guy who designed it. My techie would be able to assist further if you wanted. 1
Steve21 Posted October 27, 2016 Posted October 27, 2016 Command reporter directly into sql then php to pull it out and display accordingly. Works well enough, although im the the guy who designed it. My techie would be able to assist further if you wanted. Would certainly be interested if you don't mind Trying to polish off our new intranet, and know timetables is a big one they wanted. It's mainly two parts I guess, whether you're using one report to extract data or are you pulling like Rooms, then Classes, then Students etc, and if you have a snazzy query that pulls it out in a nice form etc (Not much right! haha) Thanks, Steve
Liam Posted October 27, 2016 Posted October 27, 2016 Would certainly be interested if you don't mind Trying to polish off our new intranet, and know timetables is a big one they wanted. It's mainly two parts I guess, whether you're using one report to extract data or are you pulling like Rooms, then Classes, then Students etc, and if you have a snazzy query that pulls it out in a nice form etc (Not much right! haha) Thanks, Steve Drop me a pm and I'll forward it to my techie for you
Theldron Posted October 28, 2016 Posted October 28, 2016 Have you used command reporter? How are you displaying them? I have used Command Reporter though it was a while ago. I started to create the intranet in sharepoint, will I need to scrap this in favour of another mean of creating it? Lets just say programming or web development, not one of my strong points.
Liam Posted October 28, 2016 Posted October 28, 2016 I have used Command Reporter though it was a while ago. I started to create the intranet in sharepoint, will I need to scrap this in favour of another mean of creating it? Lets just say programming or web development, not one of my strong points. Same here really, I just know enough to get me by. My techie knows considerably more. Ours is built internally through a mixture of languages . I couldn't comment on whether it would work on sharepoint . I'm happy for you to have a chat with my techie though. He's the best person to speak with
Theldron Posted October 28, 2016 Posted October 28, 2016 My techie was really good with that sort of thing but we never got round to building a intranet. He left in the summer and they are not replacing him, but I am determined to build a intranet with timetables on. If I could speak to your techie, just to point me in the right direction really to get me started, I would really appreciate it?
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now